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
Amy Catanzaro,
Can you share a .dash file here so we can play with what you have?
HI Amy,
I can give you the quick answer on the "0" label you're seeing on stacked columns. In order to get the values to stack like that (which is totally cool by the way!), all 6 values are in all three columns. So in the 2018 column, the other 4 values for 2019 and 2020 are in there, but with no results.... 0.
I can't think of a way to disable value labels for a value only when not equal to 0, or only within certain fields that it's grouped by.
Sure thing, Tom. Here you go. Thank you!1423.1920CSOSubSales.dash