2 Replies Latest reply on Aug 30, 2018 1:16 AM by Jasper Li

    About Grouping Sequence

    Jasper Li

      Hello everyone. I want to ask a question about grouping values of sequence in the pivot table.

       

      For example, I have a pivot table with rows = id and columns = sequence, like the example below:

       

      id
      1
      2
      3
      4
      5
      1AAAB
      2ABCCC
      3BCC
      4ABCB

      B

       

      Is it possible to group the sequence as a table like below:

       

      id
      1
      2
      3
      4
      5
      1AB
      2ABC
      3BC
      4ABCB

       

       

      Also, it is better to have the counts of each values as a tooltip if possible.

       

      Thank you.

       

      Best Regards,

      Jasper

        • 1. Re: About Grouping Sequence
          Patrick A Van Der Hyde

          Hello Jasper,

           

          The data is so generic that I am unable to determine how/what you are trying to do.  Usually with a pivot table, it would be better to turn that first table to:

          Column, Row, Value

          Column 1,ID 1, A

          Column 1,ID 2, A

          Column 1,ID 3, B

          Column 1,ID 4, C

          Column 2,ID 1, A

          Column 2,ID 2, B

          Column 2,ID 3, C

          Column 2,ID 4, B

          Column 3,ID 1, A

          Column 3,ID 2, C

          Column 3,ID 3, C

          Column 3,ID 4, C

          Column 4,ID 1, B

          Column 4,ID 2, C

          Column 4,ID 4, B

          Column 5,ID 2, C

          Column 5,ID 4, B

           

           

          So you can easily recreate the table in Tableau and do analysis:

           

           

          i hope this helps. 

           

          Note that Tableau Prep will help you to do this sort of quick data pivoting as well if you have not tried it.

           

          Patrick 

          • 2. Re: About Grouping Sequence
            Jasper Li

            Hello Patrick,

             

            Thank you for your reply. I am trying to group the time sequences, which are marketing channels in my case, for example, User A have clicked a sequence of ads (may be google ads, facebooks ads ...) and for each time until he have done something, I can have a sequence like: google ads -> google ads -> facebook ads -> facebook ads -> email -> ..., and I want to group the same types but keep them in sequences' form.

             

            Hope this make you know what my question is.

             

            Thank you.

             

            Jasper