Hi everyone, For a while now, I’ve been creating a lazy workaround to sales pacing charts for my 6-week festival season company by comparing sales using the days prior to production close criteria. However, this isn’t really cutting it anymore, at least in considering the grand total of sales across all four shows in our festival. What I would love is a way to create a line chart with the x-axis being the date prior to season close and the y-axis being a running sum of total revenue, so that I can compare sales 60 days out last year with 60 days out this year.Does anyone have a clever solution for this? It's not possible to hardcode a formula for the category, as far as I can tell...I have to choose an actual out-of-the-box criteria. If someone has any advice on this, it would be immensely helpful! Thanks so much.
Kanani, could it be that your [Years in Date] formula filter does not have 2024 selected? As in it only has 2023 selected. Another idea is that a higher-level filter (widget or dashboard) does not have 2024 selected.