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?
- 10.6K All Categories
- 13 Getting Started in the Community
- 29 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 300 Use Cases & Best Practices
- 499 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- 4 Private Company Board