TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
Grouping by Weeks on Reports
Cuurently TeamDesk only groups for dates by Day, Month, Quarter, Year, Day in Month, Month in Year. (See attachment) I would like to add week in normal reports and summary reports.

As I am a retailer, we tend to look at sales over the week.


User Experience

Blake Cabot
Date Created
5/24/2013 7:59:47 AM
Date Updated
6/13/2017 6:05:35 AM
Promoted By
Rick CogleyPatricio Bustosmartin oliver
Jeff AibelGii SystemsBlake Cabot
basenine 5/24/2013 6:42:53 PM
Your best bet is to create a Formula date Column (Lets say, [DayOfWeek]) which will give you a start day in the week:

PrevDayOfWeek([Date Column],1) should give you a start day of Monday.

Sunday = 0, Monday = 1, Tuesday = 2… So put a # between 0 & 7 after the column in the formula.

All dates in [Date Column] will calculate to, in the formula above's case, to Monday of that week..

So the [Date Column] is set to either 25/5/2013, 24/5/2013, 23/5/2013… etc and the [DayOfWeek] column will return 20/5/2013.

You can then group all records by the [DayOfWeek] column as they have an equal value.


ps - the [DayOfWeek] column can be hidden on the record after testing
basenine 5/24/2013 6:43:45 PM
****So put a # between 0 & 7 after the column in the formula.

column was supposed to be comma
Blake Cabot 5/27/2013 6:13:35 AM
Still think grouping by week would be easier rather than a calculated field for every report.... given they have Day, Month, Quarter and Year.
basenine 5/27/2013 6:22:49 AM
Quite true. Hope the formula was able to get you out of that spot of bother in the meantime. ;)
Kirill Bondar  Staff  5/27/2013 6:28:59 AM
The only problem at the moment is that the definition of week is country-specific - it can start on Saturday, Sunday on Monday. And now the question is - should we use user's culture or application culture to define a week's date range? If we'll take user's culture, different users may end up with different results while looking at the same view. If we'll take application culture the user may end up with results she does not expect to see.
Jeff Aibel 5/12/2017 8:38:07 AM
Please add Days and Weeks to the grouping option function.

For many things like tasks and/or scheduling, Days and Weeks are more meaningful than Months or Years.

While I know how to do a work around, this comes up sufficiently often that I think it should be a standard selection criteria in the Grouping Function.
Kirill Bondar  Staff  6/13/2017 6:03:03 AM
Week is defined based on Country property of the database
Kirill Bondar  Staff  6/13/2017 6:04:57 AM
Grouping by week is added - week is defined based on Country property of the database. For Date columns "group by equal values" means "group by days".
Kirill Bondar  Staff  6/13/2017 6:05:35 AM
Merged with:
1106 - Grouping Function Needs additional options
Back to Search Results