Hi there,
I have a database with a list of products, with 4 steps of production, though not all products go through all steps. Each production step can be done in one of 7 locations.
What I'd like to have is something similar to a sankey diagram where I have all products flowing to each location, the difference though is that I'd like them to be step by step, so the diagram should have columns for each step.
The way it's done now is that all products get subdivided into the steps, next to each other, but not in series.
The way my database is built is that for every product, it has the associated step and the amount produced in that step. I tried pivoting the step column so that for each step i have a different column but then I had a 'null' entry that the Sankey diagram always went to instead of skipping it, and this way I could not include the locations for each step.
Any help on the matter is appreciated, and apologies if I sound a bit naive. The custom visualization I'm using is the "Tassels Parallel Sets Slicer"
Thanks in advance.
