12 Replies Latest reply on Aug 22, 2017 9:09 PM by Nithya Ramachandran

# Top n% and Others

I have a dataset showing events by locations. I need to find locations who make 80% of the events and put the rest into the "Other" category. I see there is a way to do similar thing as Top N customers, but how can I do it as a percentage of total events?

• ###### 1. Re: Top n% and Others

Hi Archit,

Can you please provide sample data which help us to provide accurate answer

Thanks,

Sreekanth

• ###### 2. Re: Top n% and Others

I have added a sample file. In that I am trying to group top N % and others. I am able to do Top N and Others but not able to do Top N % and Others.

• ###### 3. Re: Top n% and Others

Still cant view the file

Click on advanced to attach the file

You can create set and find top N and place the set onto rows and measure onto text Right click and do a percent of total

• ###### 4. Re: Top n% and Others

I added the twbx file to the original post. Added here as well

• ###### 5. Re: Top n% and Others

Hey sorry I was on lower version please send me the data set if possible

Regards

• ###### 6. Re: Top n% and Others

Here it is

• ###### 7. Re: Top n% and Others

Could do something like this:

Running Sum calc:

if running_sum(SUM([Number of Records]) / TOTAL(SUM([Number of Records]))) <= 0.80

then attr([Location]) else 'Other' end

• ###### 8. Re: Top n% and Others

ok thanks now you want to see locations within each region making 80% as top and rest as others right?

or locations making 80% as top and rest as others?

• ###### 9. Re: Top n% and Others

Locations making 80% as top and rest as others.

• ###### 10. Re: Top n% and Others

I already tried this. This does categorizes the location into 80% and others but I am trying to club all others together and have the sum of all others in the table.

• ###### 11. Re: Top n% and Others

Thanks,

Sreekanth

• ###### 12. Re: Top n% and Others

Hi,

I am also trying to create a bottom 20% customer set based on sales and trying to show the total sales in the bottom 20% and total customer count.

Any help would be appreciated.

Thanks,

Srinithi