6 Replies Latest reply: Apr 13, 2015 7:19 AM by varun raj RSS

    Count of a field based on two dates

      Hi All,

       

      I am using a chart to display the count of some records. I have a condition where I need to display the sum of records if one date = another.

      Consider this example.

         

      NameDate1Date2
      A4/10/20154/10/2015
      B4/10/20154/10/2015
      C4/10/20154/11/2015
      D4/11/20154/12/2015
      E4/11/20154/12/2015

       

      I need the output as

        

      DateCount
      4/10/20152
      4/11/20150
      4/12/20150

       

      Count of 2 includes records A and B because Date1=Date2. And 0 for the other records.

       

      Could you please advise how this can be done?

      Thanks in advance.