3 Replies Latest reply on Jun 8, 2018 1:26 AM by Mavis Liu

    Using order date

    srinadh ch

      Hi everyone. I am new to the Tableau

       

      I have some doubt  Using order date(sample super store).
      I need to  print like this, could you please help me on this issue.

       

       

       

      year
      2012
      2013
      2014
      2015
        • 1. Re: Using order date
          Mavis Liu

          Hi Srinadh,

           

          Please could you provide more detail of what is going along the bottom and what measures represents the size of the bars?

           

          I've made the below:

           

          2018-06-07_15h25_31.png

           

          So on the columns shelf I have dragged in order date, once in the shelf I changed it to a discrete quarter date:

           

          2018-06-07_15h26_27.png

           

          Then I dragged in sales into the rows, then Order date into colour and text on the marks card (this will default to a discrete year field which is fine):

           

          2018-06-07_15h27_03.png

           

          Changes the marks type to a bar:

           

          2018-06-07_15h27_55.png

           

          and that should be it! I've attached the workbook so that you can take a look.

           

          Thanks,

           

          Mavis

          • 2. Re: Using order date
            srinadh ch

            Hi Mavis,

             

            Thanks for reply

             

            Actually i want sales information in every year with previous year total also using(moving total). i need staked bar in each year like that

            i got the soulation.:)

             

            Thanks,

            srinadh

            • 3. Re: Using order date
              Mavis Liu

              Hi Srinadh,

               

              No problem! I took a bit of a guess at which measure you wanted to use but I wasn't too far off with sales at least! But yes, on the measure you can right click and add in the running total table calculation.

               

              If my previous response had helped answer your question, please mark it as correct so that the status of this thread can be updated and closed off.

               

              Thanks!

               

              Mavis

              1 of 1 people found this helpful