Combining multiple small data points into one for pie chart

[#1]

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.

[Gysbert_Wassenaar · Accepted solution]

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.

[#3]

Brilliant, thank you