Adding Serial Numbers to a Table

1.1 Expected effect

For example, add a serial number to the "Contract ID", as shown in the following figure:

Note: The mobile terminal does not currently support the table ranking function.

1.2 Implementation ideas

Idea 1: The serial number does not need to participate in the calculation of the dashboard, and the serial number display function is used.

Idea 2: The serial number needs to participate in the calculation of the dashboard, which is implemented using a combination of functions ACC_SUM and AVG_AGG.

Note: The schedule does not support idea 2

This article mainly explains how to use functions.

The sample data is the "Contract fact sheet" under the "package".

2.1 Create a new dashboard

Create a new dashboard, name it and select the storage location, click "OK". Select "add component", select "Contract fact sheet" under "package", and click "OK", as shown in the following figure:

2.2 Add calculation indicators

Click "+", add a calculation indicator, name it "Serial Number", enter the formula: ACC_SUM(AVG_AGG(1),0), click "OK", as shown below:

Formula description:

Select "Group Table", drag "Contract ID" into the dimension column, and "Serial Number" into the indicator column. You can also filter out data with empty value, as shown in the following figure:

See section 1.1 of this article for details.