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.
Question for those of you who have one of these sales pacing dashboards alive and well...I just got back from two weeks of vacation and noticed that my red "current year" lines are gone. At first I thought it might be an issue of the year changing over, but don't recall that being an issue last year. Wonder if anyone else here is experiencing the same?It seems like there's something wrong with the Season Fiscal Current Year Offset filter, as it only has "N/A" in the list. I was going to submit a help ticket, but thought I'd check here first, in case it's something obvious I'm not catching. Thanks as always.