Overview
Background
You may need to compare the business performance of stores in different regions based on an order detail table.
How to quickly compare the average sales of stores in different regions?
After learning about certain regions with low sales, you may want to visually compare the corresponding unit prices and transaction volume to find the reasons for the low sales. How to calculate it?
Preview
You can use FineBI to quickly compare the sales, number of transactions, maximum transaction amount, median transaction amount, and average transaction amount of stores in different regions.
Procedures
Adding Data
Create a subject and add the built-in FineBI demo data table Store Sales Statistics.
Creating a Component
Compare the business performance of stores in different regions.
Drag Region and Residential area into Dimensions.
Comparing the Average Sales of Stores in Different Regions
What are the average sales of stores in the same region?
1. Add a calculation indicator Average store sales.
Formula | Description |
DEF_ADD(SUM_AGG(Sales),[Store name]) |
Calculate the sales of each store in every residential area. |
2. Drag Average store sales into Indicators, and select Average as Summary Mode.
Comparing the Number of Transactions of Stores in Different Regions
What are the average number of transactions for stores in the same region?
1. Add a calculation indicator Number of transactions.
Formula | Description |
DEF_ADD(COUNT_AGG(Sales date),[Store name]) |
In the detailed table, one piece of data represents one order. The number of transactions for each store can be got by counting the number of dates for each store. |
Comparing the Transaction Amount of Stores in Different Regions
1. Add calculation indicators:
Median transaction amount: comparing the median transaction amount of stores in different regions.
Maximum transaction amount: comparing the maximum transaction amount of stores in different regions.
Average transaction amount: comparing the average transaction amount of stores in different regions.
Formula | Description |
DEF_ADD(MEDIAN_AGG(Sales),[Store name]) |
Calculate the median transaction amount for each store. |
DEF_ADD(MAX_AGG(Sales),[Store name]) |
Calculate the maximum transaction amount for each store. |
DEF_ADD(AVG_AGG(Sales),[Store name]) |
Calculate the average transaction amount for each store. |
2. Drag the above three fields into Indicators and select Average as Summary Mode to display the business performance of a region.
Enabling Data Bar
Ticking Open Data Bar to make the comparison more intuitive.
Demonstration
Previous：Sales Gap Analysis
