Charting
Charting
Grouped Bar with two categories and trend line
I am trying to create a bar chart with two categories, quarter and region, and then show a trend for each region across quarter. I am able to that by using a Grouped Bar chart with 2 Categories and a Series. But then I need to add a line that shows the average across quarters for each region. The chart would look like this.
I am able to create this chart shown below in Domo:
..but now need to add the average line across quarters for each region, the red line that I've drawn in. Can this be done in Domo?
Welcome!
Comments
-
Hi @AttuAk, I'm curious, what chart type did you use to create that view (with the side-by-side regions) in Domo?
If you are after a simple average line, you can use the Scale Marker feature in 'Chart Properties' [https://domohelp.domo.com/hc/en-us/articles/360042925194-Adding-Scale-Markers-to-Your-Charts]. If it's a dynamic average line you need, you can create a beast mode using the Window function, something like:
SUM('Lead Value') / SUM( SUM(`Lead Value`))
OVER(PARTITION BY `Region`)
7 -
Many Bar charts in Domo support Trellis (search for trellis, https://domohelp.domo.com/hc/en-us/articles/360043439893-March-2019-Release-1)
But, Domo doesn't really support an X axis with two metrics. Or at least. I haven't gotten it to work. I feel like it should be possible though.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Hi @amehdad Thanks for your input here. I am using a Grouped Bar chart where Lead Value is the Value and then I use Quarter and Region as the series. This allows for the graph I have above but I still cannot insert another value which would be the average of the lead value by Region.
When using your suggested beast mode I get an average over the entire region, but I need it by Region and then averaged over the 4 quarters shown. And then I need to add it to the chart as another value. I'm wondering if Domo can support this?
0 -
There doesn't seem to be a way currently to have a dynamically split average line across different sections of a graph. You'll need to create duplicate graphs for each region and have them side by side in your dashboard so it looks similar to your very top chart.
8
Welcome!
Welcome!
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 45 Variables
- 776 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 82 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive