Count

Application Scenario

When using FineBI for data analysis, sometimes you need to count the number of clients, orders, branches, and so on, which are generally not directly recorded as fields in the data. This document introduces how to count the number.

For example, if you want to count the number of clients in different states, you can use the Count function. Drag the State field into Dimension and the Count field into Indicator respectively, and set the count dependence of the Count field to the Client Name field to obtain the number of clients in different states, as shown in the following figure.

Function Description

FineBI provides a Count field to count the number of records in a data table and allows you to change the conditions of count dependence to count the number of records in different dimensions.

Count (total number of rows) = COUNT_AGG(field)

Count (dependent on other dimension fields) = COUNTD_AGG(field)

Notes

The count function is not available in detail tables.

For details, see Distinct Count Scenarios, and Group Summary Count.

Example Data

Create an analysis subject and upload the example data, as shown in the following figure.

Component Creation

On the component editing page, a Count field will be displayed in the left to-be-analyzed area.

1. Drag the State field into Dimension and the Count field into Indicator respectively. The Count field is used to count the number of data records in each state, as shown in the following figure.

2. Add a calculation indicator field named State Count and enter the formula COUNT_AGG(State), which means counting the State field, as shown in the following figure.

Count Dependence Setting

The count dependence is set to the total number of rows in the data table by default. You can change the dependence conditions which are consistent with the dimension fields in the data table.

1. For example, if you set the Count Dependence to the Client Name field, the displayed data is the number of clients in each state, as shown in the following figure.

2. At this time, you need to modify the calculation indicator field by changing the formula to COUNTD_AGG(Client Name), which means the distinct count of Client Name, that is, displaying the number of clients in different States, as shown in the following figure.