Dashboards & Visualizations

draw treshold line in predict forecastviz

pitmod
Explorer

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 

Labels (2)
1 Solution

t_shreya
Path Finder

@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

| 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 
| eval _ft=96
| eval _hb=12
| eval _vars=mvappend("PredictedValue","Treshold")
| eval _ci=95

View solution in original post

t_shreya
Path Finder

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 chartAdded threshold to forecast chart

 

 

pitmod
Explorer

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

t_shreya
Path Finder

@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

| 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 
| eval _ft=96
| eval _hb=12
| eval _vars=mvappend("PredictedValue","Treshold")
| eval _ci=95

View solution in original post

Take the 2021 Splunk Career Survey

Help us learn about how Splunk has
impacted your career by taking the 2021 Splunk Career Survey.

Earn $50 in Amazon cash!