Analysis Configuration

Configure analysis settings that control how a spreadsheet inherits dataset formatting, handles row and column resizing, and supports jump navigation.

AnalysisConfiguration

The Analysis tab in the spreadsheet editor provides settings that apply to the entire spreadsheet.

To use the spreadsheet's native formatting instead of inheriting settings from the dataset, turn off the field alignment, measure formatting, and date dimension formatting options.

Row and Column Shrinking

When turned off, rows and columns are not automatically removed when the dataset changes, and any formatting applied to the original rows and columns is preserved.

For example:

On: When the data is filtered by "East China", the spreadsheet rows and columns shrink automatically.
Off: When the data is filtered by "East China", the spreadsheet rows and columns do not shrink and continue to show the original number of rows.

Field Alignment

When turned off, field alignment settings configured in the data panel do not take effect.

For example, set the alignment for the order amount field to Left-align.

With field alignment turned off, the alignment setting for the order amount field is ignored and the default alignment is used.

Measure Formatting

You can set the display format for measure fields to Auto, None (displays the original value), Integer, 1 decimal place, 2 decimal places, Percentage, Percentage (1 decimal place), Percentage (2 decimal places), or Custom.

Note

For more information about configuring display formats in custom mode, see Customize data display format.

Date Dimension Formatting

When turned off, the date display format configured for date dimension fields does not take effect.

For example, set the date display format for the Order Date (Day) field to YYYY-MM-DD.

If date dimension formatting is turned off, the custom date display format for the Order Date (Day) field is ignored, and the field displays the default format instead.

Jump Configuration

You can configure jumps in spreadsheets to navigate to associated reports. Follow the steps shown in the image.

Note

Jump options include internal jump, Component on This Page, and external link. The internal jump option requires global parameters.

After a jump is configured, clicking a target field in the spreadsheet opens the associated report.

For detailed instructions, see Jump.

You can configure a back button. This setting applies only when the jump target is set to Open in new window or Open in current window.
Enable the Jump for totals/subtotals option to allow clicking totals and subtotals to trigger a jump.