Grouping Dates in Charts

[Lawrence Mak]

Is there any way to group dates into weeks in pivottables
and pivotcharts, instead of just days, months and
quarters? Thanks in advance.

 

[Tableau]

Lawrence,

Check out Tableau's Visual Spreadsheet, which connects to Excel and
allows you to visually group Dates at any level...from Years down to
Seconds...You just click on the date field and select the grouping you
want. I'd be happy to give you a free trial if you want to try it.

Christian Chabot
Tableau Software
www.tableausoftware.com

 

[Debra Dalgleish]

Right-click on the Date field button
Choose 'Group and Show Detail'> Group
Select Days
Set the Number of Days to 7
If necessary, change the Starting Date to a week start date.
Click OK