4 Replies Latest reply on Oct 9, 2019 7:26 PM by Sean Wood

    Calculated Field FIXED:MAX help required

    Sean  Wood

      Dear all,


      My apologies if this appears to be a simple question.


      My task is to find the most recent piece of content a registered person viewed and make a list of the people and content.


      I have a set of email addresses, a list of content viewed by those email addresses and the last time a person accessed each piece of content.


      Some email addresses (i.e. people) have viewed more than one piece of content.


      I am struggling to create a list of email addresses with the most recently viewed piece of content listed.


      See attached screenshot below:



      Fixed Max Filter Illustration.png

      I am trying to use the following calculated field:

      {FIXED [Email] : MAX([End Time])}

      Screen Shot 2019-10-10 at 9.59.43.png


      Any suggestions would be appreciated. I would also appreciate it if anyone could spell out their suggestions a little as I am new to Tableau.


      Kind regards,