In the table you sent Alan i cant see the all 3 data points, i see the created date (the coloured lines) then i see the duration to what i think is completed? but at what point is the "assigned Date"?
I am looking for some thing like this, i have 5 date points that i want to use to show a time line,
Quality Check Date
These are each a col in Excel, then i have "Customer Name" & "Product ID"
I want to filter down to a month (which i can do) then have "Customer Name"/"product ID"/PROCESS in the columns with number of days along the rows.
PROCESS to be the activity between the date points, so Order Date to Pick Date would be 'Picking", Pick to Build would be "Construction" Build to QC would be Checks and Checks to Ship would be ship.
The idea is to see how long each Product ID takes to through the whole process, but break it down to show which bits take longer?
Gantt Chart 1.xlsx 10.4 KB
Ben, in Alan's data the assign date and create date were exactly the same. That's why you're not seeing a difference. I've reshaped your data using the Excel Reshape plugin. (See attached.) Use Sheet -Tableau to create a workbook and get as close as you can to what you're looking for. If you get stuck post back and I'll take a look.
Gantt Chart 1-Reshape.xlsx 12.8 KB
I see, so would there be 2 lines if say the Assigned date was a day later? ill have a go with that data you kindly re-shaped and see what i get with that..
Thanks for that, i see what you have done and i also see how that could work, but i cannot re-shape my excel sheet, there is about 5k live lines and im into CF in columns. its a monster (i walked into it rather than created it)
I guess the solution would be to Focus on specifics some how, take a data extract and present it like that. its a bit more work but at least then i could get what i need. unless i can work this out in a calculated field??
thanks for the advice.
I see, so would there be 2 lines if say the Assigned date was a day later?
No because duration is on the size shelf. But if you want a line at the beginning of the bar you can add one using a reference line set to minimum of assigned date per cell.
I'll be interested to see what you come up with.
ill be interested to see what i come up with .. haha.. ill let you know how i get on!