I want to add the Min, Max and average lines to a stacked graph ...how do I do that?
At the moment Min/Max/Avg is only available when you don't add series. Once you have series on a stacked bar for example you automatically lose your Min/Max/Avgs. Is it possible to add it?
Best Answer
-
@caiopimenta I was able to add the average line to a horizontal bar chart with a series using the Scale Marker settings below. It does not include Min/Max, but I was at least able to get a line to show up
0
Answers
-
@caiopimenta Can you share a little more about your data and what your expectation of the min/max/avg values you want displayed would look like?
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
Here is a picture after I insert a series and here is a picture before I insert the series.
0 -
Thanks. I thought your series was breaking up bars into multiple segments. But you are just using is to add colors.
If you set the Colors using Color Rules, then you can avoid using Series. This will allow you to keep the min max and avg values:
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
Thanks for the help. Although this is a great work around. In my case, I am layering a segment into this chart. For example, showing stores and the colors are the territories of the stores. Right now we have over 500+ stores so it is not feasible to select a color for each store.
0 -
@caiopimenta I was able to add the average line to a horizontal bar chart with a series using the Scale Marker settings below. It does not include Min/Max, but I was at least able to get a line to show up
0 -
Thank you Michelle, helpful work around!
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 603 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive