How to add a count for difference in days

[joeboulware2000]

I have a table that has a Open Date and Close Date columns.

I added a Measure column to determine the number of days it took for a record to be Closed.  For example, Open Date is 1/1/2022 and Close Date is 1/2/2022, it would be one (1) day.

I would like to add a table that would do a count based on the number of days a record is open.  For example # of records opened for < 30 days, 31 days - 60 days, > 60, etc.

Any help on this would be great, thanks!

[Channa · Accepted solution]

to get number of days use

OpendDate-Close date as Days

to get records that less than 30

use resident load where Days <30

you can make it in report also

use set analysis or if statement

if( days<30, closedate)