1 2 Previous Next 21 Replies Latest reply on Dec 7, 2018 11:14 AM by Ombir Rathee

    Lookup Previous Row - How To?

    Tanner McDaniel

      Hey fellow Tableau users,

       

      I'm trying to figure out how to lookup the previous row in an excel file and see if it matches a particular result.

      I can then use it as a filter the 'True' and 'False' as needed.

       

      This is regards to phone system data. Calls that are transferred into the "Q Reception (8000)" call queue ring all available receptionists in the company. We need to see who our top receptionists are in regards to volume.

      So we need to find all the calls that were picked up by certain users and then lookup the last row so see if it was transferred from "Q Reception (8000)"

       

      Attached files to help you see the full picture if needed.

      Lookup last row.png

        1 2 Previous Next