1 Reply Latest reply on Apr 19, 2018 10:05 AM by Jim Dehner

    Most recent values (ex: last 3 sales)

    Thomas Grau

      Hey everyone, having trouble picking out multiple values over an extended period of time. I need to pull the dates and appointment types for the 3-4 most recent visits for our clients.

       

      Right now I am simply doing serial numbers -> date -> appointment type in the rows, and filtering out locations, service providers and null vales. I have seen the table calculations to pull the most recent values, but how do I pull the rest?

       

      Action list.png

        • 1. Re: Most recent values (ex: last 3 sales)
          Jim Dehner

          Please see the attached approach

          I added a calculation to the rows shelf and made it discrete and set it as shown below

           

           

           

          then I displayed the filter ans took values 0-2

           

          you  can hide the first ()  by right clicking and un-selecting show header

           

           

          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.

          1 of 1 people found this helpful