Count based on 30, 60 and 90 Days

[Skywalker]

Hello Expers, 

I am trying to draw a chart based on days remaining. Group them in 30, 60, 90 and others. 

Username   Expiry Date 

Test                 MM/DD/YYYY

Its something simple but I am not able to put it together at the moment. 

Thank you. 

[vikasmahajan]

You can do this by creating four expressions/measures

0-30 day bucket
sum({<[Expiry Date ]={">$(=today()-30)<=$(=today())"}>}[ your Measure Field]) 

60 day bucket
sum({<[Expiry Date ]={">$(=today()-60)<=$(=today()-30)"}>}[ your Measure Field]) 

90 day bucket
sum({<[Expiry Date ]={">$(=today()-90)<=$(=today()-60)"}>}[ your Measure Field]) 

Hope this help you

Thanks

Vikas

[Skywalker]

Hi Vikas,

Thank you for helping out, I tried to add the expression but did not work, I might not be doing it right, I have a list of User name, who expires on different dates but I want to graph a bar chart showing how many will expire in coming 30 days, 60 and 90. Just the number. The graph has Dimension and measure, what can I put in Dims? 

sum({<[Expiry Date ]={">$(=today()-30)<=$(=today())"}>}[ your Measure Field]) 

Thank you. 

[vikasmahajan]

You need  user Name  wise report right ? then user name will be dimension & keep all expressions in measures 

[Skywalker]

Hi Vikas,

I need username - count based report, like 

100 - expire in less then or equal to  30 days, 

50 - in 60

200 in 90 days. 

Thank you,