How to make a chart which shows weekly values along with percentage change?
Best Answer
-
I've done something in the past where I calculate the current day value and the value from a year ago. The data set is aggregated on a daily basis (to allow slicing on day / week / month / year) and I simply use a MySQL ETL to join the dataset to itself shifting the current date by a 1 year interval (or 364 days if you want to compare same day of the week this year to last year i.e. Monday -> Monday), renaming the columns to include LY for Last Year. Then in my cards I'll use a BeastMode compute the YOY % difference
(SUM(`This Year Field`) - SUM(`Last Year Field`)) / SUM(`Last Year Field`)
Utilizing a Line + Stack Bar chart type (Under Verital bar chart type) I'll put in all the YOY % values for the different groups as the lines (You can specify the number of series to include as lines under General -> Series on Left Scale) and then put in the current day / year's values as the bars.
It ends up being a bit wieldy but it allows me to calculate the current month YOY % correctly (ignoring the same date from last year beyond today - for example if it was 3/5/20 it'd ignore 3/6/19-3/31/19) without having to utilize YTD. It also allows me to do things like plotting a stacked bar with YOY % as lines.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Answers
-
I would suggest the Period over Period cards. You could use the bar line, for example. You can then use the date range filter to compare it to the previous week, or much earlier, if needed. Here is a screenshot example:
CORRECTION: The variance bar line would be a better choice as it shows the percent change. Apologize my screenshot is with the bar line and not the variance bar line.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Thanks for the reply.
Can I use a stacked bar and then compare it WoW or YoY?
0 -
It doesn't look like stacked bar is an option in the period over period charts. There are about 7 different charts for period over period. I would try each of them out and see which one fits your need the best.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
I've done something in the past where I calculate the current day value and the value from a year ago. The data set is aggregated on a daily basis (to allow slicing on day / week / month / year) and I simply use a MySQL ETL to join the dataset to itself shifting the current date by a 1 year interval (or 364 days if you want to compare same day of the week this year to last year i.e. Monday -> Monday), renaming the columns to include LY for Last Year. Then in my cards I'll use a BeastMode compute the YOY % difference
(SUM(`This Year Field`) - SUM(`Last Year Field`)) / SUM(`Last Year Field`)
Utilizing a Line + Stack Bar chart type (Under Verital bar chart type) I'll put in all the YOY % values for the different groups as the lines (You can specify the number of series to include as lines under General -> Series on Left Scale) and then put in the current day / year's values as the bars.
It ends up being a bit wieldy but it allows me to calculate the current month YOY % correctly (ignoring the same date from last year beyond today - for example if it was 3/5/20 it'd ignore 3/6/19-3/31/19) without having to utilize YTD. It also allows me to do things like plotting a stacked bar with YOY % as lines.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
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