Year-Over-Year comparison by month
I have a dataset where each row contains a single office's monthly revenue and I want a table where each column is a different month where I can compare the year-over-year values as well as office by office.
Here's the data:
And I'd like to create a DOMO table that looks like this:
It seems like it shouldn't be that difficult but I can't seem to make it happen.
Comments
-
Have you tried using a pivot table card and creating a beast mode for the month using MONTH() and a beast mode for the year using YEAR() and put both of them in the columns section of the card and then your office in the rows section and the revenue in the value?
That seems like that should work.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
@MarkSnodgrass I have, but I cannot seem to get the same month of different years next to each other. It never alternates the way I want. I see all of 2022 then all of 2021 regardless of their order
0 -
I just used the COVID dataset as a test and it seemed to work. Here is how my pivot table is constructed.
Here are my two beast mode functions:
monthdate = MONTH(`date`)
yeardate = YEAR(`date`)
Is that how yours is constructed? You need the month and year as separate fields.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
It's so bizarre. I'm using the exact same calculations for year and month.
0 -
That is strange. You may want to check your date range filter and make sure it is graphing by none.
Also, sometimes I have to remove the sorting and re-add it. Or close the card and re-add it.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Woah.. that made all the difference. I was limiting the data to the last 12 months! Thank you for all your help!!!
2
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive