Days Open Grouping

[Anonymous]

Hello,

I'm looking to create groups for Days Open. I currently have a 'Task Created' Date/Time column and I wish to creat the following. 

New column for Days Open and then groups - 

0-7 Days

8-30 Days

31-60 Days

>61 Days

TIA

[rohit_singh · Accepted solution]

Hi @Anonymous ,

1) Create calculated column for EndDate

EndDate = today()

2) Create calculated column for DaysOpen

DaysOpen = DATEDIFF(DaysOpen[StartDate], DaysOpen[EndDate], DAY)

3) Create calculated column for DaysOpenGrp

DaysOpenGrp =

if(DaysOpen[DaysOpen] <= 7 , "0-7 days",

if(DaysOpen[DaysOpen] > 7 && DaysOpen[DaysOpen] <= 30 , "8-30 days",

if(DaysOpen[DaysOpen] > 30 && DaysOpen[DaysOpen] <= 60 , "31-60 days",

if(DaysOpen[DaysOpen] > 60 , "> 61 days", BLANK()))))

Result

Kind regards,

Rohit

Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

[Vijay_A_Verma]

Use below formula in a custom column where Days is the column name. Also note, >61 Days is wrong to say, it has to be >60 Days or >=61 Days

= if [Days]>60 then ">60 Days" else 
if [Days]>30 then "31-60 Days" else
if [Days]>8 then "8-30 Days" else "0-7 Days"