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


      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