Hi All!
This might be a bit of a stretch, but I’m trying to create a workflow or report feature that alters a report filter on a schedule.
For context, I created a report that displayed this year’s cumulative closed deal amount, overlayed with the same data from last year so we can see how we’re doing realtive to this time last year. I have it showing this YTD, and have set a filter that removes all data points after a certain annicersary date, so I’m only seeing the sales up to this point in the year.
The problem is that I have to update this regularly, as it is not a relative date, but a fixed anniversary filter. Is there any way to automate this, so I don’t have to manually update the report? It can daily, weekly, anything that makes the changes automatically.
Thanks in advance!
Hi @connorohess,
Cam you share more details about that anniversary filter? Segments support anniversary date filtering now - so creating a report that filters by membership in such a segment might be a workaround.
The short answer to auto-updating report filters would be: no, there’s no such feature or setting at this point.
Best regards
Hi Karsten,
I think I figured it out.
To answer your question, I had the report set up with the following filter:
Date entered “Closed Won” anniversary is between Jan 1 (PST) and Mar 6 (PST)
This allowed me to only have data between those anniversary dates represented in the chart, but of course it doesn’t update.
The segment option is proving to be the perfect workaround.
I found that it’s possible to filter for certain relative dates, but anniversaries are fixed, and there isn’t a relative date that is “exactly one year ago”, or something of the sort. It turns out that I can filter it in the same way with:
Date entered “Closed Won” is more than 365 days ago (PST)
Date entered “Closed Won” is after 01/01/2025 (PST)
This worked like a charm, though of course it remains to be seen whether it will update in the way I hope.
Thanks for the guidance, the segments suggestion was exactly what I needed.