Hello everyone!
Thanks to those who joined us today! If you couldn't make it, no worries - below is a link to the meeting recording of Carli Webb going hands-on to show year-over-year reporting.
Link to meeting recording
We hope to see you at the next meeting in October!
Jen
So I've been messing around with this to do some YTD reporting for package sales (volume, revenue and households) and was able to create stacked columns that display where we were YTD for past seasons and also how much more we sold in the remainder of those seasons but this weird 0 is displaying. Any thoughts on how to make that go away?
And one more question on this same topic. I can get the YTD function we learned to work correctly for contstituent counts but not for seats (not package seats but admission seats) nor for revenue. I built this simple widget on the same dashboard trying to see what ticket paid measure I should use with my YTD calculation to find the correct revenue amount for the season below, using a specific date range instead of the calculation. This returns the same amount I return using the calculation but in both cases this is off by about $400K. I have weekly reports saved that are built off of the canned price type category report (though the report I use for it is custom) and can verify in those saved excel reports that this figure is wildly inaccurate. Without the date filter it does report correctly on the full season sales (or close enough, within $500). YTD comparisons are only helpful if they are accurate - what am I missing?
Chris Wallingford Jenifer LaMorte