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



      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.