1 of 1 people found this helpful
So, a couple of things here. First, a jump plot encodes a lot of different data. Both the height and length of each "jump" typically have meaning. So, what meaning would each of those have in your case? Do you just want the height to be the same for all of the jumps? The second thing is that jump plots are quite technically complex (just so you are aware). I'd recommend you start with Chris DeMartini's (one of the inventors of the jump plot) blog on how to create them in Tableau: Time to Get Hopping with Jump Plot by Chris DeMartini and Tom VanBuskirk — DataBlick
In order to simplify yours a bit, I'd probably recommend pushing the complexity of the table calculations back to the data source. The table calcs you need are primarily for the data densification needed to draw the curves. You're basically artificially creating 100 points using bins. But instead of that, I created a spreadsheet with 101 records with a single column, T, with values ranging from 0 to 1.
Then, in Tableau, add in the new data set. Then remove your union and join Orders to the new spreadsheet, doing a cross-join using a join calculation of 1 = 1, as shown below:
From here, you'll have to create a series of calculations to create the curves. I won't write all those details here, but I've commented the calcs on the attached workbook so that they are easier to understand.
After all is said and done, you should have something like this. Note: I've added some highlighting capabilities to make it easier to see one of the arcs at a time.
Hope this helps!
Thanks a lot ! You nailed it.