Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
So I've got a database that includes personal issues that people may have (Drugs, drink, etc).
There are some larger ones, but there are also some issues that may only affect one or two people. There's about 6 of them.
I want to combine these smaller issues into one part of a pie chart as "Other".
Would it be a case of something like
if( Count(Personal_Issue) < 2, Personal_Issue as Other)
in the pie chart.
Any help?
Thanks.
If you have QV11 you can use dimension limits and enable the Show Others option. You can find the settings on the Dimension Limits tab of the properties window.
If you have QV11 you can use dimension limits and enable the Show Others option. You can find the settings on the Dimension Limits tab of the properties window.
Brilliant, thank you