I'm dealing with a sea port problem. Currently, I've got the stacked bar chart of total operation times of different block(y axis) of each time bucket(x axis). Now I need to compare this chart with the vessel actual berthing time to see which vessel cause obvious increase to the operation times. I tried reference line but it didn't work .Now I can only use outside script to obtain the berthing time and use a transparent chart on the bottom like the attachment 1. Every small stack has an actual berthing time value, and many share one value.
The problem of attachment 1 is the pop-up can not be displayed since it's in the bottom. Is it possible to achieve the effect like attachment 2? I mean make the arrow part of the chart and the relative vessel information can be shown.
Create another chart, e.g. a straight table, with the ship id and berthing time as dimensions and the operation time as expression. Then sort the chart descending by operation time. You can immediately see which ships have an excessive operation time and the berthing times of those ships.