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:
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", ' ') ENDOf 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:
image.png742557 16.9 KB
Best regards,
Viana
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.