2 Replies Latest reply: Aug 31, 2018 3:56 PM by Jahanzeb Hashmi RSS

    Barchart a count of distinct records YTD and Past year

    Maurizio Masini

      Hi, I saw some similar questions & answers, but none was helping me... so thanks for helping.

       

      I have a table with some records, N. and Type that I count distinct to chart, based on a date.

       

      I'd like to have a bar chart that plots the count for each month (like I can do now) and also for the same month the previous year. I.e.

      Untitled.png

      My data is like:

      N.TypeDate
      1234A01/01/17
      5678A01/01/16
      8906A01/01/18
      8906B01/02/18

       

      So, the need of the distinct is because I want to count the same N. if a different type.

       

      Any insight is appreciated.

       

      Maurizio