11 Replies Latest reply on Apr 12, 2018 2:57 AM by Kirstie Townsend

    LOD- FIXED functions Alternative

    Kirstie Townsend

      HI all,

       

      I'm wanting to create a calc field looking like this

      { FIXED MAX[Number] : MIN[DATE] }

       

      Obviously Tableau does not like this as i am using an AGG in the first Part of my calc,

       

      Does anyone know how i can achieve the same results this would provide but using a different calculation.

       

       

      I will try top anonamyse my data to post and example.

       

      I'm trying to get a MAX of a number and for it to show the first time that number appeared, but i also need to include the date in my data table. As soon as date is added to ROW it shows MAX for each and every Date/Time in the data

       

      ANY HELP?