Overview
Version
Report Server Version |
11.0 |
Application Scenario
The percentage scale bar gauge is an incomplete circle that displays the proportion of a certain item, including category, percentage, and numerical values and other indicator data.
By using the percentage scale bar gauge, you can intuitively display the rate of achievement by presenting the ratio of achievement data to the target, sales completion rate and product qualification rate as well as the percentage of progress.
The difference between the percentage scale gauge and the percentage donut gauge is that the ring of the gauge adopts a scale bar style. The following figure shows the effect.
Chart Feature
Advantage: The percentage scale bar gauge can be used to show the range and size of the data as well as the progress and completion situation of an indicator mainly used for the progress or percentage presentation.
Disadvantage: The percentage scale bar gauge cannot visually display data trend changes and is not suitable for multiple data comparison analysis.
Attribute Description
Type
After inserting the gauge in Cell Element or Floating Element, you can select Percentage Scale Bar 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.
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 explanation of Style.
Style
For details about the style design of Percentage Scale Bar Gauge, see Chart Style.
Series
The series settings of Percentage Scale Bar 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 of Color Scheme respectively correspond to the scale intervals of 0~1/3, 1/3~2/3, and 2/3~1.
When Custom is selected, you can set a specific color for a certain range of values.
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.
Pointer: The pointer refers to the color of the ring icon at the frontend of the progress bar, which is transparent by default.
Scale Bar: The background color of the scale bar of the ring can be set, and the default color is light gray.
Radius Setting: Controls the size of Percentage Scale Bar Gauge, divided into automatic and fixed types.
Chute Proportion: Changes the proportion of the percentage scale bar area.
Label
The label settings of Percentage Scale Bar 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 Labels support displaying Target Value, which is not selected by default.
Axis
The axis settings of Percentage Scale Bar 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 unchecked 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 Percentage Scale Bar Gauge, see Chart Special Effect.
Note: The Special Effects settings of Percentage Scale Bar 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 Category_name, SUM(Inventory_quantity) as Inventory from Product, Category
where Product.CategoryID = Category.CategoryID and Product.Category_name != 'Beverages'
Chart Insertion
Merge required cells, select the merged cell, click the Insert Chart icon on the upper toolbar, select Percentage Scale Bar Gauge, and click OK, as shown in the following figure.
Data Binding
Data Source of Percentage Scale Bar 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 Scale Bar.
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 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.
