Could you please share the sample workbook with sample data so I can try from my end.
Try Pivoting the three date columns in the Data Source tab of your workbook, and then using the "Field Names" field on the color shelf - this should 'split' the line graph into the three types of dates as you've suggested in your image.
I'm assuming there's more data corresponding to the values for your Y axis that give a different value per item per type of date. If you post a sample workbook we can do more.
I am attaching my sample workbook. You can see I was able to display the lines in separate graphs but not on a single curve. No other data that is relevant to stacking up the data, I am simply looking to display a cumulative total over time for each milestone.
Thank you for your responses.
SampleDataWorkbook.twbx 22.0 KB
1 of 1 people found this helpful
Hey Justin. Ok, check it out:
These are the lines I get from re-working your file a bit. I moved the data round until I could get the Pivot option to show up in the Data Source screen, like so:
This gives you your 3 Date fields under two columns, where Pivot Field Names is the 'type' of date: closed, final, or opened, and one is the actual date, and Pivot Field Values is the actual values, in this case the dates. This gives you 3 rows for every item name, one for each Date type.
Putting the dates in the column shelf and the Count of the dates, like you did, makes for a single line counting all the instances. Dropping the Pivot Field Names onto the Color shelf separates the line by each value within that one, in this case again the 3 types of dates.
Will this work for your purposes? Hope it helps.
Also look up Pivoted/Unpivoted tables, or Normalized tables to get some more information on this.
Here's your workbook with the lines so you can have a look.
Thank you. Looks like Tableau 8.2 doesn't allow me to pivot on the data but your pictures do accomplish what I need. Looks like I will be seeking an upgrade.
One method you can try on version 8 is below.
Duplicate data source to three set.
1. Open ==> Create new field of "Date" which equals as Open date
2. Close ==> Create new field of "Date" which equals as Close date
3. Final ==> Create new field of "Date" which equals as Final date
4. Date ==> Add one more data set as Date which cover first date of Open and the last date of Final.
Make data relationships.
Primary data is 4. Date and put other 3 from respective data source.
SampleDataWorkbook 8.3.twbx 72.5 KB