1 Reply Latest reply on Aug 8, 2012 7:05 PM by Dimitri.B

    Tableau Using Calculated Values For Drills (Similar to Vlookup)

    Eric Frishman

      Tableau Users & Data Crunchers,

       

      This example will probably seem a bit "easy", and I'm still learning the platform, and have had a very good experience.  Essentially what I'm accomplishing is similar to using a Vlookup function in Excel to help drive a data drill.

       

      I've enclosed a Tableau Example.  From the dashboard, within Window 1, each point has an IP reference.  Within Window 2 is a data for various IPs across many times.  What I'm trying to do, is have the data within Window 1 reference the last time within Window 2 so that by an action, selecting an item in Window 1 would result in Window 2 data for the specific IP, but only for the last time.

       

      As an example, selecting the circle with IP 121.0.0.0 would result in Window 2 showing 121.0.0.0 306.  Selecting 13.0.0.0 would result in Window #2 showing 13.0.0.0 205.

       

      My thought was to use Lookups from Window#1 to Window#2 to find the last time by IP, and post that to the Level Detail in #1 so that the data could be used as a drill.  However, I have not been successful yet. . . .

       

      Thank you for reviewing and I would appreciate your comments.