5 Replies Latest reply on Aug 2, 2018 4:10 AM by Vanessa Zorgia

    Last record of most recent date per name

    Vanessa Zorgia

      Hello everyone,

       

      The data I have are names,dates,chemicals and quantities.

       

      I want to create a graph in which at x axis will be displayed the chemical name ,at the left y axis will be displayed the most recent quantity per chemical/name and at the right y axis will be displayed the average quantity per chemical/name (of all records).

       

      I created a new dimension to calculate the max date per name. I also created a LOD dimension for calculating the consumption based on max date but it's not calculated correctly.\

      Can you help me with this?

       

      Thank you,

      Vanessa