@niketnilay the solution you suggested is exactly what I need.
However when using threshold based colorPalette the problem is that I need to define constant thresholds:
<scale type="threshold">0,20,40,60,80,90,95</scale>
In my case I don't know in advance what will be the max value. I am getting it from the query dynamically. Therefore I would like the thresholds to be percentile of this value.
It will look something like this:
<scale type="threshold">0.33*MaxData,0.66*MaxData</scale>
Is this doable?
I also tried to calculate these values in the query itself:
| eventstats max(data) as MaxValueColoring
| eval 33Precentile=0.33*MaxValueColoring, 66Precentile=0.66*MaxValueColoring
And then pass them as the thresholds values but this is not working either:
<scale type="threshold">33Precentile,66Precentile</scale>
... View more