Stack column chart shows total and part

1. Overview

1.1 Expected effects

Stacked column chart can show the data accumulation of each layer, and the sum represents the height of the whole column.

However, sometimes users need a column to display both the total collection amount and the collection amount of a region (for example, Jiangsu Province) (both calculated from 0 and do not accumulate). Here the collection amount of Jiangsu Province in the total collection amount is displayed, as shown in the following figure:

1.2 Implementation ideas

1) Copy the "sales volume" and filter "sales volume" of "Jiangsu" Province.

2) Calculate the difference: add a calculation field,SUM_AGG(${sales volume})-SUM_AGG(${Jiangsu volume}).

3) Display using stacked columns.

2. Operation steps

Sample data:

316.AC-sales.xlsx

2.1 Calculate sales volume of Jiangsu

Create a dashboard and add a new component, select the "AC-sales" dataset, and copy the "sales volume", as shown in the following figure:

Modify the copied field name as "Jiangsu volume", and set the "Detail Filtering" condition as follows: "area" in "Fixed value" "Jiangsu", as shown in the following figure:

2.2 Calculate difference

Calculate the difference between the collection amount of all provinces and that of Jiangsu Province.

Create a calculation indicator, name it "difference" and enter the formula: SUM_AGG(${sales volume})-SUM_AGG(${Jiangsu volume}), click "OK", as shown in the figure below:

Formula description:

2.3 Display by charts

Select "stacked column chart", darg the field to the analysis area, as shown in the following figure:

Filter the top N sales channels, as shown in the following figure:

Drag "Jiangsu volume" to the "tag" under "Jiangsu volume", drag "difference" to the "tag" under "difference", as shown in the following figure:

2.4 View the effects

2.4.1 PC terminal

See more details in section 1.1 in this file.

2.4.2 Mobile terminal