I have the following fields,Participant ID, Country and Month. I want to find total number of participants per country.
Using the following Definition ( Count (DISTINCT PARTICIPANT_ID) ) I could able to extract relevant information. My problem is in certain countries we have only 1 or 2 particpants. In certain countries we have more than 1000 participants. I want to extract only > 25 participants in chart and anything <25 should be summarised under Others.
How do I implement this? (Attached file contains teh data, Country, Participants) It is difficult to see as we have more countries.
And even better creating this accumulation in the script using Peek() and Previous() as a flag field, (with values 1 if greater than 25 or 0 if less), so although the load time would be a bit slower, the chart rendering will do faster. Check this thread among several others on how to create accumulations in the script using those functions.
Going even further, and although I don't recommend you to do this way because of the presumable poor performance of calculated dimensions, you could leave the expression as it is, but use the following as dimension in the chart