Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaysingh
Specialist II
Specialist II

Buckets

I want to make buckets and wants to use it as dimension.

attching picture pls suggest me.

want to use these Buckets as a dimension

6 Replies
Gysbert_Wassenaar

See this blog post: Buckets


talk is cheap, supply exceeds demand
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

HI,

     Use the "Class" function for the same.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
ashfaq_haseeb
Champion III
Champion III

Hi use class() function

Regards

ASHFAQ

deepakqlikview_123
Specialist
Specialist

Hi  Abhay,

In your case your range values are not constant so I would suggest you to use If  else .

Please refer link provided by gwassenaar

Thanks,

Deepak

fkeuroglian
Partner - Master
Partner - Master

Use class function

class( var,10 )

get bucket of 10 to 10

Fernando

its_anandrjs

You have to use Class Function and for help see its syntax which is from help and also the URL that  Gysbert Wassenaar you can follow that one also

class(expression, interval [ , label [ , offset ]])

Creates a classification of expressions. The bin width is determined by the number set as interval. The result is shown as a<=x<b, where a and b are the upper and lower limits of the bin. The x can be replaced by an arbitrary string stated in label. 0 is normally the default starting point of the classification. This can be changed by adding an offset.

Examples:

class( var,10 ) with var = 23 returns '20<=x<30'

class( var,5,'value' ) with var = 23 returns '20<= value <25'

class( var,10,'x',5 ) with var = 23 returns '15<=x<25'