Displaying Data of the Current Year and the Last Year in a Chart

Expected Effect

In some cases, you may need to display data in different years in a chart. For example, you need to display the data of Contract Amount in 2013 and 2014 in a chart, as shown in the following figure.

Implementation Method

You can set an indicator condition for Contract Amount. The filter condition is that the contract signing time is in 2013.

You can copy the indicator Contract Amount and set an indicator condition for the indicator obtained by copying. The filter condition is that the contract signing time is in 2014.

You can drag the Contract Amount and Contract Amount1 indicators into the Indicator bar, drag Contract Signing Time into the Dimension bar, and select Contrast Bar Chart in Chart Type.

Data Preparation

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

2. Upload Contract Fact Table to the analysis subject. For details about the procedures, see Getting Started with FineBI.

Sample data: Contract Fact Table.xlsx

Indicator Condition Setting

1. Create a component and set an indicator condition for Contract Amount, as shown in the following figure. (The filter condition is that the contract signing time is in 2013.)

2. Copy the Contract Amount indicator, as shown in the following figure.

3. Set an indicator condition for the Contract Amount1 indicator field, as shown in the following figure. (The filter condition is that the contract signing time is in 2014.)

Chart Creation

1. Drag the Contract Signing Time field into Dimension, and drag Contract Amount and Contract Amount1 into Indicator, as shown in the following figure.

2. Set the display format of Contract Signing Time to Month, as shown in the following figure.

3. Select Contrast Bar Chart in Chart Type, hover the cursor over the fields, double-click the fields, and modify the field names, as shown in the following figure.

4. Drag Indicator Name in Cross-Table Field into the Color bar, and select Fresh and Colorful in Scheme, as shown in the following figure.

Dashboard Adding

Create a dashboard and add the component to the dashboard, as shown in the following figure.

Effect Display

For details, see section "Expected Effect."