Setting Date Group and Format

Application Scenario

After processing the data table, you need to set different grouping methods and display formats for date fields in charts.

For example, you can group date fields by Year, Year-Month, or Year-Month-Day, as shown in the following figure.

Function Description

You can click the drop-down icon in the analysis bar and modify the grouping method and time format of date fields.

Example data: Regional Data Analysis.xlsx

Setting Date Grouping

1. Enter the component editing page, drag the Contract Signing Time field into the Dimension bar, and drag the Count field into the Indicator bar, as shown in the following figure.

2. There are 17 ways to group dates: Year-Month-Day, Number of Weeks in Year, Year-Month, Year-Quarter, Year, Quarter, Month, Month-Day, Week Quantity, Week, Day, Hour, Minute, Second, Year-Month-Day-Hour, Year-Month-Day-Hour-Minute, and Year-Month-Day-Hour-Minute-Second. You can switch the date display format for any date grouping method.

Number of Weeks in Year and Week Quantity

• Number of Weeks in Year:

Week starts on Monday: The week containing the first Thursday of the year is defined as the first week of the year (which may span across years).

Week starts on Sunday: The week containing the first Wednesday of the year is regarded as the first week of the year (which may span across years).

• Week Quantity:

Week starts on Monday: A week runs from Monday to Sunday. If January 1 is not a Monday, the period from January 1 to the first Sunday of the month is defined as the first week (no cross-year calculation), and the following Monday marks the start of the second week.

Week starts on Sunday: A week runs from Sunday to Saturday. If January 1 is not a Sunday, the period from January 1 to the first Saturday of the month is regarded as the first week (no cross-year calculation), and the next Sunday marks the beginning of the second week.

Note:

For details about how to set the week start day, see General.

Take 2021/01/03 as an example:

When the week start day is set to Sunday on the platform:

When the week start day is set to Sunday on the platform:

Setting the Time Format

To set the time format of Contract Signing Time to yyyy-MM-dd, select the dimension field Contract Signing Time in the analysis area, click the drop-down icon, and select yyyy-MM-dd from the time format options, as shown in the following figure.

Time Format Description

The time format configurations are subject to the system language, and preset formats vary across different languages. You need to set the system language in advance if you have special formatting requirements. Otherwise, you can skip this step.

Multiple time formats for countries or regions are added in FineBI V7.0.6. You can configure the region in advance, as shown in the following figure.

Note:

1. These configurations only affect date and number formats, and do not impact the translation of other contents.

2. Language priority: personal settings > multilingual plugin settings > browser language > project language

The corresponding time formats for different countries or regions are as follows:

You can select Set Display Name or double-click the Contract Signing Time field to modify the name, as shown in the following figure.