Sorting and changing color in Bridge Chart

Hi Team,

Need some help about Bridge Chart.

I tried to create a Bridge Chart with Dimension and Sorting as below:

CASE WHEN “DELIVERIES”.“RGK_DRRA”>0 AND “DELIVERIES”.“RGK_DRRC”>0 THEN ‘Late SL’
WHEN “DELIVERIES”.“RGK_DRRA”<-3 AND “DELIVERIES”.“RGK_DRRC”<-3 THEN ‘Early SL’
ELSE ‘Ohters’ END

And the Aggregation is COUNT(“DELIVERIES”.“DELIVERY_ID”)

But the sorting is not what I want, and the colors are all black. Could anyone help me with sorting and changing colors?

Thanks a lot.

Hello,

thank you for your question.
Is it possible that you could provide me with some additional information about the Data Model? What is the Case Table in your Data Model and how are the Deliveries Table and the Case Table joined? It would also be great if you could tell me what kind of format the fields “RGK_DRRC” and “RGK_DRRA” have and which value range they have.

Thank you very much,
Florentin

Hello,

My Case Table is some sales order lines and the Deliveries Table is delivery notes, they might be connected via sales order IDs, but one sales order could have several delivery notes.

The fields “RGK_DRRC” and “RGK_DRRA” are ranges between two date, from -2043 to 1642.

Looking forward for your feedback.

Best Regards,

Chen Lei

Hi Chen Lei,

To answer your other questions:

You can change the sorting by choosing either your dimension or your KPI as sorting in the main Tab of the Component Options. If you choose the dimension it will sort the components alphabetically. If you choose the KPI it will sort the columns by COUNT(“DELIVERIES”.“DELIVERY_ID”) in ascending orders. If you want the highest columns to be to the left, you can click “Pin scrollbar to the right”.

You can colour your columns by selecting “Data Series: YOUR KPI” from the drop down under “Component options”. Then, if all you care about is the columns having different colours, then click on “Series Palette” and either select one of the premade pallettes or make your own. If you want the Column colour to correspond to the height of the column you can instead define a “Series colour mapping”, setting as many thresholds and corresponding colours as you like.

I hope this helps answer that part of your question.

Best wishes,
Calandra

Hello!

Thank you for feedback.
But my setting seems different from yours. Am I using an old version? How could I get the same settings like yours?

Hi Chen Lei,

I have discussed your problem with other member of the Data Science Team and it turns out that your company uses a special version Celonis. Normal (or at least current) Celonis versions dosn’t have Bridge Charts so I have never used one before. I also currently don’t have access to your special edition it to experiment with so I can’t find a solution for you. We have passed on your question to those responsible for developing this custom version Celonis so that they can either answer your question for you or supply us with the means to do so. Please be patient with us, after all as you know deviations from standard processes significantly increases throughput time :wink: .

Best wishes,

Calandra

Hi,

Thank you for your support. Looking forward for further feedback.

Best Regards,

Chen Lei

Hi Chen Lei,

thank you for your patience. I have now been able to get access to the bridge chart Component and can finally answer your questions.

You can change the sorting by using a modified version of the CASE WHEN statement you’re already using for your dimension. Replace the category names with numbers specifying the order in which you want the columns to appear.

In your very first post in this thread you wrote the code for your dimension. So if for example you wanted the columns to appear in the order (from left to right): “Others”, “Late SL” and “Early SL”.

So instead of

CASE WHEN “DELIVERIES”.“RGK_DRRA”>0 AND “DELIVERIES”.“RGK_DRRC”>0 THEN ‘Late SL’

WHEN “DELIVERIES”.“RGK_DRRA”<-3 AND “DELIVERIES”.“RGK_DRRC”<-3 THEN ‘Early SL’

ELSE ‘Others’ END

In sorting you would write:

CASE WHEN “DELIVERIES”.“RGK_DRRA”>0 AND “DELIVERIES”.“RGK_DRRC”>0 THEN 2

WHEN “DELIVERIES”.“RGK_DRRA”<-3 AND “DELIVERIES”.“RGK_DRRC”<-3 THEN 3

ELSE 1 END

You can change the colors of the columns by writing different Hex color codes in the box next to the word Colors. Please note it’s important that the total number of color codes listed in the box must match the number of columns, otherwise all the columns will have the same columns. I suspect that as you changed the dimension to include 5 categories instead of the original 3 the color setting didn’t update to reflect this resulting in all the columns being black, just add two more color codes (separated with a semi colon) and the problem should go away.

I hope this answers your question.

Best wishes,
Calandra

Hello,

Thank for your strong support. I succeed. It really helps a lot.

Best Regards,

Chen Lei