How to Customize the Start Day of the Week in Bold BI

Customizing the Start Day of the Week in Bold BI

Introduction

This guide outlines the steps required to customize the start day of the week in relative date filter, expression, and widget aggregation using the Data language option in the language settings.

Steps to Customize Start Day of Week

I. Relative Date Filter

Step 1: Set language

• Navigate to the site settings.
• Select English (United Kingdom) for Monday or English (United States) for Sunday as the start day of the week.
• Every language setting will reflect the cultural norm for the start day of the week.

• Save the changes and refresh the application to apply the new language settings.

Step 2: Create a data source

• Establish a data source within your application.
• Add a grid widget to your workspace.
• Drag the Date field into the Column Box of the grid widget.
• Click ‘Week of Year’ and choose the relative date filter option.
  
  

Step 3: Configure the relative date filter

• In the Range Box, select Week.
• In the Period Box, choose Current Week.

For Monday’s configuration:

For Sunday configuration:

• Confirm the changes by clicking OK.

Step 4: Result

• For Monday configuration, the grid widget will display the date range from Monday to Sunday (for example, 29/01/2024 to 04/02/2024).

• For Sunday configuration, the grid widget will show the date range from Sunday to Saturday (for example, 01/28/2024 to 02/03/2024).

II. In Expression

Step 1: Set language

• Follow the same language setting steps as outlined in the previous section.

Step 2: Create a data source with an expression

• Establish a data source within your application.
• Add an Expression of DATEPART (WEEK, [Date]).

Note: Use DATENAME (WEEK, [DATE]) in some plugins.

• Save and preview the table for Monday – English (United Kingdom).

Step 3: Reset the Language and Preview

• Change the language to the appropriate setting and save.
• Refresh the application to apply the new language settings.
• Re-save the existing expression with a DATEPART week and preview the table for Sunday – English (United States).

III. In Widget Aggregation

Step 1: Set language

• Follow the same language setting steps as outlined in the previous sections.

Step 2: Create a dashboard

• Establish a data source within your application.
• Create a dashboard with the above data source.
• Add a grid widget to your workspace.
• Drag the Date field into the Column Box of the grid widget.
• Click ‘Week of Year’ or ‘Week year’.

• Publish the Dashboard.
Monday – English (United Kingdom)
• Week Of the year of 10/03/2024 (Sunday) – 10, Week Year - Week 10 2024
• Week Of the year of 11/03/2024 (Monday) – 11, Week Year - Week 11 2024

Step 3: Reset the language and republish

• Change the language to the appropriate setting and save.
• Refresh the application to apply new language settings.
• Republish the Dashboard for Sunday – English (United States).

Sunday – English (United States)
• Week Of the year of 10/03/2024 (Sunday) – 11, Week Year - Week 11 2024
• Week Of the year of 11/03/2024 (Monday) – 11, Week Year - Week 11 2024

Related Links

• Working with Relative Date Filters in Bold BI
• Configuring Expression Columns in Bold BI

Please note that the images used in this guide are for illustrative purposes only and may not directly correspond to actual screens in Bold BI.