Calculate the mode

1. Overview

1.1 Expected effect

Calculate the mode of the user's consumption amount in the data, and evaluate sales of the product. In the order of this product, the most consumed amount is "1000", which is the mode, and there are 6 records. As shown below:

1.2 Implementation ideas

1) Calculate the number of records with the same amount. Group and summarize user orders by "Amount", and calculate count results after deduplication.

2) Arrange the number of records in descending order to get the mode.

2. Operation steps

Data used in the example: 124.Calculate the mode.xls

2.1 Add table

Add the basic table that requires the mode, and then the data can be processed in the self-service dataset.

1) Open "Data Preparation>Add Table>EXCEL Dataset". As shown below:

2) After adding the "Calculate the mode" table, click "OK". Complete the data upload. As shown below:

2.2 Create a new self-service dataset

Use the uploaded table to create a new self-service dataset.

Click "Add Table" under the "Package1" where the uploaded data is located, and click "Self-Service Dataset", as shown in the figure below:

2.3 Select field

Select fields in the table to be analyzed. Select the "Calculate the mode" table under "data list/Package1" and "Select All". As shown below:

2.4 Group Summary

Then analyze the selected fields.

1) Click "+" to add "Group Summary", as shown in the figure below:

2) Count the number of "Amount" records with different values, then group and summarize them by "Amount" (Amounts with the same value as a group), drag "User" to the Summary column, select "Distinct Count", and get the number of occurrences of different "Amount". As shown below:

The details of settings of Group Summary are shown in the following table:

2.5 Sort

Sort "User" in descending order, and the amount with the most records is the mode. Complete data processing.

1) Click "+" to perform "Sort", as shown in the figure below:

2) "Add a sorting column > User", sort the number of occurrences of different amounts obtained by Group Summary before. As shown below:

3) After sorting "User" in "descending order", complete the mode calculation, set the table name, and click "Save". As shown below:

4) After "Save", close the self-service dataset interface and click "Update Data" to view the data processing results. As shown below:

3. View the effect

To view the effect, please refer to section 1.1 of this article.