topic Re: Table colouring by overall range in Dashboards & Visualizations

Table colouring by overall range

PickleRick — Wed, 10 Nov 2021 14:26:52 GMT

I'm a bit confused.

I tried to colour one of the columns in my table by the range of values in that table.

And it works.

Almost.

The problem is that colouring works separately for each page of results which is a bit ridiculous.

These are two pages from the same search. Kinda ridiculous, isn't it?

Is it that I'm doing something wrong? But it seems that there's no simpler way than chose "range", preset...

But how to make it work across whole results range (so my first screen shoud be mostly orange-ish (sorry, don't know how this colour is called in english), and the second should be blue)?

Re: Table colouring by overall range

soumyasaha25 — Wed, 10 Nov 2021 15:31:54 GMT

I am guessing you have used the Color settings with mode "scale" set to the Presets - divergent

something like this:

so this applies the settings dynamically as you move to the later pages - page 1 vs page 13 in your screenshots. So this color scale maps the colors as per the values in each page.

What you could do is:

option 1. Set some static ranges and associated color for them like below

option 2. you could define a "custom" scale (as you did already) but define some sort of static range by specifying min, midpoint and max values for the logcount number

Re: Table colouring by overall range

PickleRick — Wed, 10 Nov 2021 16:11:47 GMT

Yeah, I know of those options but they each require me to input fixed values. That's the point.

If I can't help it, I'll have to do a dynamically created field used just for colouring and just hide it in the dashboard (won't work in a "normal" report) but it's not a very pretty solution.