nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

EazyBI: How to plot chart using Issue category vs Issue created?

unknown

Category: ABC1, ABC2, ABC3...ABC9. There are around 8 to 9 category.

Screenshot 2023-01-21 at 09.02.00.png

How can I plot Bar chart or Table by using Category (Dimension) vs Issue Created (Measures)?

There is only option for status category (To do, In progress and Done) but I am looking for Issue category(Custom field) marked in Red box in above screenshot.

Screenshot 2023-01-21 at 09.50.02.png

Accepted answers

Nauris Malitis -eazyBI-

Hi @[deleted]

@Walter Buggenhout is correct on this one, eazyBI does not yet natively support this field.

However, you can still import this field as a dimension in eazyBI with the help of Advanced settings.

First, you'll need to find the ID of this custom field. You can see this in your Jira -> Settings -> Issues -> Custom fields section by clicking on the "..." and hovering over the "View field information" link:

Now, go to the eazyBI app, open the Advanced settings and paste the following parameters:

[jira.customfield_10044]
name = "Issue Category"
data_type = "string"
dimension = true

Instead of "10044" use the ID you found in your Jira settings.

Save the Advanced settings and go to the "Source Data" tab, click "Edit" on your Jira source, open the "Custom fields" section, and the "Issue Category" field should be visible and available for import. Tick both of the boxes to import it as a dimension and as a property and start the import.

When the import finishes, you should see the new dimension under the "Custom fields" section in your report creation view:

Let me know if this works as expected or if you have any additional questions on this!

Thanks for raising this issue. I've added this to our backlog.

Best regards,

Nauris / eazyBI support

All comments

Walter Buggenhout

Hi @[deleted],

Have a look at the import configuration of the account you imported the issues into and check out the custom fields settings.

It seems as if the category custom field is not being imported. Locate the category field there and import it as a Dimension. If that goes well, the dimension should appear under Custom Fields, where you see Customer and Vehicle Name.

As soon as it appears there, you should be able to select it as a dimension for your report and display the Issues Created measure by category.

Hope this helps!

unknown

Thank you @Walter Buggenhout

Tried that too. It is not appearing in custom field setting as it the locked field, checked from Jira settings>issues>custom field (See the below screenshot)

Screenshot 2023-01-21 at 10.36.25.png

Walter Buggenhout

Is this the category field from Jira Work Management? If so, then maybe importing this into EazyBI is not supported yet (it is a fairly recent feature).

Nauris Malitis -eazyBI-

Hi @[deleted]

@Walter Buggenhout is correct on this one, eazyBI does not yet natively support this field.

However, you can still import this field as a dimension in eazyBI with the help of Advanced settings.

Now, go to the eazyBI app, open the Advanced settings and paste the following parameters:

[jira.customfield_10044]
name = "Issue Category"
data_type = "string"
dimension = true

Instead of "10044" use the ID you found in your Jira settings.

When the import finishes, you should see the new dimension under the "Custom fields" section in your report creation view:

Let me know if this works as expected or if you have any additional questions on this!

Thanks for raising this issue. I've added this to our backlog.

Best regards,

Nauris / eazyBI support

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

eazybi

jira-work-management