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.
Page 1 / 1
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
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
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.
Column Sorting.PNG487657 18.8 KB
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.
Change Column colour.PNG546516 18.6 KB
I hope this helps answer that part of your question.
Best wishes,
Calandra
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.
Column Sorting.PNG487657 18.8 KB
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.
Change Column colour.PNG546516 18.6 KB
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?
Capture.PNG1012892 36.7 KB
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?
Capture.PNG1012892 36.7 KB
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 dosnt have Bridge Charts so I have never used one before. I also currently dont have access to your special edition it to experiment with so I cant 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
.
Best wishes,
Calandra
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 dosnt have Bridge Charts so I have never used one before. I also currently dont have access to your special edition it to experiment with so I cant 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
.Best wishes,
Calandra
Hi,
Thank you for your support. Looking forward for further feedback.
Best Regards,
Chen Lei
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 youre 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 its 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 didnt 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
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 youre 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 its 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 didnt 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
Thank for your strong support. I succeed. It really helps a lot.
Best Regards,
Chen Lei
Hi - Bridge charts (waterfall charts) are something that we would like to work with. Would it be possible to make this available on IBC?
Kind regards,
Bronwyn
Kind regards,
Bronwyn
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.