Skip Navigation
Expand
Displaying the week dates in a report
Answer ID 2217   |   Last Review Date 12/12/2018

How can I display the dates for the week instead of just a number?

Environment:

Analytics, Date Grouping
Oracle B2C Service, All versions

Issue:

When I run a report and use "week" as the date grouping, the report lists a numerical value for the week (1, 2, 3, 4...) instead of the date interval for that week.

Resolution:

This is as expected because the 'week' grouping counts the weeks in a year.  That is the numerical value you are seeing.  However, when generating reports, you may want to select Week Start for the Date Grouping field instead.

When Week Start is selected, the date of the Sunday in the interval is listed in the report.  Within the Oracle B2C Service application, weeks are from Sunday through the following Saturday, so the week start is considered to be the Sunday involved with the interval.

For example, if you generate the Answers Viewed report and select Week Start for the date grouping, the data is grouped by week and the Sundays are listed in the report as an indicator of which week the data is reporting.

To help illustrate the difference, look at the Date column in the screen shots below:

Image

Available Languages for this Answer:

Notify Me
The page will refresh upon submission. Any pending input will be lost.