5 Replies Latest reply on Jul 10, 2014 7:45 AM by Ben Neville

# How to color a calendar correctly?

My team is currently developing a dashboard for server analysis, and the sheet we are currently building maps how often servers are meeting business SLAs in a calendar format (this is data for a new set of servers that are still in the testing phase, our success rate is usually better than this ):

In order to get this coloring without purple in the middle (had to stick to the company color palette) and so that days without data appear white instead of red, we had to create a custom color palette which looks like this:

The problem is that if a day falls between a 0.01% and 11.11% success rate, the coloring should obviously be the darkest red possible, but because of this scheme it appears white:

We don't want to stop using the stepped color palette and go back to gradual because this would make those very poor days appear lighter than days at 15%-20% and that's very counter-intuitive. Is there any way to accomplish our goal without making a 10,000 step color palette to cover all values from 0.01% to 100%? If not, what's the best solution that people have found?

• ###### 1. Re: How to color a calendar correctly?

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.

• ###### 2. Re: How to color a calendar correctly?

Perhaps create a calculated field?

IF [SLA Rate] = 0

THEN 0

ELSEIF [SLA Rate] > 0 and [SLA Rate] <= .1111

THEN 1

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

• ###### 3. Re: How to color a calendar correctly?

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.

• ###### 4. Re: How to color a calendar correctly?

This worked perfectly, thank you! Hadn't thought of this as a possibility...

• ###### 5. Re: How to color a calendar correctly?

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.

1 of 1 people found this helpful