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
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
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?