This topic describes how to add a measure.

Prerequisites

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

Procedure

  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
  4. In the Measures list, click the set icon next to a field and select Create Calculated Field (Measures).
    You can also click the Add Calculated Field (Measures) icon next to Measures.Add
  5. In the Edit Calculated Field (Mea.) dialog box, configure the calculated field.
    If you want to calculate the average order price within a specific period of time, you can add a field Average_order_price and configure a calculation function.Configure the calculated field
    Note When you edit an expression, take note of the following points:
    • After you enter a left bracket ([), a measure list appears for you to select the required measure.
    • The syntax of MySQL functions is used.
    • The brackets entered in the Expression field must be half-width brackets.
    • If the expression of the new field contains an aggregate function such as SUM, COUNT, AVG, COUNT DISTINCT, MAX, or MIN, the tag icon appears as the field identifier.
  6. After the configuration is completed, click OK.
  7. Click Save.
    Preview
    Note If aggregate functions, such as SUM, COUNT, AVG, COUNT DISTINCT, MAX, or MIN are used, the field is identified with the Aggregation icon. Such a field cannot be previewed in the dataset. After you create dashboards by using the dataset, this field can be previewed in the dashboards.