Group by Days

[danieldors]

Hello,

I'm trying to group the count number of cases by days, 31-60,61-90,91-120 and 120+ days. The data would show 31-60= 1,000 cases,61-90 2,000 cases etc. Any help would be appreciated.

Thank you.

[Almen · Accepted solution]

You'd simply create some buckets in your script and count those:

IF(Days>=31 and Days<61,Dual('31-60',1),
IF(Days>=61 and Days<90,Dual('61-90',2),
...)

as 

BucketDays