topic Re: using rangemap for +/- infinity in Dashboards & Visualizations

using rangemap for +/- infinity

kevintelford — Thu, 03 Jun 2010 22:34:04 GMT

I'd like to use the rangemap feature to say | rangemap field=myDifference low_pos=0-499 med_pos=500-999 high_pos=1000+ low_neg=-499-0 med_neg=-999--500 high_neg=-1000-

Now I can do the negative side or the positive side, making my high value the default, and just looking for the other two. | rangemap field=myDifference low_pos=0-499 med_pos=500-999 default=high_pos

I can also just bastardize it saying | rangemap field=myDifference low_pos=0-499 med_pos=500-999 high_pos=1000-9999999999999 low_neg=-499-0 med_neg=-999--500 high_neg=-9999999999999--1000

But is there any way to do the above setting high_pos to 1000+ and high_neg to -1000- ?

Thanks

Re: using rangemap for +/- infinity

Stephen_Sorkin — Fri, 04 Jun 2010 00:33:25 GMT

You must be explicit with rangemap. It's a python command, so you could modify it yourself to accommodate this configuration. Alternately, you can use the "case" function in the "eval" command:

... | eval range = case(myDifference < -1000, "high_neg", myDifference < -500, "med_neg", myDifference < 0, "low_neg", myDifference < 500, "low_pos", myDifference < 1000, "med_pos", 1==1, "high_pos")

Re: using rangemap for +/- infinity

kevintelford — Fri, 04 Jun 2010 00:57:33 GMT

Awesome. Thank you 🙂