Count If

[gmoney2594]

Hello,

I want to count and bucket information by the following parameters: 

X = a number field

Count(if (x >= 0 and =< 30) = '1-30 days',

elseif (x >= 31 and =< 60) = '31-60 days',

elseif (x >= 61 and =< 90) = '61-90 days',

else (x >= 91) = 'Over 90 days')

How would I accomplish this in a bar chart

[girish21595]

Use the Class function to create the Bucket and use it as the dimension of Chart and measure as count(x).

[nikitadeshwal · Accepted solution]

Create a field 'Bucket' in script.
if(Points>=0 and Points<=30,'1-30 Days',If(Points>=31 and Points<=60,'31-60 Days',
if(Points>=61 and Points<=90,'61-90 Days',if(Points>=91,'Over 90 Days')))) as Bucket
In Bar chart,
take Dimension as Bucket and Measure as Count(Bucket )