Percentage of Jira issue Types per Project

How can I get the Percentage of Jira Issue Types per project?

Lets say we have 2 projects A and B.
A has 100 issues, 10 are of type Task, so this is 10%
B has 200 issues, 40 are of type Task, so this is 20%

We need this for an Issue Type Heat Map for all our 80+ Jira SW Projects

Thanks for helping

Hi @maxweissboeck,

I can think of several solutions for this type of report. I understand that you have quite a lot of projects (more than 80) for this report.

One option, select measure “Issues created” and dimension “Issue Type” on report columns and switch to the Bar chart. Then select option Percentage and eazyBI will show all issue type relative distribution in each project (Create charts - eazyBI for Jira). The report might look like in the picture below:

In the second option, you can show a heatmap in a Table.

  1. Define a new calculated measure to show the relative amount of all issues for the selected issue type.

    --issue count with selected issue type
    [Measures].[Issues created]
    --divided by all issues regardless of issue type
    ([Measures].[Issues created],
    [Issue Type].CurrentHierarchy.DefaultMember)
  2. In report columns, select the new calculated measure and “Issue Type” dimension. In the issue type dimension, select issue types of interest, Task, or more issue types.

  3. Add cell formatting to the new calculated measure and chose option heatmap (Conditional cell formatting - eazyBI). The report might look like in the picture below:

Zane /

Thanks, not quite a tree map, but good enough for now.

Any chance you will add tree maps in upcoming released? So take this as feature request please :slight_smile: