eazyBI - pie chart

Dear eazyBI team,

please support me in the following request.

Imagine a report table where issues are in rows. Column contains number of days issue stayed in particular status.

Pages section contains:

  • Project
  • Issue type

Rows section contains:

  • Assignee (for issues "grouping" by assignee)
  • Issue

Columns section contains:

  • Measures - Days in transition status
  • Transition Status - MyStatus member is chosen

Table looks a like this:

|        | Days in transition status |
----------------------------------------------
        |        | MyStatus                  |
----------------------------------------------
Samuel  | Issue1 | 10                        |
        | Issue2 | 15                        |
        | Issue3 | 35                        |
        | Issue4 | 12                        |
        | Issue5 | 33                        |
----------------------------------------------
Jan     | Issue6 | 14                        |
        | Issue7 | 50                        |
...

Then I have marked with red background those cells, where the issue were longer than 14 days in MyStatus.

Green background have issues that were less than 14 days in MyStatus.

BUT now, what I would like to do is to create a PIE CHART that shows (for each assignee and later one for all issues) how many issues are "green" ones and how many are "red" ones. So the ratio between those issues.

Is this possible? How can I achieve this? I believe it can be easily done, but I am new to eazyBI so I need a support from you in this matter.

Do you need any other information?

I look forward to hearing from you soon.

BR

Samuel

1 answer

1 accepted

Hi Samuel,

To create required report we need to change dimensions and create two new calculated measures.

Pages: Project, Issue Type, Status

Columns: Measures

Rows: Assignee

Next we need to create Measure calculated member 'In transition < 14 days' with the formula:

Count(
  Filter(
    [Issue].[Issue].Members,
    [Measures].[Days in transition status] &lt; 14
  )
)

and 'In transition >= 14 days' with the formula:

Count(
  Filter(
    [Issue].[Issue].Members,
    [Measures].[Days in transition status] &gt;= 14
  )
)

Now add these two calculated members as columns and remove others: 'Issues created', 'Issues due' and 'Issues resolved'. 

For rows choose Assignee dimension level User.

Next switch to Pie chart and click on 'Swap axes' button.

Now you should see Pie charts for every user, All Projects, All Issue Types and All Statuses 

With the page dropdowns add necessary filters.

 

Best regards, 

Jānis.

Hello Jānis, this is exactly what I was looking for! Thank you very much for your response. Now I see that it is really simple to create such a pie chart. I did not know where to start before. One more thing that I forgot to mention, I would like to count only those issues, that were created later than certain date. I guess a condition should be placed inside the new calculated members formula (into logical expression part). Is the formula below correct? Count( Filter( [Issue].[Issue].Members, [Measures].[Days in transition status] >= 14 AND DateCompare([Issue].CurrentMember.get('Created at'), 'May 01 2015') >= 0 ) ) Thanks again! BR Samuel Titka

Hi Samuel, The formula is correct. Best regards, Jānis

Hi Jānis! I have tried that and it works as expected. Thank you. Have a nice day!

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,060 views 13 18
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot