Overview
Version
| FineBI Version | Functional Change |
|---|---|
| 6.0 | - |
Application Scenario
Custom Chart allows you to freely combine charts of different types and create required complex charts by the high flexibility.
To reflect the values of different indicators in the same dimension, you need to draw charts one by one, which is troublesome. In this case, you can combine multiple indicators in one chart by Custom Chart, enhancing the chart information density and saving working time.
For example, to present information as comprehensively as possible during profit analysis, you can show the profit situation of each province by Column Chart, the fact that whether the profit target has been achieved by Point, the difference between the achieved profit and the target profit by Area, and the actual sales and sales target of each province by Line. This facilitates easy comparison, as shown in the following figure.
Implementation Method
When multiple indicator fields are dragged into the vertical axis in Custom Chart, the graphics can be set separately for each indicator, as shown in the following figure.
Note:
1. The graphic properties set in All apply to all indicators, and those set in the individual indicator only apply to that indicator.
2. For more details about graphic property settings, see Graphic Property.
Basic Requirement
| Chart Effect | Dimension Field | Indicator Field |
|---|---|---|
| Complex Chart | 1 | >=2 |
Chart Feature
1. Advantage
Rich information: Different indicators can be displayed together to provide decision-makers with more insights.
Space-saving: More report space is freed up to display other data.
2. Disadvantage
Data congestion: Too much data specified by multiple indicators in a combination chart makes the chart too congested.
Information redundancy: The more the indicators are, the less able the decision-makers are to grasp the main information conveyed by the data.
Example
Data Preparation
Log in to FineBI, click My Analysis, select a folder, and click New Subject, as shown in the following figure.
Click Local Excel and click Upload Data to upload the table data, as shown in the following figure.
Sample data: Business Goal Table.xlsx
After the data is uploaded, click OK, as shown in the following figure.
Click Save and Update to complete the data preparation, as shown in the following figure.
Component Creation
Click Component in the lower left corner.
Select Custom Chart in Chart Type.
Drag Province from the left to-be-analyzed area to the horizontal axis of the analysis area, and drag Profit, Profit Target, Target Difference, Sales, and Sales Target to the vertical axis, as shown in the figure below.
In Graphic Property, select corresponding shapes for the indicators, namely, Column Chart for Profit, Point for Profit Target, Area for Target Difference, and Line for Sales and Sales Target, as shown in the following figure.
Chart Beautification
Point Chart
Drag the Whether the Target Is Achieved field into the Color bar and Shape bar under Graphic Property > Profit Target, as shown in the following figure.
Click the color setting icon under Graphic Property > Profit Target, and set the color to red for No and green for Yes, as shown in the following figure.
Click the shape setting icon under Graphic Property > Profit Target, and select True or False in Shape Type, and select X for No and √ for Yes, as shown in the following figure.
Area Chart
Drag the field Target Difference from the left to-be-analyzed area into the Color bar under Graphic Property > Target Difference, as shown in the following figure.
Click the color setting icon under Graphic Property > Target Difference and select Heat 1 from the drop-down list of Gradient Solution to enhance the contrast effect, as shown in the following figure.
Line Chart
Click the color setting icon under Graphic Property > Sales, and select the orange as the color of the sales line in the setting pop-up box, as shown in the following figure.
Click the color setting icon under Graphic Property > Sales Target, and select the purple as the color of the sales target line in the setting pop-up box, as shown in the following figure.
Click the connection setting icon under Graphic Property > Sales Target, and set Line Type to Dashed Line in the setting pop-up box, as shown in the following figure.
Dashboard Creation
Click the Add Dashboard button at the bottom of the editing page in the analysis subject.
Drag the component into the dashboard on the dashboard editing page, as shown in the following figure.
Select Edit Title from the drop-down list, set Font Style to Custom, set the title to Complex Chart, and click OK.
Effect Display
PC
Mobile Terminal
