counting Inactive users for last 90 days

[hathwarjaya]

Hello All,

I need your help in one set analysis expression.

I need to calculate the number of  users with no activity in the last 90 days.

and plot a line chart with week and month as x axis.

This is how the data looks like.

User	activity	activity date
A	1	1.12.2019
B	2	2.1.2020
C	2	26.1.2020
D	1	5.2.2020
E	3	20.2.2020
F	3	26.3.2020

Please help me with this.

[hathwarjaya]

Hello Sunny,

the set analysis expression you gave is also including the data from long back also 

not only just from 90 days back

could you please help me with this?

Regards,

Jaya

[sunny_talwar]

I am not sure I follow, can you show this with an example?

[Brett_Bleess]

What about using a 'flag' field to do the count, so as you load the records, you are checking if the date last entered is within 90 day window or not, and if not, you set the flag field to a 1 else 0, so you can simply sum the flag field as the expression in the line chart at that point I believe.  This will not require set analysis in this case, you do the flag set in the script using an 'if' statement there to do the check and you could set the date check as Today()-90 I believe.  Hopefully that gives you another avenue to pursue on this one.

Regards,
Brett