In the visual query module of Intelligent Data Insight, fields are divided into two concepts: "dimension" and "measure". Text/time data is recognized as dimension fields by default, while numeric data is recognized as measure fields by default; in actual use, dimension and measure fields can also be converted to each other. This article introduces the specific capabilities of dimension field configuration.

2.1 Set date type #

Feature description: For date fields, setting the date type is supported. By default, data is displayed by "day". Both truncated dates (for example, selecting "month", measures from 2020-01-01 to 2020-01-30 will be aggregated and displayed under the 2020-01 dimension) and extracted dates (for example, selecting "week", 2020-01-01 is Wednesday and will be displayed as 3) are supported.
Default state: Displayed by "day". For example, 2020-01-01.
Scope of use: Date-type fields. The system identifies fields that meet the criteria as date fields based on the field expression.
Operation steps:

• Click the field
• Select "Date type"
• Select the required date type to configure

Date types:

• Year: Supports custom fiscal years. For example: When the year is set from April to March of the following year, 2013-07-01 will be displayed as 2013.
  
• Year-month-day (day): For example: 2020-01-01
• Year-bimonth: Supports aggregation by bimonth. For example, 2013-11-15 will be displayed as 2013-11/12
• Year-biweek: Supports aggregation by biweek, and the start date of the biweek can be adjusted as needed (Monday to Sunday, Tuesday to Monday, and so on). For example, 2013-11-26 will be displayed as 2013-W47/48. Click Advanced Settings to configure the aggregation method for the starting week of the biweek.

The week containing the first Thursday of each year is considered the first week of that year (for example, if January 1 is a Friday, the following week is the first week; if January 1 is a Thursday, the week containing January 1 is the first week).

• Year-week (custom week): Supports custom weeks, presented in the format of year-week number. For example: 2021-08-01 will be displayed as 2021-30 (07/26-08/01)
• Custom week: Select as needed from Monday to Sunday, Tuesday to Monday, Wednesday to Tuesday, and so on, or Sunday to Saturday
  
• Month: That is, from the 1st to the last day of each month
• Week: Date type where the weekday is extracted. For example, 2020-01-01 is Wednesday, displayed as 3.

2.2 Date display format #

Function description: When selecting a date, the display format of the date data can be customized as needed.
Scope of use: Date-type fields
Default state: By default, displayed in the YYYY-MM-DD format
Operation steps:

• Click the field
• Select "Date display format"
• Select the required date format

2.3 Date completion #

Function description: When there is no data for certain days in the selected date range, the date completion function can be used to display the missing dates
Scope of use: Date-type fields. The product will identify fields that meet the criteria as date fields based on the field expression
Default state: Off, that is, dates without data are not displayed by default
Operation steps: In the following charts

• Click the field, select "Date completion" - "Show", and dates without data will also be displayed.