Radial Gauge
allows you measure the processing efficiency through the key performance indicator (KPI) like value and goal.
Radial Gauge
needs one actual value and/or one target value as minimum requirement to showcase.
Follow these steps to configure data to the Radial Gauge:
Data Source
button in the configuration panel.CREATE NEW
to launch a new connection from the connection type panel.DATA SOURCES
panel, click any one of the listed connection type buttons as shown in the following. Here, the Microsoft Excel
type is selected for demonstration.NEW DATA SOURCE
configuration panel, enter the name and choose the file path, and then click Preview & Connect.
Choose Table(s)
dialog and click Connect.
Save.
Properties
button in the configuration panel. The property pane opens.ASSIGN DATA
tab.Measures
and Dimensions
from the connected data source.Bind column by dragging any field from any section to Actual Value.
You can use the aggregate function
to change the actual values of the Radial Gauge.
The configured field names can be edited by using the Rename
option provided in the settings menu.
You can use the Filter
option to filter the data by specifying the filter condition. For more details, refer to the filter.
You can format the data to be displayed in the gauge by using the Format
option.
NOTE: Refer to this link for more details on Measure formatting.
Similarly, drag any field from any section to Target Value.
Drag any field from the Dimensions section to Series.
You can apply the Sort
and Filter
options for the Series field, if required from the settings
menu.
Sorting: You can customize the sorting behavior of dimension fields in the Radial Gauge widget. You can order them based on alphabet or value, data source (default), or field. Refer to this link for the detailed steps.
Filtering: You can use the “Filter” option to filter the data by specifying the filter condition. Refer to the detailed steps on applying measure filter from this page.
Drag any field from the Measures section to Minimum Value.
If the minimum value is configured, then this value will be the start range for the gauge widget.
Drag any field from the Measures section to Maximum Value.
If the maximum value is configured, it will act as the end range for the gauge widget.
Hidden columns are useful in cases where we don’t want the fields to take part in the visualization, but only to be used for linking, filtering and view data.
In the case of dimension fields we will having the following options only. In Date fields we will having all available types except sorting, relative date filter, settings and filters.
The primary use case of the hidden columns is linking. On configuring hidden columns, we can see below that the fields configured in hidden columns are listed in the linking section. On configuring the column in linking we can pass the corresponding column value in linking parameter.
Measure Based Example: If we wish to pass the number of Matches played as an URL parameter but do not want it to influence the visualization, we can configure the Matches in the hidden columns and incorporate them into the link.
Dimension Based Example: If we wish to pass the number of Team Name played as an URL parameter but do not want it to influence the visualization, we can configure the Team Name in the hidden columns and incorporate them into the link.
You can use hidden columns to filter data in the visualizations. Configure hidden columns and click the below filter icon.
Click the Custom button highlighted in the filter configuration dialog image below. It will list all the fields configured in the widget. Keep the field configured in the hidden column and remove the other fields, then click the Update button.
Now, we can see in the below image, the data is filtered based on the hidden column field instead of the actual column that we bound in the widget.
For more details about filtering the widget data, refer to the Filter Configuration documentation
You can view the data in the hidden columns in the underlying data view. This is useful for checking the data in more detail and can help you to identify any issues with the data.
NOTE: We don’t recommend to configure lower hierarchy data in hidden columns as we can see in the info icon in
Hidden Column
section denotes the same.
The below gauge displays the goals and Attempts On Target by each team without hidden columns.
If we configure lower hierarchy data(Player Name) in hidden columns, incorrect data is being displayed on the gauge.
You can format the Radial Gauge for better illustration of the view through the settings available in the Properties tab.
To format the Radial Gauge, follow the given steps:
Drag the Radial Gauge into the canvas and resize it to your required size.
Configure data into the Radial Gauge.
Focus the Radial Gauge and click the settings
icon.
This option allows you change the title
for the Radial Gauge.
Allows you provide subtitle
for the Radial Gauge.
Allows you provide description
about the Radial Gauge.
This option allows you to toggle the visibility of tooltip in the radial gauge.
Allows you to switch the widget view from the Half Circle type to Horse Shoe type or Full circular gauge or vice versa. The default type is Horse Shoe.
Note: If you change gauge type to
Full circle
, Color settings or Range settings categories will be hidden. In thePointer settings
category, Value Pointer, Target Pointer and Target Color properties will be hidden, and inScale settings
category, Show ticks, Show label and their dependent properties will be hidden. TheSize
option will be shown, which is used to customize the font size of the difference value.
You can change the type Full Circle
to show a full circular gauge. If you change, the gauge will render like this. For full circular type, the difference value will not be shown, only the percentage of the difference value will be shown.
For full circular gauge, some of the categories in property panel get hidden. If properties are applied before changing their type, which is not unnecessary to the full circular gauge, it will be reverted. Here, is the list of categories that do not support for full circular gauge.
In property panel, two more properties(Difference value color and size) shown in the Basic Settings
for full circular gauge.
Difference value color
You can apply color for difference value of the gauge.
Difference value size
This allows you to change size of difference value. The default value of this property is 15. You can change its size between 12 and 55.
Allows you to change the minimum value of the gauge. This option will be in a disabled state when you configure the column to start value in the data configuration panel.
Allows you to change the maximum value of the gauge. This option will be in a disabled state when you configure the column to end value in the data configuration panel.
You can enable the animation for gauge by setting this property to true. The default value of this property is false.
Allows you to hide or show the actual value in gauge by disabling or enabling the option. The default value of this property is true.
You can apply color for the Actual value displayed in the Radial Gauge. The default value is #666666.
If you uncheck the show actual value
property, its dependent property Value color will be hidden.
You can apply color for the Radial Gauge labels. The default value is #000000.
When you bind both actual and target values in gauge, this option will be shown. This allows you to hide or show the difference value of actual and target value with its percentage value. The default value of this property is true.
The Radial Gauge title color can be customized. The default value is #000000. This option will be disabled if the series is not configured in the Radial Gauge.
You can set the value label status to High is Good or Low is Good. The default setting is High is Good. This option is enabled only when you configured the actual value and target value.
From the provided color pickers, you can customize the color values for the High, Medium, and low colors.
Needle Pointer Color
You can change the color of the needle pointer.
Needle Pointer Height
You can increase or decrease the height of the needle by changing the Needle pointer height.
Target Pointer
You can change the pointer as line, triangle and inverted triangle.
Target Color
You change change the color for the target pointer
.
Needle Pointer Customization
This is used to display the actual value by coloring the region and set the needle pointer up to the actual value in Radial Gauge.
Allows you to set the color of the scale. The default value is #e0e0e0.
Allows you displays the ticks for gauge scales. The default value is false.
The interval between ticks will be auto-calculated.
If you check the Show Ticks
property, Ticks Position, Ticks Height and Ticks Width properties will be shown.
You can change the tick’s position either at inside or outside.
The default value is outside. This option is displayed only when the show ticks’ option is enabled.
Allows you to change the tick’s height. The minimum and maximum value of ticks’ height is 1 and 10 respectively and the default value is 5.
This option is displayed only when the Show Ticks option is enabled.
Allows you to change the tick’s width of the gauge. The minimum and maximum value of ticks’ width is 1 and 5 respectively and the default value is 1.
This option is displayed only when the Show Ticks option is enabled.
Allows you change the scale width of the gauge. The minimum and maximum values of gauge is 1 and 60 respectively and the default value is 40.
Allows you display the scale label of the gauge. The default value is true.
By enabling this property, the Scale label position property will be shown.
Allows you change the scale label position. The default value is outside.
This option will be disabled, if the gauge type is half circle and the Show Ticks is false.
You can enable or disable this option to display the scale with three different ranges. The default value is false.
NOTE: If you enable Show Range, the needle pointer will be set as a fixed pointer and the range pointer option will not be displayed in the property panel.
You can select a range to change its start, end, and color values.
NOTE: Currently, you can configure only three ranges.
Allows you to set the start value of the selected range. This option is displayed only if the Show Range is true.
Allows you to set the end value of the selected range. This option is displayed only if the Show Range is true.
Allows you to set the color of the selected range. This option is displayed only if the Show Range is true.
You can customize color for the Actual value displayed in the Radial Gauge by range color or default label color.
You can customize color for the Radial Gauge labels with the range color or default color.
You can enable linking and configure to navigate to a general URL with or without parameters. For more details, refer to the linking URLs.
This section allows you to customize the font size of radial gauge elements.
By default, the ‘Auto Font Size’ property is enabled. Auto font size property used to set font size based on dashboard viewing client machine resolution. If the user wants to customize or set the fixed font size, then the user needs to disable auto font size and set the required font size.
This option allows you to customize font size of scale labels. While Auto Font Size
option is enabled, font size will be applied based on resolution.
This option allows you to customize font size of Actual Value. While Auto Font Size
option is enabled, font size will be applied based on gauge size.
This option allows you to customize font size of Actual Value. While Auto Font Size
option is enabled, font size will be applied based on gauge size.
This option allows you to customize font size of Series Title. While Auto Font Size
option is enabled, font size will be applied based on resolution.
This allows you to define the radial gauge widget to ignore responding filter actions applied on other widgets in the dashboard.
The Radial Gauge widget can be set to act as a master widget by checking the Act as Master Widget
option. The Ignore Filter Actions
options enable the Radial gauge widget not to be filtered by any other master widgets during the interaction time in both preview and published modes.
The Act as Master Widget option will be enabled only when the Series section is configured.
The color of various properties in the Radial gauge can be customized from the corresponding properties section as explained in the formatting section. This will apply the same color for all records.
In case, if you have the requirement to highlight any data based on some conditions, you might be required to enable the advanced formatting option.
In the properties pane, enable the Advanced Setting
option provided under the formatting section.
Now, the Conditional Formatting dialog opens.
The Gradient
color format requires the Low
and High
color values. The data will be compared with this range and the matching color will be applied to the Range pointer
of the Gauge widget.
If any widget data is not present in the given limit, then the property panel’s range pointer color will be applied to the gauge widget.
After applying the gradient conditions
From the Conditional Formatting dialog, you can choose the based-on field
and the summary type
to apply the conditions.
NOTE: Any field from the configured data source can be selected as the
Based-on field.
You can add the required conditions instead of providing a simple range using the rule
based conditional formatting.
The based-on field and the summary type are customizable as in the gradient-conditional type. Also, you can choose the Value type
(value/percentage) from the drop-down .
NOTE: The percentage will be calculated by using the maximum value of the Based-on field.
You can customize more than one property using the rule-based conditional formatting.
NOTE: If the condition is matched, the colors will be applied accordingly for the corresponding properties. NOTE: NOTE: If the condition is not met, the property panel color will be applied. NOTE: NOTE: If more than one condition is matched, the last applied condition will be applied.
Conditional formatting condition:
After applying the conditional formatting:
You can also use the text-based matching for the configured series field as shown in the following screenshots.
You can choose from any one of the following types:
The conditional value for which you need to apply formatting.
Indicating whether the value is case sensitive
or not.
This allows you to handle the alignment of widget title to either left, center, or right.
This allows you to apply the text color
to the widget title.
On enabling Auto Font Size, the font size of the title will be adjusted automatically if the resolution of the screen varies.
Font Size
This allows you to apply the specified size of the font to the widget title if the Title Auto Font Size is disabled. Value can be between 10 and 44.
On enabling Auto Font Size, the font size of the subtitle will be adjusted automatically if the resolution of the screen varies.
Font Size
This allows you to apply the specified size of the font to the widget title if the Subtitle Auto Font Size is disabled. Value can be between 10 and 32.
On enabling Auto Padding, the padding of the widget container will be adjusted automatically if the size of the widget varies.
Padding
This allows you to customize the padding of the widget container if the Auto Padding is disabled. Value can be between 0 and 25.
This allows you to toggle the visibility of the border
surrounding the widget.
This allows you to apply the specified radius
to the widget corners if the Show Border is enabled. Value can be between 0 and 10.
This allows you to set the background image for the radial gauge widget.
This allows you to set the background color to the radial gauge widget.
This property allows you to specifies the transparency for the background color.
This allows you to toggle the visibility of the shadow
surrounding the widget.
This allows you to enable or disable the widget title
of the radial gauge.
This allows you to enable or disable the maximized mode
of the radial gauge widget. The visibility of the maximize icon in the widget header will be defined based on the setting in the viewer.
This allows you to enable or disable the CSV export
option for the radial gauge widget. Enabling this allows you to export the summarized data of the widget view to CSV format in the viewer.
This allows you to enable or disable the Excel export
option for the radial gauge widget. Enabling this allows you to export the summarized data of the widget view to (.xlsx or .xls)
format in the viewer.
This allows you to enable or disable the Image export
option for the radial gauge widget. Enabling this allows you to export the view of the widget to image format (.jpg), (.png), or (.bmp)
in the viewer.
This allows you to enable or disable the PDF export
option for the radial gauge widget. Enabling this allows you to export the view of the widget to pdf format in the viewer.
This allows you to enable or disable comment
for the dashboard widget. For more details, refer to this link.
This allows you to visualize the raw data associated with a widget at runtime.
To learn more about viewing the underlying widget data, refer to the view data documentation.
This allows you to pin the widget.
We hide the widget elements based on the size of the widget for better readability.
When the gauge is placed with below 150 pixels of height and width, labels and ticks will be hidden.