Forum Discussion
Task Names Separate lines for Same Project
Great. Thanks for the data.
Does the ProjectName have typos? (additional upper case and lower case d on some names - i edited them)
I created a matrix visual (with ProjectName in rows, TaskName in Columns, First Startdate in Values).
I used the filter pane to filter TaskName to Task A, B, C, D.
and this is what I got
Thanks for the help. I knew it was simpler than I was making it out to be.
The project name could have different ways of writing it and I believe I was able to figure that out myself. As for the matrix, I recently found out that the dates used for say Task A is considered the start date and the date for the rest of the tasks (B,C,D) is the end date. Is there a way in the matrix to denote this?
possibly add a calculated column to add text "Start Date" to "Table A" and "End Date" to everything else.
Use this new column instead of Task Name in the matrix Column.