This topic describes how to add a dimension to the dimension list. The dimension can be a calculated field or a grouping field.

Prerequisites

A dataset is created. For more information, see Create a dataset.

Add a calculated field

  1. Log on to the Quick BI console.
  2. Click the Workspace tab. In the left-side navigation pane, click Datasets.
  3. On the Datasets page, click the name of the target dataset to go to the dataset edit page.
    You can also find the target dataset and click the modify icon in the Actions column.Edit icon
  4. In the Dimensions list, click the set icon next to a field and select Create Calculated Field (Dimensions).
    You can also click the Add icon icon next to Dimensions and select Add Calculated Field (Dim.).Add a calculated field
  5. In the Edit Calculated Field (Dim.) dialog box, configure the calculated field.
    Enter an expression in the Expression field. The function syntax is similar to that of MySQL functions. You can add multiple dimension fields.Before configuration
    Note When you add a calculated field as a dimension, you cannot use aggregate functions such as SUM, AVG, COUNT, COUNT DISTINCT, MAX, and MIN in the expression.
  6. After the configuration is completed, click OK.
  7. Click Save and then Refresh Preview. The new calculated field is displayed in the dimension list.
    Preview data

Add a grouping field

On the dataset edit page, you can add a grouping field to classify the values of a field into multiple groups.
Note
  • This function is available only in Quick BI Enterprise Standard.
  • Classic workbooks do not support grouping fields. The classic workbooks feature is only for public preview. It will be deprecated soon. We recommend that you use the workbooks feature.
  1. Log on to the Quick BI console.
  2. Click the Workspace tab. In the left-side navigation pane, click Datasets.
  3. On the Datasets page, click the name of the target dataset to go to the dataset edit page.
    You can also find the target dataset and click the modify icon in the Actions column.Edit icon
  4. Click the Add icon icon next to Dimensions and select Add Grouping Field.
    1
  5. In the dialog box that appears, configure the grouping rules.
    2
  6. Click Save and then Refresh Preview. The new grouping field is displayed in the dimension list.
    Add a grouping field