Dimension Comparison Line Chart

Version

Application Scenario

• The multi-series line chart is a line chart that compares different indicators of the same dimension, while the dimension comparison line chart is a line chart that compares the same indicator of different dimensions.

• For example, use a dimension comparison line chart to compare the changes in monthly Payback Amount in      different years, as shown in the following figure.

Implementation Method

Create a partitioned line chart, drag the corresponding dimension into the Color bar in the Graphic Property area, and add filtering conditions as required.

Basic Requirement

Chart Feature

1. Advantage

• Trend comparison: The dimension comparison line chart is very suitable for clearly showing the trends of different dimensions.

• Multi-dimensional analysis: The dimension comparison line chart can simultaneously display data from multiple dimensions, facilitating cross-dimensional comparison and analysis.

2. Disadvantage

• Information overload: If too many lines (namely, too many dimensions or series) are displayed in a chart, the chart will become confusing and difficult to read.

• Detail loss: When focusing on the overall trend, you may overlook or fail to observe the specific values or anomalies of individual data points.

Data Preparation

1. Log in to FineBI, click My Analysis, select a folder, and click New Subject, as shown in the following figure.

2. Choose Local Excel > Upload Data, as shown in the following figure.

Sample data: KPI Indicator.xlsx

3. Click OK after the data is uploaded, as shown in the following figure.

4. Click Save and Update to complete the data creation, as shown in the following figure.

Creating a Component

1. Click Component in the lower left corner, as shown in the following figure.

2. Select Partitioned Line Chart in Chart Type.

3. Drag Contract Signing Time from the left to-be-analyzed area into the horizontal axis, and drag the Payback Amount into the vertical axis, as shown in the following figure.

4. Click the drop-down button of Contract Signing Time on the horizontal axis, and choose More Groups > Month, as shown in the following figure.

Filtering the Year

1. Drag Contract Signing Time from the left to-be-analyzed area into the Color bar in the Graphic Property area, as shown in the following figure.

2. Click the drop-down button of Contract Signing Time in the Color bar, and select Year, as shown in the following figure.

3. Continue to click the drop-down button of Contract Signing Time in the Color bar, select Filter. Add filtering conditions in the pop-up settings box, filter out the data in 2016 and 2017, and click OK, as shown in the following figure.

Dashboard Creation

1. Click the Add Dashboard button at the bottom of the editing page of the analysis subject.

2. Drag the component into the dashboard on the dashboard editing page, as shown in the following figure.

3. Select Edit Title from the drop-down list, and set Font Style to Custom. Set the title to Dimension Comparison Line Chart, and click OK, as shown in the following figure.

Effect Display

1. PC Terminal

2. Mobile Terminal