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
Hi,
Sorry but I can't post the data because one there is data that I can't share outside of the organization and since I can't access the source I can't delete the sensitive data.
The desired outcome is this:
| Project Name | Task A | Task B | Task C | Task D |
| 12345 | Date1 | Date2 | Date3 | Date4 |
| 67890 | Date5 | Date6 | Date7 | Date8 |
| 25468 | Date9 | Date10 |
I want all of the tasks that correspond with the same project Name to go on the same row, but currently they are creating a new row for each task. Not every task will have a date for each project, but there is a possibility of it.
I don't want to see the real data. I want to see some sample data that shows what the table (or tables) looks like. Mock something up in the same way you've done with the desired outcome.
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