7 Replies Latest reply on Oct 3, 2018 10:26 AM by venkatram

    Count for 2 different dates, 1 reference date

    Miguel Pacheco

      Hi all,

       

      I'm trying to use column A as date reference and with that do a count for each day, but also check column B.

       

      for example for day 14/09/2018 column A will appear 12 entries but should also be able to count column B with 25 entries. all of this in the same graph.

      I'm only being able to show on the same graph the count of column B which have equal date to column A, which is the reference date. but should show 12 entries for A and the 25 for B, and not 12 entries for A and also 12 entries for B.

       

      Can anyone try to explain me, if it is possible to do this?

       

      AB
      13/09/201814/09/2018
      13/09/201814/09/2018
      13/09/201814/09/2018
      13/09/201814/09/2018
      14/09/201814/09/2018
      14/09/201814/09/2018
      14/09/201814/09/2018
      14/09/201814/09/2018
      14/09/201814/09/2018
      14/09/201814/09/2018
      14/09/201814/09/2018
      14/09/201814/09/2018
      14/09/201814/09/2018
      14/09/201814/09/2018
      14/09/201814/09/2018
      14/09/201814/09/2018
      15/09/201814/09/2018
      15/09/201814/09/2018
      15/09/201814/09/2018
      15/09/201814/09/2018
      15/09/201814/09/2018
      15/09/201814/09/2018
      16/09/201814/09/2018
      16/09/201814/09/2018
      21/09/201814/09/2018

       

      Thanks in advance

       

      MP