All Products
Search
Document Center

Quick BI:Analysis Configuration

Last Updated:Jan 20, 2025

This topic describes how to configure analysis settings within a workbook.

Analysis configuration

On the workbook editing page, under the analysis tab, you can configure settings that apply to the entire workbook.

image.png

To use the table's native configuration instead of inheriting the dataset's field format settings, you can disable the field alignment, measure field format expression, and date dimension field format configuration items.

Row and column collapse

This feature is enabled by default. If disabled, changes in the dataset will not automatically remove rows or columns, and the original formatting will be preserved.

For instance:

  • When enabled, if the filter area is East China, the workbook's rows and columns will automatically contract.

    去.gif

  • When disabled, if the filter area is East China, the workbook's rows and columns will not contract, displaying the original count.

    来.gif

Field alignment

This feature is enabled by default. If disabled, the field alignment settings in the data panel will not apply.

For example, you might set the alignment of the order amount to align left.

image.png

If field alignment is disabled, the alignment of the order amount will revert to the default setting.

image.png

Measure field format expression

Enabled by default. If disabled, the measure field format expression will not apply.

For instance, configure the order amount to display with two decimal places.

image.png

After disabling the measure field format expression, configuring the order amount to display with one decimal place will still show two decimal places.

image.png

Date dimension field format

Enabled by default. If disabled, the date dimension field's display format settings will not apply.

For example, set the order date (day) display format to YYYY-MM-DD.

image.png

If the date dimension field format is disabled, the order date (day) will display in the default format.

image.png

Chart jump configuration

The workbook supports jump functionality. Set up jumps by following the steps illustrated below.

image.png

Note

Jump methods include in-product, in-page widget, and external link jumps. In-product jumps require the use of a global parameter.

After setting up a jump, clicking on a target field in the workbook will navigate to the report associated with that field.

43.gif

For detailed settings, see the referenced document.

  • You can configure a return button for navigating back, which applies to both new window and current window openings.

    image.png

  • Support for enabling total/subtotal jump is provided. Once enabled, you can click on the total or subtotal to navigate.

    46.gif