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 Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

89 views 0 5
Read article

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