Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI
I have only one column "data" as below.
data
0
2
10
20
30
100
110
200
I need to create bucketon this as,
<0
0-10
10-100
100 - 200
and i need to get cummaltive sum of data based on this bucketing
Bucket Cummulative sum
<0 0
0-10 12
10-100 162
100 - 200 472
Can anyone please suggest on this
Make a dimension in the script:
IF(Data<0, '<0',
IF(Data<10, '0-10',
IF(Data<100, '11-100',
IF(Data<200, '101-200',))) as Bucket
Then create a graph with Bucket as dimension & COUNT(Bucket) as Measure
Make a dimension in the script:
IF(Data<0, '<0',
IF(Data<10, '0-10',
IF(Data<100, '11-100',
IF(Data<200, '101-200',))) as Bucket
Then create a graph with Bucket as dimension & COUNT(Bucket) as Measure
how can I sort it as to get always
<0
0-10
10-100
100 - 200
Select sort by expression and put the below formula:
=match(Bucket,'<0','0-10,'11-100' ,'101-200')
Thank You, it worked