Hi, I want to filter the users who have not logged in for the last 90 days, I am not sure how to write the calculated field, I have the "users names" and also the "Login at"
Any ides please on how to write the IF statement?
Without knowing how do you plan to use it I can only give you some pointers...
You need a calculation that will do something like:
IF DATEDIFF( "day", [Login at], TODAY()) > 90 THEN "non-active user" else "active user" END
Retrieving data ...