Difference since last month
Hi
I'm trying to recreate a simple graph that I have in Tableau in order understand the capabilities of Domo.
It's a bar/line graph combo. The line graph is just a plot of the input data but then the bar graph plots the increase from the previous month. In Tableau this can be created in 5 seconds with a quick table calculation but I'm struggling with Domo - can anyone give any pointers?
Comments
-
Hello,
You can achieve this by using a "Period over period" chart type. Choose "Variance line bar." Input your time period in the x axis and then your value in the y axis. Go to your date range and choose last x number of months graphed by months. Then input a 1 into the "Compare to x month" box in the date range to compare one month back (see image below). This chart defaults to a percent variance and also shows the previous months total numbers but you can change this by going to the Chart Properties --> General, then checking off "Show Only Last Period" and "Show Variance As Value." After that it should look like the second image below.
Let me know if this works.
Best of luck,
Brian
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 303 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 104 SQL DataFlows
- 640 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 769 Beast Mode
- 72 App Studio
- 43 Variables
- 718 Automate
- 185 Apps
- 462 APIs & Domo Developer
- 57 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 402 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 135 Manage
- 132 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive