This topic describes how to add a calculated field and a grouping field to the dimension list.

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 required dataset to go to the dataset edit page.
    You can also find the required dataset and click the modify icon in the Actions column.Edit
  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 icon
  5. In the Edit Calculated Field (Dim.) dialog box, configure the calculated field.
    In the Expression field, enter an expression for the calculated field. You can use functions to add dimensions to the expression, which is similar to MySQL.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 parameters are configured, click OK.
  7. Click Save and then Refresh Preview. The new calculated field appears in the dimension list.
    Preview data

Add a grouping field

On the dataset edit page, you can combine existing fields to form a new field based on your business requirements, and store the grouping information in the created grouping field.
Note
  • Grouping fields are supported only in Quick BI Enterprise Standard.
  • Classic workbooks do not support grouping fields. The classic workbook feature is only for public preview and will be deprecated soon. We recommend that you use the workbook 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 required dataset to go to the dataset edit page.
    You can also find the required dataset and click the modify icon in the Actions column.Edit
  4. Click the Add icon icon next to Dimensions and select Add Grouping Field.
    1
  5. In the Edit Grouping Field dialog box, configure grouping rules.
    2
  6. Click Save and then Refresh Preview. The new grouping field appears in the dimension list.
    Add a grouping field