6 Replies Latest reply: Jun 4, 2018 3:25 PM by Chris Cammers RSS

    Max Date

    Robert Erickson

      The Data Set I'm working with resembles this:

       

      User           Import Date          Last Login Date          Days Since Last Login

      Mary           5/2/2018                4/9/2018                     51

      Mary           4/25/2018              4/9/2018                     51

      Mary           4/9/2018                4/9/2018                     51

      Mary           4/3/2018                3/262018                    65

      Mary           2/26/2018              2/23/2018                   96

      Mary           2/17/2018              2/8/2018                     111

      Jerry           5/2/2018                4/11/2018                    49

      Jerry           4/25/2018              4/9/2018                     51

      Jerry           4/9/2018                4/9/2018                     51

      Jerry           4/3/2018                3/262018                    65

      Jerry           2/26/2018              2/23/2018                   96

      Jerry           2/17/2018              2/8/2018                     111

      Tony            4/25/2018              4/1/2018                     43

       

      I have two requirements:

       

      First, in the Chart on the Sheet, I need to return the row that contains the most recent Import Date for each User.  For example:

       

      User           Import Date          Last Login Date          Days Since Last Login

      Mary           5/2/2018                4/9/2018                     51

      Jerry           5/2/2018                4/11/2018                   49

      Tony           4/25/2018              4/1/2018                     43

       

      Second, I need another Chart that returns the rows where the Import Date for the User equals the most recent Import Date in the entire data set.  For example:

       

      User           Import Date          Last Login Date          Days Since Last Login

      Mary           5/2/2018                4/9/2018                     51

      Jerry           5/2/2018                4/11/2018                   49

       

      I've try RangeMax() and Aggr() functions, but I can't get them to work.

       

      Thank you for your help