- Himalini Aklecha
Question
Color Mapping logic based on ‘like\\contains’ string
+10Hello 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.
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 >= {d2020-01-01}
THEN VEKP.BRGEW
END
I hope this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.