Color Mapping logic based on 'like\contains' string

Hello Celonis team,

I would like to know how I can conditionally color the columns of a column component based on ‘like\contains’ logic?

I am using round_month on my x-axis but I want to color all bars for 2019 separate for the ones from 2020. In my experience, color mapping will only allow me to set a color for the entire string in the dimension.

Thank you.

  • Himalini Aklecha

Hello Himalini,

unfortunately, this is currently not possible by using color mapping. However, you can try to use different KPIs (which result in a different bar) but filter only for those values where you want to have another color.

Example:
CASE WHEN
“VEKP”.“ERDAT” >= {d’2020-01-01’}
THEN “VEKP”.“BRGEW”
END

I hope this helps!