Chart Toolbar

Version

Application Scenario

During template preview, you can sort data in a single chart, export a single chart, and display a single chart in full screen by the toolbar in the upper right corner of the chart, as shown in the following figure.

Function Description

You can select the needed tools and set whether to expand the tools or collapse them to the menu under Special Effect > Toolbar on the chart attribute panel, as shown in the following figure.

Note:

All tools except Sort are not supported on the DataAnalyst app and the HTML5 terminal currently.

The Sort tool is available only in column charts, bar charts, line charts, area charts, pie charts, multilayer pie charts, gauges, and radar charts. Data in multilayer pie charts is sorted by absolute values, while data in other charts is sorted by actual values.

Take column charts as an example.

1. Single Category with Single Series - Sorted by Actual Values

Data in the column chart (in which the category is Salesperson and the series is Sales_Volume) is sorted in ascending or descending order based on the sales volume, as shown in the following figure.

2. Single Category with Multiple Series - Sorted by the Sum of Series Values Within Each Category

Data in the column chart (in which the category is Product and the series are Sales_Volume and Inventory) is sorted in ascending or descending order based on the sum of Sales_Volume and Inventory, as shown in the following figure.

The ascending order is Milk ≤ Orange < Strawberry < Apple < Chocolate.

3. Multiple Categories - Sorted by the Sum of Series Values Within the Lowest-level Category

The lower-level category is Region, the upper-level category is Product, and the series are Sales_Volume and Inventory, as shown in the following figure.

The ascending order is New York < Boston. Within the category of New York, the order is Milk < Chocolate. Within the category of Boston, the order is Orange < Strawberry < Apple.

Note:

If you do not want to use the Sort button on the toolbar, you can use the chart.sortChart(sortType) API by adding Click or After Initialization events to a button widget. 

4. Notes

For bar charts and column charts, you can set Category to None and Series Name to Field Value to achieve the desired graphical effect, as shown in the following figure.

However, when Category is set to None, the Sort tool does not take effect in column charts and bar charts.

1. During chart export, you can only export the chart as a .png image whose name is export.png by default. The image name cannot be modified during the export and can be modified only after the export.

2. The chart exported is the chart displayed during the initial preview. If you have performed interactive operations such as legend sorting, the chart is exported as the image displaying the initial chart.

3. If you have set flashing animations for the chart, the chart will be exported as the image displaying the chart with animations turned off.

4. If dashed trendlines are set for exponential and polynomial fitting, such complex dashed line fitting may cause macOS crashes during chart export. To prevent such problems in these two fitting situations, dashed trendlines will be processed as solid lines during export.

5. To prevent server crashes, a certain limit is imposed on the volume of data that can be exported per chart.

The following figure shows the decision-making process of export.

In the decision-making system, you can choose System Management > Intelligent O&M > Load Management > Template Limit > General Limit and customize Data Export Volume Limit Per Chart. Data Export Volume Limit Per Chart (with a maximum limit of 20000) is enabled by default.

Note:

The number of data records refers to the number of graphics created on the frontend, rather than the number of data records in the dataset. For example, if a column chart has three categories with two series per category, six data records are exported.

If Data Export Volume Limit Per Chart is disabled, the chart is exported with the actual number of data records.

If the number of data records in the chart does not exceed the value of the enabled Data Export Volume Limit Per Chart, the chart is exported with the actual number of data records.

If the number of data records in the chart exceeds the value of the enabled Data Export Volume Limit Per Chart, the chart is exported with the set number of data records.

The setting item can be set only in General Limit, but cannot be set for selected charts separately in Limit Relaxation. In other words, this setting item will not be available when you set limits for selected charts separately in Limit Relaxation.

If you have customized Max Number of Data Records Exported Per Chart or disabled Data Export Volume Limit Per Chart, the chart will be exported as the image with a prompt message when a large amount of export data results in a V8 memory (1.6 GB) overflow.

6. In the designer of 11.0.2 and later versions, you can use the chart export API to export charts.

Note:

In FVS V3.3.0 and later versions, Display in Full Screen is supported on mobile terminals.

1. In the designer of versions earlier than 11.0.4, the background of the chart displayed in full screen is in white by default, which may seem obtrusive in a dark-themed template. Besides, the chart font cannot be adjusted automatically according to the chart size during the full-screen display, resulting in an incongruous visual effect, as shown in the following figure.

In the designer of 11.0.4 and later versions, the graphic and font will be adjusted automatically to fit the screen size during the full-screen display, and the logic of picking chart background colors has also been optimized.

The following table shows the logic of picking chart background colors.

The following figure shows the effect of displaying charts in full-screen after the designer is optimized.

2. In the designer of 11.0.2 and later versions, you can use special chart effect APIs to display charts in full screen.