I need to filter to get all results that the last validated date of the result is older than 45 days. I think something like this could be ok, but I don't know how to format it. There is variables or something that I could use ? :
between([Last Validated Date], "today - 45 days", "today - 45 days and older")
I need to get all results that "Last Validated Date" are older than 45 days -> The value "June 30, 2021, 12:20 PM" (screenshot) has only 28 days old and is not older than 45 days
@Stekino I still don't understand. Then you're looking for filters - not aggregations like CountIf.
You can create a Custom Column with a case: case(interval([Last Validated Date], -45, "day"), "within45", "olderthan45")
Without understanding your data, then it's difficult. Try making an example with Sample Dataset.
Thanks this was usefull to me.
I have used CountIf(interval([Created At], -15, "day")) to show me users that have been created at for more than 15 days.
On a new column, it show 1 when this is true, and 0 when this is not true.
I am trying to filter to only show the 1 (true values) but for some reason it creates an issue when i filter.
Could you assist?
@victoeien Sounds like a different topic. Seems like you should just add a Custom Column like this, if you want to show a 1 for users created within the past 15 days otherwise show a 0 case(interval([Created At], -15, "day"), "1", "0")
If that doesn't help, then open a new topic and describe with more details and screenshots.