Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,213
Community Members
 
Community Events
165
Community Groups

Is there way to import Ticket Category to EazyBI

I use the Ticket Category in JSM for report and filters but this doe snot appear to be a field so is there any way for me to import the values EazyBI for reporting on same in place of using the issue type which is too verbose

1 answer

Hi,

Do I understand correctly that "Ticked Category" is a custom field in your Jira?

You can select this field to be imported as a dimension in Import options > Custom field as described in eazyBI documentation.

After data import, you can use this Ticket Category dimension in your JSM reports instead of the Issue type dimension.

Please contact support@eazybi.com  for further assistance.

Ilze, eazyBI Customer Support 

Hi, it is not a custom field. I actually do not know how it is referred to as in JSM. It automatically combines issue types and allows reporting within JSM of Service Requests, Incidents, Changes and Problems. All you have to do in filters or reports is use Ticket Category and the condition instead of using issuetypes. It is a really good way for example to get all service requests regardless of whether they are w/Approval or not and it helps in more consolidated reporting for tickets 

Hi, 

Thank you for the description, it seems we figured out which field it is.

Indeed, there is a hidden JSM standard custom field "Work category". 

CF.png

 

You may use advanced settings in eazyBI to import this field as a dimension: Advanced settings for custom fields

[jira.customfield_NNNNN]
data_type = "string"
dimension = true

 where NNNNN is a "Work category" custom field ID (you can find it in Jira when you open the custom field in View/Edit mode, then you will see it in URL, customFieldId=NNNNN).

After adding advanced settings, select this field in import options, Custom fields tab,  to be imported as a dimension.

Run data import. Then you will find the dimension "Work category" in the eazyBI report builder and can use it in your reports as any other dimension.

report.pngWe added a task to our backlog to consider including this field in the standard JSM integration.

Please contact support@eazybi.com if you need some assistance with this.

Ilze

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

Coming Soon: Insight Changing to Assets

The 2020 acquisition of Mindville added powerful asset and configuration management capabilities to Jira Service Management in the form of Insight. Following the completion of that integration, custo...

251 views 1 9
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you