topic Re: Group by Days in Visualization and Usability

Group by Days

danieldors — Tue, 15 Feb 2022 15:12:07 GMT

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.

Re: Group by Days

Almen — Tue, 15 Feb 2022 15:39:58 GMT

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