In a KPI card, I would like to display only the activities that occurred for that KPI for the last 90 days. I know the below is incorrect but logically it is as close as I can get without help.
FILTER “_CEL_P2P_ACTIVITIES”.“EVENTTIME” BETWEEN TODAY() AND (TODAY() - 90)
The KPI card works so I am looking for the code to “tack onto” to get the 90 day window.
Please advise! Thanks.