Skip to main content
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 >= {d2020-01-01}
THEN VEKP.BRGEW
END
I hope this helps!

Reply