Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have a donut pie chat, that shows simply one category of Count 'Open'/'Closed' in a table.
Problem is instead of showing Total Open and Total Closed as it is, I need it show as below logic:
Closed vs (Open + Closed) x 30%, so that my donut demonstrate the progress to close 30% of total cases, so eventually my donut chart will become just one color when Closed exceeds 30% of total.
When I write it out in the chart expression, the chart displayed Open + 130% Closed, over inflating Closed by 30%.
=(Count([Open Status] = {'Open'}>} [counting])
+ Count([Open Status] = {'Closed'}>} [counting]))*0.3
+Count([Open Status] = {'Closed'}>} [counting])
I have been scratching my head on this for days, I think the answer might be either very simple or impossible, could anyone please help me to get it straight!
thanks, Gavin
Perhaps this?
=((Count([Open Status] = {'Open'}>} [counting])
+ Count([Open Status] = {'Closed'}>} [counting]))*0.3)
+Count([Open Status] = {'Closed'}>} [counting])
Hi!
If I understood what you want to achieve then yes, it its possible to be done either using a pie chart or, better, a gauge chart. I attached a file with two examples. Hope it helps!
Jaime.