14 Replies Latest reply on Feb 26, 2018 6:48 AM by Arvind Salunkhe

    How to display data per week (7 days) instead of usual "week" in Tableau bar graph?

    malou.puyod

      Hi,

      I have a bar chart which displays per week data (week 1-52 or 1-53).  My user wants to have a parameter (option) to choose whether to display 53 weeks OR  exactly 7 days per week.  For 52 or 53 weeks, I was able to do that using week of the calendar date however I do not know how to display exactly 7 days per week.

       

      Eg.

      January 1-7

      January 8-14

      January 15-21

      January 22-28

      January 29-Feb 3

      ...... until December

       

      Here's my current 53 weeks bar chart:

      53 weeks.jpg

      The screenshot above displays per week data which ends every Saturday so week 1 is Wed to Saturday (Jan 1-4) like the image below.

      week.jpg

       

      How about displaying exactly 7 days per week?  Example:

      January 1-7

      January 8-14

      January 15-21

      January 22-28

      January 29-Feb 3

       

      Hoping someone can help me here.

       

      Regards,

      Malou