1 Reply Latest reply on Apr 29, 2013 12:37 PM by Tracy Rodgers

    grouping dimension in chart

    andrey uvarov

      i want to create chart like this:

      chart example.jpg

      in my chart i need group week by year. Can i do this in Tableau? i want to get continuous chart.

        • 1. Re: grouping dimension in chart
          Tracy Rodgers

          Hi Andrey,


          This can be done in two ways. The first is to simply place Year and Week Number on the columns shelf with sum of your measure on the rows shelf. This will cause the line to break. Another option is to create a calculated field similar to the following:


          datename('week', [Order Date]) + " / " + datename('year', [Order Date])


          However, this will cause the date to be a string. Right click on it and select Sort by: [Date Field]


          Hope this helps!