How to add Multiple Targets in one chart?
Best Answers
-
I would think that it would be easier to set the multiple targets in the dataflow itself, where one could compare revenue/sales/etc. with the targets provided in your own data, so that the targets could be a part of the graph.
"When I have money, I buy books. When I have no money, I buy food." - Erasmus of Rotterdam0 -
There's a little "hack" I use to set what I call threshholds on a card. It doesn't work if you need to have a target line that moves based on seasonality or some other criteria, but it works if you just need more than one static goal line on a chart.
It's pretty simple actually
- Create a new beast mode with an intuitive name
- Use the avg formula to create a series with the same value no matter what (eg if you need to always be above 50K in a region for sales, use AVG(50000)
- Create as many as you need and simply add them as additional series to your chart
- Place them to the far left of the series and then use your chart settings to show the same number of lines as you have set goals
- Finally, add in your actual data and you will see it trending along with your newly created beast modes
2 -
Submitted a request for a variation on this very helpful hack, and the URL is https://dojo.domo.com/t5/Card-Building/Variation-on-adding-Multiple-Targets-in-a-chart/m-p/29694#M3544. if it's possible, any assistance is greatly appreciated! Thank you in advance...
0
Answers
-
I would think that it would be easier to set the multiple targets in the dataflow itself, where one could compare revenue/sales/etc. with the targets provided in your own data, so that the targets could be a part of the graph.
"When I have money, I buy books. When I have no money, I buy food." - Erasmus of Rotterdam0 -
Hi
I would suggest ussing the "Grouped Bar + Symbol" chart and make the symbol values the target for each bar.
Good luck
Fernando
2 -
In order to do that, though, one would have to have a column with the targets set for each region, right?
"When I have money, I buy books. When I have no money, I buy food." - Erasmus of Rotterdam0 -
Yes. you need to add a new column for tagets in your data source
0 -
That definitely looks like a chart type that would be useful for me in some of the kpi that I monitor.
"When I have money, I buy books. When I have no money, I buy food." - Erasmus of Rotterdam0 -
In association with the comments above, I would also recommend a Bullet Chart.
1 -
Yes! a bullet chart also allows to set thresholds and stretches for each outcome.
1 -
It depends on how complex your goals are. If all you need to do is set a threshhold, you can do that in Beast Mode. Ror example, if you need to show in you chart that you want a rate to never fall below 5% and never go above 10%, you can create columns in Beast Mode by simply doing the following
Name: Upper Limit
Calc: AVG(.1)
Name: Lower Limit
Calc: AVG(.05)
This will create series you can add to your chart. If you need to set completely custom goals, you'll have to leverage data flow to incorporate that data into your chart.
0 -
It was fantastic to get so many replies! Thank you! I have ended up setting multiple targets in the dataflow itself
2 -
You're very welcome; I'm glad to be able to help.
"When I have money, I buy books. When I have no money, I buy food." - Erasmus of Rotterdam0 -
I'm curious how you did this? Is this anything you can share in an image?
0 -
Hi @canioacaputo, please feel free to open up a new thread for better exposure!
0 -
Is it possible to add a functionality to have multiple axis goals? A use case for this request would be that my company identifies a worse case and best case for some metrics and that would require 2 possible goals within a card.
1 -
There's a little "hack" I use to set what I call threshholds on a card. It doesn't work if you need to have a target line that moves based on seasonality or some other criteria, but it works if you just need more than one static goal line on a chart.
It's pretty simple actually
- Create a new beast mode with an intuitive name
- Use the avg formula to create a series with the same value no matter what (eg if you need to always be above 50K in a region for sales, use AVG(50000)
- Create as many as you need and simply add them as additional series to your chart
- Place them to the far left of the series and then use your chart settings to show the same number of lines as you have set goals
- Finally, add in your actual data and you will see it trending along with your newly created beast modes
2 -
Thanks! That's a cool hack, it definitely works in certain cases - just tested it!
0 -
Submitted a request for a variation on this very helpful hack, and the URL is https://dojo.domo.com/t5/Card-Building/Variation-on-adding-Multiple-Targets-in-a-chart/m-p/29694#M3544. if it's possible, any assistance is greatly appreciated! Thank you in advance...
0 -
Did a new thread for this get opened? I am curious to see how to add the targets in the dataflow.
Thanks!
Becki
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive