topic How to use colormix2 if lowest number is 0 in App Development

How to use colormix2 if lowest number is 0

Peony — Fri, 21 Mar 2025 20:07:19 GMT

Hi all.
Could someone please advise how to adjust the Rank part for colormix2 () to have a gradient starting from 0, not -1? In this case, 0 is the smallest possible number and should be perceived by the function as -1, that is, be in red.

I don't use colormix1 because colours from red to green should go through white colour.

My current results and expression.

=Colormix2 ((Rank(total Sum (Velocity_Sales)))/(NoOfRows(Total)/2), Red(), Green(), white())

Re: How to use colormix2 if lowest number is 0

rubenmarin — Sat, 22 Mar 2025 08:08:06 GMT

Hi, the default formula to convert values to another range is:

(value - min_value) / (max_value - min_value) * (max_range_value - min_range_value) + min_range_value

For a -1 to 1 range it's the same as:

((value - min_value) / (max_value - min_value) * 2) - 1

If you set a predefined range where all values below that range is red, and above is green, it simplifies a lot the calculation, as min_value and max_value will be converted to that fixed numbers.

If you want to get the max a min values you have as the range, the you need to calculated them first to apply them on the formula, just note that in that case, selections can change colors, one value could be white, but if selections changes the values shown, that white could be converted to red or green depending on the new values filtered.

You can also calculate the min and max values on script, and set those values in variables, so you can use them as fixed values.

Re: How to use colormix2 if lowest number is 0

Peony — Thu, 17 Apr 2025 10:19:01 GMT

@rubenmarin thank you much