Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an expression that has Count as below:
Num(Count(if(Type='Act' and Val='Match' and Stats='Yes', Entry))) / Num(Count(if(Type='Act' and Val='Match', Entry))'##.0%')
This gives me a number in % format which is what I want if I put in a text box or a Guage Chart. I want to use this expression in a Pie Chart but the issue in creating a Pie chart with this expression is, it only gives me one Big Pie with the % value. For example, if the expression gives 65% in a text box, when I use the same expression in Pie Chart as Dimension and Expression, it gives me a Full Pie with 65%. I want 65% and the remaining 35% as two different Pies in the chart. How can I get that. Any help would be really appreciated.
Create a pie chart with a calculated dimension
=ValueList('Your_Title','Others')
expression
=IF( ValueList('Your_Title','Others')='Your_Title',
[Your expression],
1- [Your expression]
)
Create a pie chart with a calculated dimension
=ValueList('Your_Title','Others')
expression
=IF( ValueList('Your_Title','Others')='Your_Title',
[Your expression],
1- [Your expression]
)
Thank you so much Dilip! Nice Workaround