Binning Data

[#1]

Hi,

I have done Pareto analysis and sorted dimension in descending order according to sales with salesman name as a dimension, but as we have several sales men, would like to bin them in group of 20 with total sales in decreasing order. Please help me to do same.

Best regards,

Navdeep

[#2]

PFA the app "sorry for wrong heading", dimension contains names so not Quantitative

[petter]

You should look at the Class() function that could either be used in your Load Script or in your Chart to bin your quantitative data into bins of size 20.

You can use Class() directly in a calculated dimension.

[#4]

Hi Petter,

Sorry for wrong heading,my data contains Names.

I tried class function but it's not working, I guess it takes Numerical input for binning.

[petter · Accepted solution]

You will have to use the Rank() function to give them a numerical valid ranking number and then bin them according to that. The top 20, then the 21..40th ... and so forth by combining Class() and Rank() and possibly Aggr() too...

[#6]

=class(aggr(Rank(sum(Quantity)),ISPName),20) used this in dimension.