Tube Gauge

Version

Application Scenario

The tube gauge looks like a test tube with scales (representing the measure) and progress lines (representing the progress).

You can use the tube gauge to directly display the progress or actual situation of an indicator, as shown in the following figure.

Chart Feature

Advantage: The tube gauge shows the progress or actual situation of multiple indicators intuitively, mainly used for showing the progress or proportion of an indicator.

Disadvantage: You cannot use the tube gauge to analyze data based on time categories, and individual charts cannot be compared for analysis.

Type

Select Tube Gauge as Type on the right attribute panel after the gauge inserting, as shown in the following figure.

Data

For details about basic data settings, see Data.

Category Name: The category name corresponding to 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 the tube gauge, see Chart Style.

Series

The series settings of the tube gauge under Style > Series are different from those of 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, and 2/3~1 respectively. When you select Custom as Scale/Color, you can set certain colors for values in certain ranges.

• When Gradient Color is selected for Color Style, each category of the gauge displays the same gradient effect.

2. Layout

• Sort Orientation: You can control the direction of Tube Gauge which can be set to Vertical or Horizontal. The default setting is Vertical.

• 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: You can control the background color of the tube scale bar, and the default color is light gray.

• Length: You can control the length of the tube gauge, divided into automatic and fixed types.

• Chute Width: You can control the width of the internal chute.

1. Label supports the change of Text Orientation.

If Sort Orientation under Style > Series of Tube Gauge is set to Horizontal, the Layout setting will be displayed under Style > Label of the tube gauge, and you can set Text Orientation of the label. When you select Vertical as Text Orientation, the text will be rotated +90°.

The following figure shows the effect.

2. Label supports Center display.

When Tube Gauge series is set to Vertical for Layout, Percentage Label and Value Label support Center display, as shown in the following figure.

The following figure shows the effect of Center of labels.

Axis

• Axis Label: You can control whether the axis labels are displayed or hidden.

• Character: You can set font, characters, color, italics, bold, and other properties.

• Custom Minimum Value: After selecting, you can customize the minimum value. This value is related to the numerator and denominator. The percentage calculation formula is: (Pointer Value - Minimum Value)/(Target Value - Minimum Value).

• Custom Main Unit: You can define the main unit by inputting the formula.

• Custom Minor Unit: You can define the minor unit and you can input formula.

• Main Tick: You can set the color of the main tick, and the default color is light gray.

• Minor Tick: You can set the color of the minor tick, and the default color is light gray.

• Axis Label Format: You can select Common (default value) or Custom.

Note:

Only the minimum value can be set, no maximum value.

Special Effect

For details about the Special Effect setting of the gauge, see Special Effects.

Note:

The Special Effect settings of Tube Gauge do not have Condition Display.

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 in ('Seafood', 'Deserts', 'Beverage')

group by Product.Category_name

Component Design

Merge required cells, select the merged cell, click the Insert Chart icon on the upper toolbar, select Tube Gauge, and click OK, as shown in the following figure.

Data Binding

Select Dataset Data as Data Source, ds1 as Dataset, Category_name as Category Name, kc as Pointer Value, Custom as Target Value, and set Target Value to 800, as shown in the following figure.

Style Setting

Set Style as needed. Here, Title is set, Label does not display Target Value, Sort Orientation in Series is set to Vertical, and Pointer of Series is set to white, 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.

For details, you can click to download the template Tube Gauge.cpt.