1 Reply Latest reply on Aug 14, 2018 9:32 AM by Jim Dehner

    Filter dimension based on date

    Oliver Mayer

      Hi all,

       

      in my table (MySQL connection) I have user addresses. Everytime a user changes his address a new row is created for his unique member ID and the date of the address change is saved. This will look like this:

       

      Screen Shot 2018-08-14 at 5.53.40 PM.png

       

      What I want to do now is to filter my data set in a way, that for each Member Id only the row with the maximum date remains (with the last address change). For some Ids in my example this would be 2018 for some 2017 and so on.

       

      How can I achieve that? I've been searching for a while now but cannot find a solution that works.

       

      Thanks!

        • 1. Re: Filter dimension based on date
          Jim Dehner

          Good morning

           

          try this {fixed [member id]: max(year of last)} = [year of last]

           

          put on the filter shelf and set to true

          it will be like this

           

           

          Jim

           

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.