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, so it works and I was able to get rid of the duplicating rows which is great! But now I have a different problem. My task name column doesn't show every single task because there isn't a task associated with it. Is there a way to show all column even if there isn't a date available for it?
I have this option checked shown in the picture below and it didn't change anything.
What I currently have:
| Project | TaskA | TaskB | TaskD | TaskF |
| 12345 | Date1 | Date2 | Date3 | |
| 67890 | Date4 | Date5 | ||
| 45678 | Date6 | Date7 |
What I want:
| Project | TaskA | TaskB | TaskC | TaskD | TaskE | TaskF |
| 12345 | Date1 | Date2 | Date3 | |||
| 67890 | Date4 | Date5 | ||||
| 45678 | Date6 | Date7 |
I want all columns to be shown whether theres a value or not.
TaskName and Date are calculated columns. TaskName is numbering the key tasks from 1-6 and then Date is looking at this column and pulling either the end date or the start date depending on the task name.
I would assume that there's something I need to add to my if statement in the date column to do this, but I only want the rows that correlate to the key tasks and not the rest. There is over 100,000 rows in this data source and over half are not needed.
Basically what's happening is that there aren't any tasks in the Original TaskName column that matches the KeyTask Name and because of that there isn't a date to look for since it's not there and thus it won't show up in the matrix.
Thanks!
If the tasks were in a separate related dimension table, the 'show items with no data' should work