Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar Charts

Hi All,

Is it possible to use buckets in expression value rather than numeric value.

E.g. Various values I am getting in expression are 250, 4000, 1100, 125. Now I want to show these values in buckets of <1000, 1000-3000, >3000.

Is it possible to do that?

4 Replies
ChiragPradhan
Creator II
Creator II

See here

Buckets

Regards

Chirag

Anonymous
Not applicable
Author

Hi  Parul,


Try:


If( Amount <  1000, '<1000',

   If( Amount <= 3000, '1000 - 3000','>3000' ))) as Bucket,

ganeshreddy
Creator III
Creator III

Hi Parul,

This link may help you.

Bucket Creation In List Box

Regards,

Ganesh

sunny_talwar

This:

Capture.PNG

=If(Sum(Values) < 1000, '<1000', If(Sum(Values) <= 3000, '1000-3000', '>3000'))