Alternate to using the "Target" option of a Formula Indicator ?

[Rohit8]

Hello there,

I am currently building a widget with multiple indicators. I want to display the target line for one of those indicators. The Indicator Target option doesn't seem to be that flexible. It will appear as "Target" on the widget/chart, I didn't find any option to rename it to something closer to the Indicator it is referring to. It seems to have certain other limitations (can't change the line color, it appears as the last one on the chart). Also, I don't want to make that indicator as a primary one on the chart.

Is there an option to just create a sort of empty formula (or automated) indicator with only a static value like — 70 (the target) to show the same value for whatever time series I choose. Then I can just add it as another widget indicator to the dashboard with the options available to me for renaming it, changing the order or color etc.

Thank you.

[Adam Stout]

Did you try creating a formula indicator with the just the hard coded constant "70"?   That should always return 70 no matte what you do (if you use the AVG time series for it instead of the MAX).

[Rohit8]

Thank you, Formula Indicator was the first thing I tried and exactly with just a single constant value of "70". And I tried it with different time series (Monthly AVG+, 7 days etc.) on both indicator and widget but it just kept showing "No data" on both scorecard and the widget. The other indicator worked fine on the same widget.

I figure that's because it doesn't have the months value to correspond against that constant value of "70".

So I got it to work by creating a manual indicator and adding the value 70 to any one random date of the each month, in the scoresheet. And then I also enabled the option "Value when Nil' with "70" in the indicator options.

Not the best way but does what I need.

Thanks a lot again for the suggestions. Please do let me know if there is anything else which can be tried.

[Adam Stout · Accepted solution]

I forgot, formulas require a non-null indicator (even if you don't use it).   Add any indicator that has a score for that day (I often use # of open incidents),   then below that have the last line be:

70;

[Rohit8]

Wow! That was it !! Your suggestion worked like a charm, Sir.

So all this time, I had been trying it with just an empty value of 70 wondering how to put it in a formula with an existing indicator (Add/Divide/Multiply). I wasn't aware that we can get it to work by simply writing this value in the next line after picking an indicator. This is definitely cleaner and way better than the manual indicator option and having to write values in the scoresheet for different months. I'll go with this.

Thanks a lot for your thorough and helpful suggestion.