Are there datapoints on the other days that are null or 0 values, or does that intersection of data simply not exist? I suspect the former, but want to be sure.
Perhaps create a calculated field?
IF [SLA Rate] = 0
ELSEIF [SLA Rate] > 0 and [SLA Rate] <= .1111
and so on....
Drag this calculated field to the color marker and setup the colors for each of the cases - 0,1,2 etc.
You could give the 0,1,2 more meaningful names like the brackets i.e. 0%, 0.01% - 11.11% etc
The other days are all null, as we haven't yet had a day without any jobs succeeding, but I don't want to count on that, especially during a testing phase.
This worked perfectly, thank you! Hadn't thought of this as a possibility...
1 of 1 people found this helpful
The only downside of this approach is that it deals with pre-set buckets, and won't dynamically scale for the future. If you want something that truly scales, you may use something like the following (based upon what I think you have, which is a 9-color diverging palette):
IFNULL([SLA Rate], -WINDOW_MAX([SLA Rate])/9)
Set this to use a full color range, and only the null values should ever use white, regardless of what your ranges scale to be.