Dashboards & Visualizations
Highlighted

Dynamic rangemap values

Engager

I have a query that gets the running revenue number and i want to create a rangemap that shows green if its within 20 percent of yesterdays number what i have so far is

query |table Today,Yesterday |eval toprange=Yesterday * 1.2 |eval lowrange=Yesterday * .8 |table Today,lowrange,toprange and it displays the values i want what i wanted to do was to then provide instead of table go |rangemap field=Today green=lowrange-toprange is there any way to pass calculated values to rangemap

Thanks

T

Tags (1)
0 Karma
Highlighted

Re: Dynamic rangemap values

Influencer

No, rangemap only accepts literal numbers, not fields for the domain values. You can use the eval command, though:

<your query> | eval range=if( Today < Yesterday*1.2 AND Today > Yesterday*0.8 ,"low", "severe")
0 Karma
Highlighted

Re: Dynamic rangemap values

Ultra Champion

Shouldn't that be OR in the if statement?

0 Karma
Highlighted

Re: Dynamic rangemap values

Influencer

Nope. If today's value is within 80-120% of yesterday's value, then output range=low (ie. green).

0 Karma
Highlighted

Re: Dynamic rangemap values

Ultra Champion

Soorryy, I was rather tired when I wrote that...

0 Karma
Highlighted

Re: Dynamic rangemap values

Influencer

hehe, np 😉

0 Karma