topic Re: Dynamic rangemap values in Dashboards & Visualizations

Dynamic rangemap values

tachu — Mon, 28 Sep 2020 11:53:44 GMT

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

Re: Dynamic rangemap values

ziegfried — Sun, 03 Jun 2012 09:32:59 GMT

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

Re: Dynamic rangemap values

kristian_kolb — Mon, 04 Jun 2012 06:01:45 GMT

Shouldn't that be OR in the if statement?

Re: Dynamic rangemap values

ziegfried — Mon, 04 Jun 2012 10:17:44 GMT

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

Re: Dynamic rangemap values

kristian_kolb — Mon, 04 Jun 2012 17:56:57 GMT

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

Re: Dynamic rangemap values

ziegfried — Mon, 04 Jun 2012 18:54:07 GMT

hehe, np 😉