How do you create a chart that shows month over month difference
Sorry - I'd created this in the regular Dojo area; didn't realize I needed to post it here. So feel free to remove from regular post area.
How do you create a chart that shows month over month difference? Like Excel pivot when you sum and can do "difference from". Is this something that can easily be done or do you need to create something via magic ETL?
Best Answer
-
Hi jlabbe,
The best way to achieve this is to create a running total column in a dataflow. (If needed I can PM you on how to create this)
Once we get the running total column in your dataflow. We can calculate the difference from month to month in a beast mode.
Thank you,I work for Domo0
Answers
-
Hi,
We currently have period over period charts that let you compare month over month.
Here is a usefull article on how these charts work.
http://knowledge.domo.com?cid=buildingpop
Period over period
Please let me know if you have any questions.I work for Domo1 -
Hi,
I don't think I explained what I need very well. Here is an example of the summed data:
Jan - 10 widgets
Feb - 20 widgets (cummulative - includes Jan/Feb)
Mar - 35 widgets (cummulative - includes Jan/Feb/Mar)
Apr - 50 widgets (cummulative - includes Jan/Feb/Mar/Apr)
May - 100 widgets (cummulative - includes Jan/Feb/Mar/Apr/May)
I want my graph to only show the increase (so difference from previous month. I believe the period over period will only compare months.
Jan - 10 widgets
Feb - 10 widgets
Mar - 15 widgets
Apr - 15 widgets
May - 50 widgets
If that's still in period over period I'll take another look.
Thanks, Joanne
0 -
Hi jlabbe,
The best way to achieve this is to create a running total column in a dataflow. (If needed I can PM you on how to create this)
Once we get the running total column in your dataflow. We can calculate the difference from month to month in a beast mode.
Thank you,I work for Domo0 -
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive