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
Hi Erik, this is the data im using, with source as assignment_action and destination as next_assignment_action, here my goal is to show the flow of the assignment action, so I created next_assignmnet_action using lead(status) over (order by date). my ultimate goal is to show the flow(exact flow in the assignment action field) but im ended up getting the above diagram. please help me.
Hi @Sainath,
It’s been awhile since last communication on this thread, are you still encountering the same issues or were you able to find a work around for your case?
For additional context, could you explain a bit more what you mean by your expected status flow?
If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.
Hi @Sainath,
Since we haven’t heard back, I’ll close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
