topic Re: Count If in App Development

Count If

gmoney2594 — Sat, 16 Nov 2024 03:05:08 GMT

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

Re: Count If

girish21595 — Thu, 05 Mar 2020 08:43:35 GMT

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

Re: Count If

nikitadeshwal — Thu, 05 Mar 2020 09:23:37 GMT

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 )