6 Replies Latest reply on Dec 19, 2014 6:37 AM by lourie.bryan

    How to create a custom column from multiple fields

    lourie.bryan


      I am brand new to Tableau.  I looked through about 20 videos and did some Google searches but I havent quite figured out how to create the display I want.  I am working in the standard worksheet view.  I am extracting data from an Oracle database and trying to format it in a way our users would like to view the data.  To put this particular piece of data together I have to deal with 3 dimensions of data.  Here is what the data looks like in the database:

       

      ITEM_NBR     TYPE_NBR   TYPE_DESC  WEEK1_START_DT      WEEK1_COUNT      WEEK2_START_DT      WEEK2_COUNT

      1111                1                     ASLS              01-SEP-13                     0                                08-SEP-13                      100

      1111                2                     BSLS              01-SEP-13                     100                            08-SEP-13                      100

      1111                3                     CSLS              01-SEP-13                     0                                08-SEP-13                      100

      1111                4                     DSLS              01-SEP-13                     100                            08-SEP-13                      100

      1111                5                     ESLS              01-SEP-13                     0                                08-SEP-13                      110

      1111                6                     FSLS              01-SEP-13                     100                            08-SEP-13                      100

      2222                1                     ASLS              01-SEP-13                     9                                08-SEP-13                      0

      2222                2                     BSLS              01-SEP-13                     888                            08-SEP-13                      10

      2222                3                     CSLS              01-SEP-13                     7                                08-SEP-13                      60

      2222                4                     DSLS              01-SEP-13                     100                            08-SEP-13                      100

      2222                5                     ESLS              01-SEP-13                     0                                08-SEP-13                      0

      2222                6                     FSLS              01-SEP-13                     777                            08-SEP-13                      100

       

      Here is how I want it to look like in Tableau:

       

                                                                            WEEK1                    WEEK2

      ITEM_NBR     TYPE_NBR   TYPE_DESC   01-SEP-13              08-SEP-13    

      1111                1                     ASLS                   0                                100

                              2                     BSLS                   100                            100

                              3                     CSLS                   0                                100

                              4                     DSLS                   100                            100

                              5                     ESLS                   0                                110

                              6                     FSLS                   100                            100

      2222                1                     ASLS                   9                                 0

                              2                     BSLS                   888                            10

                              3                     CSLS                   7                                60

                             4                      DSLS                   100                            100

                              5                     ESLS                   0                                0

                              6                     FSLS                   777                            100

       

      So basically, I want to use the orginal weekly start date columns as a header and put the counts that go with them underneath.  I'm guessing I have to do some sort of custom calculation or similar?  Your help is appreciated.