5 Replies Latest reply on Oct 17, 2013 11:19 PM by Prashant Sharma

    Number of active issues using open and close dates

    David Rowe

      Hi,

       

      I have a set of data of issues with one column for "open date" and one column for "close date".

      If an issue is still open, the close date is empty.

       

      I want to figure out how many issues are open for each calandar month.

       

      I am able to plot the number of issues opened and the number of issues closed per month on a dual axis graph, but I cant figure out how to get tableau to plot the difference.

       

      I cant do it with a table calculation as I can only get the data in the same view using a dual axis graph...

       

      Been stuck on this for a while now!

       

      Thanks in advance for the help.