Dashboards & Visualizations

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 top_range=Yesterday * 1.2 |eval low_range=Yesterday * .8 |table Today,low_range,top_range and it displays the values i want what i wanted to do was to then provide instead of table go |rangemap field=Today green=low_range-top_range is there any way to pass calculated values to rangemap

Thanks

T

Tags (1)
0 Karma

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

Influencer

hehe, np 😉

0 Karma

Ultra Champion

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

0 Karma

Influencer

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

0 Karma

Ultra Champion

Shouldn't that be OR in the if statement?

0 Karma