Compare to Industry Trends
Hi community,
What's the best way to compare two different series when they are on totally different scales? My hope is to see if our trends compare to industry average.
I've got month, year, our total, and the industry comparable. For instance:
Date | My Company | Industry |
---|---|---|
Jan-24 | 100 | 50000 |
24-Feb | 150 | 60000 |
24-Mar | 175 | 70000 |
I obviously can't just graph them side by side since the scale of the industry would dwarf our values.
But what I do want to show is that we are growing faster than the industry broadly.
The problem with attempting a period-over-period chart is that I want to compare our trends to industry trends, NOT this period to last period (although that will be next step anyway)
Any thoughts??
✅Did this solve your problem? Accept it as a solution!
❤️Did you love this answer? Mark it as "Awesome"!
👍Do you agree with this process? Click "Agree"!
Best Answer
-
You could normalize the data:
Or just divide by a thousand, or ten thousand and then use a chart type that allows for multiple axis labels (left and right) and be sure to label the axis that has been adjusted to read "In thousands" for example.
If I solved your problem, please select "yes" above
1
Answers
-
You could normalize the data:
Or just divide by a thousand, or ten thousand and then use a chart type that allows for multiple axis labels (left and right) and be sure to label the axis that has been adjusted to read "In thousands" for example.
If I solved your problem, please select "yes" above
1 -
I think the best way to do that would be to do a dual line period over period graph Ik you said thats not what you want but hear me out. You arent comparing this period to last period, you are comparing your this period over last period to their this period over last period. So it effectively becomes your gross change/month vs their gross change/month. That way you are both on the same scale. So instead of your line being 100 150 175 and theirs is 50000 60000 70000. It would be 50% increase 16% increase vs their 20% increase 16% increase. This would effectively show your growth rate vs their growth rate.
If you insist on using those numbers the best way would be a log scale; however, I find log scales unintuitive to most ppl. Like yes they get it as a concept, but they still see how much higher the line is and that does subconsciously affect the way they are going to view it.
1 -
Outstanding! Thank you both. It worked and the owners that received my analysis were happy.
Thanks for everything.
✅Did this solve your problem? Accept it as a solution!
❤️Did you love this answer? Mark it as "Awesome"!
👍Do you agree with this process? Click "Agree"!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive