How to split data by 10 group in auto

[eddywong71]

Hi All,

I want to use Class function to divide 10 group of data.  Number of ppl in group should not equal.

Price Range       Count

<10                     5

<20                     10

<30                     20 

However, for the expression like class(Price,10) need to set the bin manually.  I want the expression auto set the bin and split to 10 group.

Below expression is not suitable in this case with me.

Dimension:
if(Sales <= fractile(TOTAL Sales, 0.1), 10,
if(Sales <= fractile(TOTAL Sales, 0.2), 9,
if(Sales <= fractile(TOTAL Sales, 0.3), 8,
if(Sales <= fractile(TOTAL Sales, 0.4), 7,
if(Sales <= fractile(TOTAL Sales, 0.5), 6,
if(Sales <= fractile(TOTAL Sales, 0.6), 5,
if(Sales <= fractile(TOTAL Sales, 0.7), 4,
if(Sales <= fractile(TOTAL Sales, 0.8), 3,
if(Sales <= fractile(TOTAL Sales, 0.9), 2, 1)))))))))

[Lisa_P]

Try using a Histogram with the setting Number of Bars as 10

[eddywong71]

Hi Lisa_P , i need to use table formal to visual the data to user. 

[Lisa_P]

If you right click on the chart you can see the data, but you can't make it the default presentation