eazyBI - pie chart

[Samuel Titka]

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

[JānisJ · Accepted solution]

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] < 14
  )
)

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

Count(
  Filter(
    [Issue].[Issue].Members,
    [Measures].[Days in transition status] >= 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.

[Samuel Titka]

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

[JānisJ]

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

[Samuel Titka]

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