Do the "PMnnn" Columns represent Project Milestones ?
If so, do you need to also display all the "N/A" cells?
At first blush I would think you're better off to have the data sheet in the form of
Date Product Line Project Milestone
1/30/2014 1 A2 PM080
1/29/2014 1 A10 PM100
and so on.
By making "Milestone" into a single Dimension field, you could colorize and filter by it.
It's probably working against you to have every PMnnn be its own Column, because then they are all separate fields and there is no unified date axis to work from.
Tableau supports Gantt charts, so you might try that after reshaping the data.
Thanks for the quick reply. So I took your advice and i'm definitely getting better results with the restructure format. I made some random values you up to view it better. Its a little bland but its definitely an improvement. I also set up the KPI meets, does not meet data and the values im getting to sum the total meets is really high. Any ideas?
I had the N/A's because some projects don't have those Milestones while others do.
project test.twbx 135.9 KB