How to Display First or Last Date of the Week Instead of Week Number

In some cases, you may want to display the first or last date of the week instead of the week number in widgets. This can be achieved by configuring the widget settings as described below. This article explains how to achieve this in the chart and pivot grid widgets, which is similar for all widgets.

Chart Widget

To display the first or last date of the week in a chart widget, follow these steps:

1. Configure the date field as follows:

   • Column(s): Date format of the date field - Date(OrderDate)
   • Filters: Week Of Year format of the date field - WeekOfYear(OrderDate)

2. Apply a Top N filter for the date format field (Date(OrderDate)).
   
   After applying these configurations, the chart widget will display the week date instead of the week number.
   

Pivot Grid Widget

To display the first or last date of the week in a pivot grid widget, use the following configuration:

Note : Do not apply the filter in the field WeekOfYear(OrderDate) in the Filters section of the pivot grid configuration.