This topic describes the analysis configuration of a workbook.
Analysis configuration
On the Analysis tab of the workbook editing page, you can perform the effective configuration of the workbook. The configuration takes effect on the entire workbook page.
If you do not want to inherit the field format configurations of the dataset but want to use the native table configurations, you can disable the Field Alignment, Value Format for Measures, and Date Dimension Field Format configuration items.
Row or Row Shrink
By default, this feature is enabled. After data changes in a dataset are disabled, rows and columns are not automatically deleted. The format set on the original rows and columns is also retained.
Example:
If you select Enable, the filtering area is East China. The workbook rows and columns are automatically shrunk.
After Disable, the filter area is East China. The workbook rows and columns are not automatically shrunk, but the original number of rows is still displayed.
Field alignment
By default, the field alignment feature is enabled. After you disable the feature, the field alignment feature does not take effect.
For example, set the alignment of the order amount to left.
When field alignment is disabled, the alignment of the order amount becomes invalid and changes back to the default alignment.
Measure field value formatting
By default, this feature is enabled. After you disable this feature, the value formatting feature does not take effect.
For example, set the data display amount of the order amount to keep two decimal places.
After you turn off Value Format for Measure Fields, configure the order amount to retain 1 decimal place. In this case, it is still displayed as retain 2 decimal places.
Date Dimension Field Formatting
By default, it is turned on. After it is turned off, the date display format configured for the date dimension field does not take effect.
For example, set the date display format of the order date (day) to YYYY-MM-DD.
After the date dimension field formatting is disabled, the date display format of the order date (day) does not take effect and is displayed in the default format.
NULL Display Method
You can set the display mode of null values to "-" or "null".
hyperlink configuration
The workbook supports redirection. You can follow the steps shown in the figure to set redirection.
Redirects include intra-product redirects, on-page components, and external links. In-product redirects must be combined with global parameters.
When you click a field for which a hyperlink is configured in a workbook, you are redirected to the report that is linked to the field.
For more information, see Redirect.
Back button is supported. The back button setting is only for new window opening and current window opening.
You can click Total /Subtotal to redirect data.
