Quick Links
Sort by:
1 - 19 of
191
- 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
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.
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. 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
Accepted Answer
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...
This post has been closed.
Sort by:
1 - 3 of
31
- 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
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 Rotterdam
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
Accepted Answer
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...
This post has been closed.
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.