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?
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.
Create a subject and add the built-in FineBI demo data table Store Sales Statistics.
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])
Specified dimension: Store name
Dimensions of analyzing areas: Region, Residential area
Filter condition: None
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.
DEF_ADD(COUNT_AGG(Sales date),[Store name])
Calculation: COUNT_AGG(Sales date)
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.
DEF_ADD(MEDIAN_AGG(Sales),[Store name])
Calculation: MEDIAN_AGG(Sales)
Calculate the median transaction amount for each store.
DEF_ADD(MAX_AGG(Sales),[Store name])
Calculation: MAX_AGG(Sales)
Calculate the maximum transaction amount for each store.
DEF_ADD(AVG_AGG(Sales),[Store name])
Calculation: AVG_AGG(Sales)
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.
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy