topic Re: draw treshold line in predict forecastviz in Dashboards & Visualizations

draw treshold line in predict forecastviz

pitmod — Mon, 19 Oct 2020 09:44:36 GMT

Hello,

how can I add treshold line in my forecastviz? I've tried as below but it's not visable on the chart. With normal line chart it works fine.

| mysearch

| eval Treshold=90| timechart span=120min latest(Treshold) as Treshold avg(MyPredictedValue) as PredictedValue
| predict "PredictedValue" as prediction algorithm=LLT holdback=12 future_timespan=96 upper95=upper95 lower95=lower95 | `forecastviz(96, 12, "PredictedValue", 95)`

| filldown Threshold

Re: draw treshold line in predict forecastviz

t_shreya — Tue, 20 Oct 2020 14:04:24 GMT

Hi @pitmod ,

I think this may work. Replace `forecastviz(96, 12, "PredictedValue", 95)` with the following :
| eval _ft=96
| eval _hb=12
| eval _vars="PredictedValue"
| eval _ci=95

I'd replaced the macro with it's definition in the query and it had worked for me.

Added threshold to forecast chart

Re: draw treshold line in predict forecastviz

pitmod — Tue, 20 Oct 2020 14:43:48 GMT

@t_shreya Which makro should be edited? On the screenshot you've attached I don't see a horizontal threshold line.

Re: draw treshold line in predict forecastviz

t_shreya — Wed, 21 Oct 2020 04:14:12 GMT

@pitmod I'm sorry, I misunderstood your question and thought that you wanted a vertical threshold line.

I'm not completely sure for the horizontal threshold, but can you try something like this?

| mysearch