9 Replies Latest reply on Oct 13, 2016 10:55 AM by David Li

    Need help with a table calculation using lookup

    Ujval Gandhi

      I have a data set with the following columns

       

       

          

      idtstampcategory idsub category idSeqNum_tstamp
      11/1/2016384341
      11/1/2016374222
      11/1/2016374233
      11/1/2016374244
      11/1/2016374255

       

      I want to add a new column "Hop" using tableau. Basically, the logic is


      For the user within a category, the first category they see is the initial start point. I would then expect the sub category to be incremented incrementally. If the order is sequential, the Hop is set to 0 but if I see a non sequential sub category id within the same category, the hop should be set to 0. attaching the excel data