Overview
Version
Report Server Version |
11.0 |
Application Scenario
The percentage donut gauge is a complete ring used to display the proportion of a certain item in the entire ring, including category, percentage, numerical values, and other indicators.
By using the percentage donut gauge, you can intuitively display the proportion of a certain item to the total, completion rate, achievement rate, and other data. The following figure shows the effect.
Chart Feature
Advantage: The percentage donut gauge can directly display the progress and completion of an indicator, mainly used for the presentation of progress or percentage.
Disadvantage: The percentage donut gauge displays limited information for the gauge only supports one dimension and is not suitable for displaying too many indicators.
Attribute Description
Type
After inserting the gauge in Cell Element or Floating Element, you can select Percentage Donut Gauge in the type setting option on the right attribute panel, as shown in the following figure.
Data
For details about basic data settings, see Chart Data.
Category Name: The corresponding category name of the percentage, which is displayed in the central position of the chute.
Pointer Value: A part of the numerator in the percentage calculation, which needs to be combined with the minimum value under the coordinate axis to form the numerator.
Target Value: A part of the denominator in the percentage calculation, which needs to be combined with the minimum value under the coordinate axis to form the denominator.
Note: Percentage calculation formula: (Pointer Value - Minimum Value)/(Target Value - Minimum Value), where the minimum value refers to the minimum value set for the coordinate axis. For details, see the following explanation of Style.
Style
For details about the style design of Percentage Donut Gauge, see Chart Style.
Series
The series settings of Percentage Donut Gauge under Style > Series are different from the basic style and are introduced separately:
1. Color
Default Color Style is Solid Color, and default Color Section is Category. The gauge displays colors according to Color Scheme for different categories.
When Color Style is set to Solid Color, and Color Section is set to Value, you need to set Scale/Color. The gauge displays the color of the gauge ring according to the scale value. Scale/Color is set to Auto by default, and the first three colors in the color scheme are taken to fit the interval colors of scale 0~1/3, 1/3~2/3, 2/3~1 respectively When you select Custom, you can set certain colors for values in a certain range.
When Gradient Color is selected for Color Style, each category of the gauge displays the same gradient effect.
2. Layout
Orientation: When a dataset has multiple categories, multiple gauges will be displayed on the front, and you can change the arrangement direction of these gauges.
Rotation Direction: You can select Clockwise or Counterclockwise.
Chassis Background: Controls the background color of the percentage ring area. The default color is gray.
Inner Chassis Background: Controls the background color of the chassis inside the ring. The default color is transparent.
Radius Setting: Controls the size of Percentage Donut Gauge, divided into automatic and fixed types.
Chute Proportion: Changes the proportion of the percentage donut area.
Label
The label settings of Percentage Donut Gauge under Style > Label are different from the basic style and are introduced separately:
When the font size of Percentage Label and Value Label is set to Auto, the font size will be automatically adjusted according to the size of the gauge.
When the color of Percentage Label is set to Auto, the color of Percentage Label will be displayed with the series color.
Value Label supports the display of Target Value, which is unchecked by default.
Axis
The axis settings of Percentage Donut Gauge under Style > Axis are different from the basic style and are introduced separately:
Custom Minimum Value: After selecting, the minimum value can be customized. It is deselected by default.
Minimum Value: This value is related to the numerator and denominator. The percentage calculation formula is: (Pointer Value - Minimum Value)/(Target Value - Minimum Value).
Note: Only the minimum value can be set, no maximum value.
Special Effect
For details about the Special Effect settings of the gauge, see Chart Special Effect.
Note: The Special Effect settings of Percentage Donut Gauge do not have Condition Display.
Example
Report Design
Data Preparation
Create a general report and create a data query named ds1. The SQL statement is:
select Product.Category_name, sum(Inventory_quantity) as Inventory from Product, Category
where Product.CategoryID = Category.CategoryID and Category_name != 'Beverages'
Chart Insertion
Merge required cells, select the merged cell, click the Insert Chart icon on the upper toolbar, select Percentage Donut Gauge, and click OK, as shown in the following figure.
Data Binding
Data Source of Percentage Donut Gauge is Dataset Data. Select ds1 for Dataset, Category Name for Category Name, Inventory for Pointer Value, Custom for Target Value, and set Target Value to 500, as shown in the following figure.
Style Setting
The gauge style can be set according to actual needs. You can set Title, Label, and Special Effect of the gauge.
1. Select Show Title and modify the text to Percentage Donut Gauge.
2. Select Use Label and select Category Name, Target Value, and Target Value for Value Label.
3. Deselect all the items under Special Effect > Toolbar > Content, as shown in the following figure.
Effect Display
PC
Save the template and click Pagination Preview. The figure in section "Application Scenario" shows the effect.
Mobile Terminal
The report can be previewed on both the DataAnalyst app and the HTML5 terminal. The following figure shows the effect.
