4 Replies Latest reply on Nov 19, 2018 9:49 AM by Don Wise

    Line graph with unique contracts active between start and end date

    Sander S

      Hi everyone,

       

      I have an issue that I need help with: I have some data containing client ID, start dates and end date for which I'm trying to create a graph of total number of contracts that are active at any given time, but only for unique clients.

      I have tried numerous things but could only manage to present a line graph with the amount of contracts that are open, regardless of unique client ID (using running sum over time). How do I do the same, but only for those that are unique? So for example, on 2-6-2013, there should be 1 contract open instead of 2.

       

      I have attached the sample excel sheet.

      Really appreciate any help!

       

      Thanks,

      Sander