Exclude NULL from Color Mapping

Hi everyone,

does somebody know a possibility to exclude NULL values from the color mapping?

I have an OLAP showing Projects in regards their delivery date differentiating between current internal responsiblity and external. For internal we measure against an internal deadline, while for externals this date is empty. So the color mapping should only apply on the lines with filled values, but all Null values are set red:
image
image

Best regards,
David

Hi David,

unfortunately, this is not possible at the moment.
However, it is possible with a workaround - you can put your KPI in a case when and replacing the NULL value with NULL string :
CASE WHEN ISNULL("KPI") = 1 THEN 'NULL' ELSE CONCAT("KPI", ' ') END

Of course you would need to be aware that the KPI now has a space after the number. But you can then confgure the colour mapping:

Best regards,
Viana

1 Like

Hi Viana,

works perfectly, thank you! :slight_smile:

I took ‘-’ instead of ‘NULL’ to be equal to normal NULL values. For some reason it won’t accept now the format of the cell and keeps the single decimal, but I will figure out how to fix that as well :smile:
image

Best regards,
David

1 Like