Date Filter from 2 different dates in Tableau

42 Views Asked by At

I'm working in Tableau. Here is the sample of data EXAMPLE

ID     Start Date      End Date
1        2011            2012
2        2011            2013
3        2012            2012
4        2010            2013
5        2012            2012

In final I need to have count of how many IDs started and ended by years.

For this example it should look like this:

Year   Started    Ended
2010      1         0
2011      2         0
2012      2         3
2013      0         2

Maybe you have any thoughts how can I reach this result? I'm working in Tableau desktop/prep-builder

0

There are 0 best solutions below