Overview
Background
It is easy to calculate the purchase frequency of each client with an order detail table.
However, how to calculate the number of clients who have purchased products for many times? You can calculate the distribution of their purchase frequency to know the regular pattern of clients' purchase frequency within a certain time.
Preview
Clients' purchase frequency is normally distributed, with the maximum number of clients purchasing five to seven times.
Procedures
Adding Data
Sample data:
Create a subject and upload the sample data.
Configuring a Component
To calculate the number of clients in different purchase frequency, you need to set Purchase Frequency as a dimension and Number of Client as an indicator.
Dimension - Purchase FrequencyAdd a calculation field and calculate the purchase frequency with a DEF function.
Formula: DEF(COUNTD_AGG(Order ID),[Client Name])
Formula | Description |
COUNTD_AGG(Order ID) | Count the number of orders without duplicate values. |
DEF(COUNTD_AGG(Order ID),[Client Name]) | Group the number of orders without duplicate values according to Client Name and calculate the purchase frequency of each client. |
To calculate the number of clients in different purchase frequencies, you need to set Purchase Frequency as a dimension and Number of Client as an indicator.
Transform Purchase Frequency into a dimension field.
Create a calculation field Number of Clients and calculate the number of clients with a function.
Select Partitioned Column Chart and drag Purchase Frequency into Dimensions and Number of Clients into Indicators. Select Merge same items as a group as the group way of Purchase Frequency.
Demonstration
See the section "Preview".
