Count Comparison

Expected Effect

You can use the Internet Channel Statistics table to create the comparison chart of Viewer Quantity and Viewer Quantity with the First Channel Name Not Null, as shown in the following figure.

Implementation Method

Copy the indicator field Count, select Indicator Condition from the dropdown list of the Count1 field obtained by copying, add the filter condition that the first class channel names are not null, and click OK.

You can drag the dimension field, the Count field, and the Count1 field into the analysis area, and select Custom Chart in Chart Type.

Analysis Subject Creation

Create an analysis subject with the Internet Channel Statistics table in Public Data and select all fields by default, as shown in the following figure.

Component Adding

After entering the data editing page, click Component in the lower left corner to add a component, as shown in the following figure.

Counting the Viewer Quantity with the First Class Name Not Null

1. Click the drop-down icon of Count and select Copy to copy the field, as shown in the following figure.

2. Click the drop-down icon of the Count1 field obtained by copying, select Indicator Condition, add the filter condition that the first class channel names are not null, and click OK, as shown in the following figure.

Comparison Chart Creation

1. Drag the Statistics data, Count, and Count1 fields into the Dimension and Indicator bars separately, as shown in the following figure.

2. Click the drop-down icon of Statistics data, select Year-Month, rename the Count field Viewer Quantity, and rename the Count1 field Viewer Quantity with the First Class Name Not Null, as shown in the following figure.

3. Select Custom Chart in Chart Type, click the setting icon in the Color bar, and set the indicator colors, as shown in the following figure.

PC

For details, see section "Expected Effect."

Mobile Terminal

The following figure shows the effect on mobile terminals.