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
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")
hehe, np 😉
Soorryy, I was rather tired when I wrote that...
Nope. If today's value is within 80-120% of yesterday's value, then output range=low (ie. green).
Shouldn't that be OR in the if statement?