2 Replies Latest reply on Jun 3, 2016 11:39 AM by Herman Law

    How to graph a distinct dimension based on a Max Date?

    Herman Law

      Hi There,

       

      Let's assume I have a data input of the following and I want to show the distinct count of Vendor's for a given Date (Year) - but based on the maximum Date the vendor exists in the dataset. I only want to consider the Vendor for the latest year it was used in. If it was used in multiple years, I do not want to graph it for those previous years.

       

      VendorDate
      Vendor A2015
      Vendor A2016
      Vendor B2014
      Vendor B2015
      Vendor B2016
      Vendor C2015
      Vendor C2016
      Vendor D2015
      Vendor E2013
      Vendor E2014

       

      I know I can add a last()==0 and do a table calculation and get the following which is the sub data set that I wish to then plot. However, I cannot figure out how to retain the table calculation and generate a bar graph (Y-axis is total Count, X-Axis is Date).

       

      Vendor Date
      Vendor A2016
      Vendor B2016
      Vendor C2016
      Vendor D2015
      Vendor E2014


      I would like to have a bar graph in which shows

       

      2014 - 1
      2015 - 1
      2016 - 3

       

      Any ideas would be appreciated.

       

      Thanks,

      Herman