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?