Dynamic rangemap values

[tachu]

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

[ziegfried]

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")

[ziegfried]

hehe, np 😉

[kristian_kolb]

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

[ziegfried]

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

[kristian_kolb]

Shouldn't that be OR in the if statement?