I have been searching, but have been having a difficult time finding a case similar to my scenario below. I have a set of tasks, each of which have a start and end date and am trying to get a count of items impacting a certain Team in a given quarter. So as an example, my data source looks very similar to the below in Excel:
TaskStart DateEnd DateTeam 1Team 2Task 11/1/148/1/14YesTask 27/1/148/1/15YesYesTask 310/1/142/1/15Yes
So for Task 1: Tableau would render a value in Q1 '14, Q2 '14, and Q3 '14 for Team 1.
Task 2: Tableau would render a value in Q3 '14, Q4 '14, Q1 '15, Q2 '15 and Q3 '15 for both Teams 1 and 2
Task 3: Tableau would render a value in Q4 '14 and Q1 '15 for Team 1
Any ideas? I can get it to lay out nicely using just the start date, but Tableau can't carry it through to the other quarters in the range.
I apologize if I am not being specific enough here.
Thank you in advance!
For the kind of analysis you want, the data has to be reshaped so you have one row per task & quarter, the query that Johan provided will get you there. Several links to discussions of the subject exist at Utilization, Queues, Census, Throughput for Blocks, Floors, Units, Rooms, Offices, etc. - What do you do?.
