I can easily count all records using:
CountRows(Search(LLL, "Kerry", "Title"))
How do I search the same data but return items only from the last 90 days?
Thanks,
Solved! Go to Solution.
Hi @Doors1980
If you want to Count all rows that match few criteria I recommend using something like this:
CountRows( Filter( LLL,
DateColumn >= DateAdd(Today(), -90),
Title = "Kerry" ) )
This will only count rows that have Kerry in Title and the date column which is up to 90 days behind today.
Hi!
You have two options: either you change your Search to maybe a Filter and select your dates there, or you do a CountIf instead. It will look something like this:
CountIf(LLL, DateColumn >= DateAdd(Today(), -90))
You have to change the name of the column, and if it's not a date value already (meaning if the date as stored as text), you have to use DateValue to make it into a date.
Good luck!
Thanks @BitLord69 , how would I add the 90 days into a filter formula? (as I also need to filter by another field, not just by the 90 days)
Hi @Doors1980
If you want to Count all rows that match few criteria I recommend using something like this:
CountRows( Filter( LLL,
DateColumn >= DateAdd(Today(), -90),
Title = "Kerry" ) )
This will only count rows that have Kerry in Title and the date column which is up to 90 days behind today.
Perfect @Anonymous , cheers for the help. I'll get the hang of this one of these days.
User | Count |
---|---|
160 | |
84 | |
68 | |
64 | |
61 |
User | Count |
---|---|
206 | |
146 | |
95 | |
83 | |
66 |