10 Replies Latest reply on Jul 1, 2016 4:18 AM by paolo.raia

    Gantt Chart - calculate occurences between date periods

    paolo.raia

      Hi there. 

       

      First post and pretty much a newbie!

       

      I have created a simple gantt chart (below) and am trying to calculate the number of occurrences between each date period:-

      So for example, the yellow "wonky" line is showing 5 occurrences for the period 26MAR to 10APR.  How can I calculate this and even transpose the results to a crosstab?

       

      Many thanks in advance.