YoY analysis without time series
I work in the hotel industry and, due to the season nature of travel demand, virtually all reporting has some element of YoY comparison to it. However, I am struggling to see how I do this in Domo - it seems like a real limitation.
I can easily create a chart of revenue over time where this year is compared to last year, but what if I don't want a time series? For example, I just want to see revenue by hotel this September this year vs. September last year, so perhaps a grouped bar chart where hotels are along the bottom and each one has two bars ;this year and last year. This doesn't seem possible unless I'm missing something??
I imagine I could create dimensions in the data itself, so index for month etc, but what happens if I need to do this for month-to-date etc, seems fiddly to have to create all these date dimensions.
Am I missing something?