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
HotChilli , I realized now that you're looking for how the data is coming into the source.
Here's how it looks before I manipulated it to pull out my individual tasks:
| ProjectName | ProjectID | TaskName | TaskID | Start Date |
| 12345 | id1 | random task | taskid1 | date1 |
| 12345D | id1 | TaskA | taskid2 | Date2 |
| 12345 | id1 | task2 | taskid3 | date3 |
| 12345 | id1 | TaskB | taskid4 | date4 |
| 67890d | id2 | task1 | taskid5 | date5 |
| 67890 | id2 | TaskA | taskid6 | date6 |
| 67890 | id2 | TaskC | taskid7 | date7 |
| 56738 | id3 | TaskD | taskid8 | date8 |
This is basically how the data appears in the table editor and the bolded rows are the tasks I'm looking for. Table below is the manipulation I've done so far to get my desired tasks (these are calculated columns within the table above just pulled out separately to show easily)
| TaskA | TaskB | TaskC | TaskD |
|
|
|
|
Date2 |
|
|
|
|
|
|
|
| date4 | |||
| date6 | |||
| date7 | |||
| date8 |
Task columns are calculated by: TaskA = if(TaskName = TaskA, StartDate, "")
I hope this helps and I appreciate you helping me.
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.