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:

Task

Start Date

End Date

Team 1

Team 2

Task 1

1/1/14

8/1/14

Yes

Task 2

7/1/14

8/1/15

Yes

Yes

Task 3

10/1/14

2/1/15

Yes

So for Task 1: Tableau would render a value in Q1 '14, Q2 '14, and Q3 '14 for Team 1.