Aggregate comparison

1. Overview

1.1 Expected effect

Use the "Product" table to calculate the comparison of "All Products" and "Filter Products", as shown in the figure below:

1.2 Solution

Copy the "Counter" to filter details. The filter condition is "Product_name is not in fixed value".

Drag the dimension field and the "Counter" and "Counter 1" fields into the analysis area and select "Custom Chart".

2.1 Create a dashboard

Click "Dashboard", select "New Dashboard", name it and select the location, and click "OK", as shown in the picture below:

2.2 Add component

Enter the dashboard editing interface, create the component, select "Product" and click "OK", as shown in the figure below:

2.3 Filter the products

Click the "Counter" drop down and select "Copy" to copy the "Counter", as shown in the figure below:

To perform detailed filtering for the "Counter 1", click "drop down > Detail Filtering", set the filtering condition to "Product_name is not in fixed value", and click "OK", as shown in the figure below:

2.4 Make the chart

Drag "CategoryID", "Counter", and "Counter1" into the dimension and indicator bar as shown below:

Change the indicator name, as shown in the following figure:

Select "Custom Chart", click the "color", and set the color of the "TargetName" , as shown in the figure below:

3. Preview effect

3.1 PC

See section 1.1 of this article for details.

3.2 Mobile

The effect of mobile terminal is as shown in the figure below: