KPI Widgets

KPI Widgets

ManageEngine Analytics Plus offers a widget-based model for adding single numbered widgets and chart type widgets within dashboards. These are called KPI Widgets.

Analytics Plus offers 2 types of KPI widgets:

Single number widgets

Single number widgets are used to display a single numeric value as formatted text. They are useful to highlight key metrics in a dashboard. The key metrics can also be accompanied by comparison indicators to highlight the trend. Analytics Plus currently offers six types of single number widgets with or without the comparison indicator.

 

Adding a single number widget

You can add a new KPI widget by clicking the Widget option from the dashboard's toolbar in the Edit Design mode. The KPI Widget Editor will appear.

The Data tab

The Data tab provides options to add a primary key performance indicator and secondary values to support it. You can choose the type of widget and the required columns from this section.

  1. Select the required widget type from the Select Widget section. You can view each template with sample data by clicking the Sample link that appears on mouseover.

  2. Select the required columns from the Select Columns section. Analytics Plus will display a single value based on the columns and functions selected in this section.
    • In the Data Column drop-down, select the data column that you want to display in the widget along with the required mathematical function.
    • In the Group By drop-down, select the column by which the previously selected data column value should be grouped.

      Based on the selected widget layout, additional information may be required to create the KPI widget.

  3. The following options are available under the Show Value As section:
    • The Primary Value drop-down allows you to apply a summary function over the data column. The computed value will be displayed as the main value (primary value) of the widget.
    • The Secondary Value section allows you to apply an additional function over the data column and display it along with the primary function.

      For instance, if your primary metric is total sales, you can also choose to display the maximum and minimum sales values along with the main value by selecting the appropriate template. A maximum of two secondary values can be displayed with the primary value, based on the selected widget template.

  4. The following options are available under the Comparison Indicator section:
    • Compare: This option allows you to specify the values for comparison. You can either select an aggregate of your data column or a constant value.

      In the above example, we are comparing the Latest and Previous to compare the growth between the current and previous months.

Analytics Plus also allows you to format the value displayed using the Format link. To know how to format a column, refer here.

The Filters tab

The Filters tab allows you to filter the data as required by dropping the columns into the filters area and selecting the appropriate values. The filtering functionality in KPI widgets works in the same manner as it does in charts.

The Settings tab

The Settings tab provides several options to format the widget by customizing the label name, font, and comparison indicator.

The following are the available options:

Styling

You can apply widget themes to customize the widget's background.

  • Themes: Select the required theme for the widget's background from this section. There are five preset options available.
  • Custom: This section allows you to customize the widget's theme and font color.

Primary Value

This section provides options to customize the displayed primary value. You can modify the primary value's label and the primary value being displayed, as well as the text style used for both.

Secondary Values

This section provides options to customize the secondary value. You can modify the secondary value's label and the secondary value being displayed, as well as the text style used for both.

Parametrized Format

You can also customize labels for primary and secondary values using a parameterized format, which allows you to display dynamic values in your KPI widget. The following are the supported formats for specifying a dynamic label:

  • ${ColumnName}.LABEL: This is the default label generated based on the selected column and the corresponding operations applied over the column in the Data tab.
  • ${ColumnName}.VALUE: This displays the corresponding value of the specified operations over the selected column.
  • ${OPERATION}: This denotes the mathematical operation specified in the Show Value As section of the Data tab.
  • ${PERCENTAGE}: This displays the value as a percentage, and is only applicable to full dial chart widgets.

Comparison Indicator

You can configure the indicator icons and the color of the displayed metric from this section. These indicators will be displayed beside the primary metric value. The following options are available:

  • Icon: This section allows you to choose the type of icon used and its color.
  • Value: This section allows you to customize the primary value's font color based on the indicator's value.

The following image shows a sample dashboard with KPI widgets:

Chart type widgets

The chart type widgets in Analytics Plus enable you to highlight your data metric using chart visuals. These are different from actual charts and are focused on displaying a single value. Analytics Plus currently supports three types of chart widgets.

  • Bullet Chart
  • Dial Chart
  • Full Dial Chart

Bullet Chart

A Bullet Chart is best suited to highlight a metric and compare it with a target value. You can also specify qualitative ranges of performance, such as poor, satisfactory, and good. The qualitative ranges are displayed as varying intensities of a single hue.

The image below displays a bullet widget in Analytics Plus, with the various components of a bullet chart highlighted in red.

Dial Charts

A Dial chart is used to indicate the current value of a metric in a given range. Although similar to a bullet chart, it displays the values in the form of a semi-dial. You can also specify qualitative ranges of performance using dial charts.

The following types of dial charts are available in Analytics Plus:

Simple: This is a basic dial chart which consists of chart range, target, key metric plot, and its value.

Speedometer: The speedometer is a dial chart with an indicator that marks the position of the key metric value in a given range. By default, the qualitative ranges in the speedometer don't follow the same hues. The red, yellow, and green colors prove beneficial in indicating your performance range.

Conditional: In conditional dial charts, the color of the key metric plot is based on the specified conditions. This helps in categorizing key metric values into different qualitative buckets.

Analytics Plus allows you to specify a default color for the key metric plot, and different colors when a condition is met. For instance, to measure the progress of sales over a month, you can assign various colors for instances when the sales reaches 25% and 50% of the overall sales. The default color will be applied when the sales value is above 50%.

You can choose the required dial chart from the Settings tab in the KPI editor. Click here to learn more.

Full Dial Charts

A full Dial Chart is a gauge chart with a full ring. This is similar to a dial chart, however, the maximum range value will be configured as the value of the full ring.

You can customize the full dial chart by plotting the key metrics to overlap the dial, outside the dial, or inside the dial.

You can choose the required full dial chart from the Settings tab in the KPI editor. Click here to learn more.

Adding Chart Type Widgets

To add a chart type KPI widget, open the required dashboard in the Edit Design mode, and click the Widget button from the toolbar. The KPI Widget Editor screen will appear.

Data tab

  1. Select the required chart type widget from the Select Widget section of the Data tab.

  2. Select the required columns from the Select Columns section.
    • Data Column: Select the data column you wish to display in the widget along with the required mathematical function.
    • Group By: Specify the column by which the previously selected data column value should be grouped.

    Note: In cases where the columns in the Data Column and the Group By fields are from different tables, you can view and modify the way the tables are joined by clicking the View paths used in the widget icon on the top right corner of the widget editor. You can modify the lookup columns and configure the lookup path used from the popup that appears. Click here to learn more.

  3. The Metrics section provides the following options to customize your widget's data:
    • Value: This drop-down allows you to apply an advanced summary function such as sum, average, etc., over the selected Data column.
      • You can also specify the primary value as a percentage of the data column. Click on the % button to mention the percentage. This multiplies the value of the mentioned factor.
    • Target: This section allows you to select a target. You can either apply summary functions or specify a constant value in this field.
    • Maximum Range: You can specify a maximum range for the widget using this section. You can either choose to apply summary functions or specify a constant value in this field.

Analytics Plus provides various formatting options for KPI Widgets. To customize your widget, click the Format link next to each component under the Select Metrics section, and a popup appears with several formatting options. These options are similar to the formatting options available in reports. Click here to know more about the formatting options.

Filters tab

The Filters tab allows you to filter the data as required by dropping the columns into the filters area and selecting the appropriate values. The filtering functionality in KPI widgets works in the same manner as it does in charts.

Settings tab

The Settings tab provides several options to format various aspects of the chart type widget.

Styling

  • You can customize the dial chart and full dial chart's appearance using this section.

    • For dial charts, you can choose from a simple, speedometer or a conditional dial chart. Click here to learn more about these options.

    • For full dial charts, you can choose from overlapping, inner or an outer full dial chart.

  • You can also apply widget themes to customize the background of the widget.
    • Themes: Select the required theme for the widget's background from this section. There are five preset options available.
    • Custom: This section allows you to customize the widget's theme and font color.
  • Specify the name and font style of the label using the Name and Text Style fields.

Widget

The following options are available under the Widget section of the Settings tab:

  • Value: This option allows you to modify the font style of the value being displayed.
  • Data Column: You can change the color and bandwidth of the data displayed in the chart type widget from this section. A maximum bandwidth of 200px is allowed.
  • Target Marker: This section allows you to customize the color, size, and type of target line used in the chart type widget.
  • Needle: You can modify the type, size, and color of the needle used in dial chart widgets.
  • Orientation: Specify if the bullet chart widget will be horizontally or vertically oriented from this section.

  • Show Min Max Label: Select this checkbox to display the minimum and maximum values.
  • Show Data Label: Select this checkbox to display the data value within the chart type widget.
  • Show Target Label: Select this checkbox to display the target value beside the target line within the bullet and dial chart widgets.

Ranges are hues that are displayed in the background of a chart type widget to highlight the primary value. Analytics Plus allows you to specify different ranges to visually categorize primary values. For instance, you can use different hues to categorize performance as poor, satisfactory, and good. The color and bandwidth of these ranges can be customized from the Ranges section in the Settings tab

The following options are available under the Ranges section:

  • Maximum Range: Use this section to specify color and bandwidth for the maximum range. A maximum bandwidth of 200px is allowed.
  • Ranges: Ranges can be set as a percentage or as a value, by selecting the corresponding option from the drop-down in this section. A maximum of five ranges can be configured.

On specifying the required configurations, click Apply to create the chart type widget. The following is a sample widget that will be added to your dashboard.

Creating Widgets with Images

Analytics Plus allows you to create widgets with images (widgets that have images as part of them). Using images in the widgets helps the viewer to understand information and differentiate between types.

Analytics Plus auto adjusts the position of the image based on the text length. You can also customize the position of the images as needed.

To create widgets with images, ‌
1. You need to have a column in your data table with the image address.
2. The image size should not exceed 200 KB.
3. The Display as option under the Format Column menu must be set to Image.



The below presentation shows how to create widgets with images.

Share this post : FacebookTwitter