Hi,
I'm working on a work capacity dashboard and some people have projects whose start date is before the completion date of a previous project, ie. there's overlap. I'd like to come up with a calc to "count" how many times a given projects start date is before the end date of a previous project.
So, I want to go from:
to this:
I was able to create a formula in Excel using Countifs() that works well enough (which is how made the second picture). However, I can't seem to create something similar in Tableau.
Maybe someone can help me out with this?
Does your data have a unique ID for the project, such as a project number? If so, then you could join the data to itself like this:
That will duplicate the records, but will also allow us to count the number of overlaps using COUNTD of the project number from the secondary table:
