Hi team, I have a field in my redshift table called status, where it shows all the status that a ride underwent, I want to show the flow of this status from beginning to end, I choose Sankey diagram to implement this, I created other field called “next_status” which is lead(status) over (order by date). I added “status” as source and “next_status” as destination to the sankey diagram, it is giving me the diagram as follows:
.
I want to show the flow of status, but is showing in a diff way, can you please help me, can I show the flow of status; my expected status flow:
booked without provider → manual assigned → tp accepted → tp rejected → tp removed → manual assigned → tp accepted → unknown → tp removed
Please help me how to do this.
