Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have an average calculated in an expression which outputs a percentage:
=Avg(field)
I do not have a dimension in this particular case. How can I have a pie chart that represents this value?
For example, sayy the average is 39%, so I want the pie chart to show 39% as one colour and the other 61% as another colour.
So far the pie chart is all one colour with the value of 39.
Any ideas?
Regards
Revlin
Please see attached.
two expressions used.
Generally I am against pie charts...
Hi Ioannis
Unfortunately I am currently using the personal edition, so I can not open your file.
Would you be able to paste the expressions?
1st : avg(F1)
2nd : 100-avg(F1)
Hi,
Try this,
-No dimension
Use too expression like this,
1.Avg(Field)
2.100 - Avg(Field)
Hope it helps
Yes that works a treat. Much appreciated Ioannis!