Pie chart based on counts and percentages

Questions & Answers
1

I have a column that lists only Pass or fail. How do create a pie chart out of this that shows the count and percentage of pass and fail?

2

Hi @hari_ramadasan,
You should select chart “Pie” and select data labels “Percentage”

eazyBI_pie_chart
eazyBI_pie_chart1822×1124 114 KB

See more about customizing charts in training episodes 4 and 5: Training videos

best,
Gerda // support@eazyBI.com

3

Thank you !

In the example shown in the image, for each new issue that gets added (in JIRA), there is a Pass/ Fail result calculated based on set parameter. How do I get a consolidated count of pass/fail?

Thanks much
Hari
image

4

Hi @hari_ramadasan,
the best option would be to import the “Result” as a dimension, which will aggregate the values automatically: Data from Jira
The dimension would have values “Pass” and “Fail,” and together with the measure “Issues created,” you would get the report you are interested in.

best,
Gerda

5

Thank you Gerda,

The results are user defined measures on easyBI and not from JIRA. My apologies, must have mentioned earlier.

Thanks
Hari

6

Hi @hari_ramadasan ,
In that case, you can create a new calculated measure with function count() and count how many issues have a particular value:

Count(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    [Measures].[Issues created]>0
    AND
    [Measures].[Issue Result] = 'Pass'
  )
)

best,
Gerda