[Index]

Model: data/DashboardValueMapping

Manage dashboards and widgets

Full HTML Help

Overview

Administrators can manage dashboards via the Dashboards link on the Role Based Access dashboard.

Add or edit a dashboard

Automate provides several configuration options for working with dashboards.

• Name: Display name of the dashboard

• Description: Provide a description for the dashboard for the Dashboards list view.

• Hide Time Picker: By default, a time picker is available to filter dashboard data by start and end date. Any selected dates are reset when you log out. You can't specify a date in the future. Select the checkbox to hide the time picker.

  When the time picker is visible, widgets that support date filtering, including dynamic text widgets, update their content based on the selected date range.

• Hide Datasource Selector: This setting applies in the case where multiple instances of a dashboard data type is available. Not enabling the setting on a widget allows for selection of a data source instance and updates widget data based on the selected data source. Enabling the setting implies that the data source set on the widget is always used. Also used with "Insights Netflow" deployment option. For details, contact VOSS.

• Default Date Range: Select this option to open the date range picker and to set up a default date range for the dashboard. This range will then apply to widgets on the dashboard that use the date range picker.

  This default range applies to any widget that supports date-based filtering, including dynamic text widgets.

• Clone: Use the toolbar Clone icon to create a copy of the dashboard you're viewing. The cloned dashboard opens with the breadcrumb name appended with the text, [CLONE], and contains all the widgets of the source dashboard. The cloned dashboard name is the same as the original source dashboard name and can be modified as required.

  Note

  Dashboards with the same name can be available at different hierarchies. When such a dashboard is referenced, this first one found higher up from the administrator user's login hierarchy is selected.

• Refresh Dashboard: Used to update synced data on the dashboard to reflect any system data changes.

  Note

  Dashboard widgets that support refresh - such as charts, tables, counters, and dynamic text widgets - update their content when the dashboard is refreshed. A widget Refresh option displays only for widgets that can be refreshed (for example, dynamic text widgets).

• Lock: Used to lock the arrangement of widgets

• Dashboard Settings: Toggles (shows/hides) the dashboard name, description, and properties.

• Undo: Reverts the dashboard to the state of the last unlock. So, if the lock has been used even once on the dashboard, the unlock will always return the dashboard to the state it was after it was unlocked, even if multiple changes were done since. If the dashboard was never locked, Undo will lock it, forcing the user to unlock and create a snapshot point. This snapshot is the same as the uploaded dashboard. Note that the Undo functionality is currently under review.

• Export: Exports one or more instances. Refer to Bulk Export of Model Data. Exported dashboards can then be modified and imported at a required hierarchy via the Import menu. See also Dashboard export and scheduling

• Compact Grid: Automatically optimizes the arrangement of widgets on the dashboard, given their current size.

• Paste Widget: Pastes a widget you have selected, using the Copy Widget option on the widget menu, into the current dashboard. This allows you to copy widgets between dashboards.

• JSON Edit: Used for editing the dashboard data in JSON. For details, refer to Manage Items.

• Export Dashboard Data: Used to export the data available in the widgets of a dashboard: in CSV or MS Excel format. The exported data contain header rows labelled with the friendly names of the data field names and is then available for off-line use.

  Where multiple widgets are available on a dashboard, widget data is exported as either a CSV file or as a sheet in a MS Excel workbook. All the CSV files are archived in a .zip file. The export filenames follow the following convention:

  Export_<dashboard-name>_data_<all|displayed>_<timestamp>.<zip|xlsx>

  The available export options are determined by the Data Source of the widgets on the selected dashboard:

  • If there is a widget with Data Source as Automate present, only two export options will be available:

    • CSV - Displayed records
    • Excel - Displayed records

    This means that exported data will reflect the displayed records as per current Time Picker interval.

  • If all widgets have Data Source set to Automate Analyzed , Netflow or Assurance, there will be four export options:

    • CSV - Displayed records
    • CSV - All records
    • Excel - Displayed records
    • Excel - All records

    Selecting an "All records" option will include all available data, regardless of the selected Time Picker interval.

Add or edit widgets

When a dashboard is added or updated, widgets can be added, removed or edited.

To add a widget, click the Add Widget toolbar icon; then, on the design form, either select the widget from the toolbar or from the provided list of icons:

To edit a widget on a dashboard, select the dashboard from the list and choose Edit from the widget's menu. The widget menu provides a number of operations.

• Edit:

  • Use the Edit icon from the widget menu to edit the current widget. refer to the details below on available edit options.

• Clone:

  • Use the Clone icon from widget menu to clone the widget on the dashboard. The clone can then be edited as required.

• Delete:

  • Use the Delete icon from the widget menu to remove the widget from the dashboard.

• Copy Widget:

  • Use the Copy Widget icon to copy the current widget in order to paste it into a dashboard using the dashboard Paste Widget menu item.

• Export data:

  Where a widget offers data in a compatible format, the Export data on the widget menu allows for a MS-Excel or comma-separated value (CSV) export to a file, as in the Number Status example below:

  Status,Count
  Used-Utility,6
  Cooling,35
  Used,63
  Reserved,106
  Available,3850
  

  Note

  • For widgets where the Resource is an Insights resource, the option to export All Records is not available.
  • Dynamic text widgets support data export.
  • For 24.2 installations where the "Insights Netflow" deployment option was selected, widget Data Source dropdown fields also show Netflow. For details, contact VOSS.

Where a widget resource references data over a time period (such as transactions), the widget interface provides a time picker control to indicate and change the interval for the data shown on the widget.

The widget edit interface also provides a Use widget date range option so that the date range selected in the widget is applied and overrides the general dashboard date range setting.

Fields common to widgets

A number of fields are available across widget types. Details of some common field types are provided here.

• Custom Fields

  Custom or calculated fields can be defined and added to chart, table and text widgets.

  • For chart and table widgets, fields from the resource can be used as input for custom fields.
  • For text widgets, if Dynamic Content is enabled, a Data Source and Resource can be selected so that fields from this resource can be used as input for custom fields.
  • Note that these fields are calculated or created on the fly and are not stored.

  For number columns, numeric operations available on the input fields are:

  • Sum (column)
  • Average (column)
  • Max (column)
  • Min (column)
  • Add (A + B)
  • Subtract (A - B - C)
  • Multiply
  • Divide (A / B)
  • Format (complex SQL expression)

  Where an additional value can be selected for the operation (B, C, ...), a Parameters option is available to enter this value as Constant (arithmetic).

  In the example below, the milliseconds value of the maxDeskPickupWaitTime field divided by 1000 shows as seconds, using Divide (A / B) (with Constant of 1000).

  The example below illustrates the use of the Format (complex SQL expression) option. A duration field with Number as Value Type is used as a source to render a calculated field test:

  case
  when sum(case when duration >=0 then 1 else 0 end) = 0
  then 0
  else (sum(duration)::dec / sum(case when duration >= 0 then 1 else 0 end))::dec(10,3)
  end
  

  For string columns, string operations available on the input fields are:

  • Substring
  • Length
  • Regex Extract
  • Split Part
  • Prefix
  • Suffix
  • Concat
  • Replace
  • Format (complex SQL expression)

  In the example below, the Site name contains a prefix in capital letters (e.g. GLGC) that is extracted as a custom value Code using the Regex Extract operation with:

  • Pattern (regex_extratc): ([A-Z]+)(.*)
  • Group (regex_extract): 1

Related topics

• Chart Widgets
• Table Widgets
• Text widgets

Dashboard sync and refresh

A real-time sync process is running to maintain Automate and Insights databases in sync. After upgrade to release 24.2, dashboard management is available after 30 minutes, since the scheduled delta-sync process initially carries out a full sync and thereafter an incremental resource sync.

See: Insights Analytics in the Platform Guide.

Value mapping

The Value Mappings page defines a list of value mappings used when retrieving data for dashboard widgets. This allows a dashboard designer to substitute a stored value with a friendlier value that will be displayed to the user.

Value mappings allow for custom, alternative field values of resources to be displayed in chart widgets by using the Value Mapping field. This optional value is applied during the design of a widget and is typically used to present a more user-friendly field value in a chart widget, for example, to map the value of Cisco Codec Mappings originally: 0 to mapped: No Media Established.

The Value Mappings page (data model: data/DashboardValueMapping) is available to provider administrators and higher to add, delete and manage mappings. The model contains the default individual mapping value: NO MAPPING.

The design of a mapping allows for the selection of an evaluation operator to apply to the original value as an input condition and then to provide the replaced value in accordance with the evaluation operator test result.

Evaluation operators that can be applied to the original field values are:

• Regex
• Greater than
• Less than
• Range (with "Max" and "Min" parameters)
• Equals

Examples:

• If name: Cisco Codec Mappings Equals 0, then the mapping key is No Media Established.
• Microsoft 365 service plan mappings by matching Microsoft Entra ID values:
  • If string ID Regex (^SPB$) matches, then mapping key is Microsoft 365 Business Premium.
  • If string ID Regex (^O365_BUSINESS_PREMIUM$) matches, then mapping key is Microsoft 365 Business Standard.

Color mapping

The Color Mappings page defines a list of color mappings used to style data in dashboard widgets.

Automate provides options to allow for custom, alternative display colors and icons of Automate Analyze resources to be displayed in table widgets by modifying the Field Type of the resource and by creating instances of a dashboard color mapping. The mapping instance name is then selected in the Text Color Mapping and/or Cell Color Mapping dropdown lists under Table Options > Renderers when designing a table widget.

The Field Type of the field needs to be set to one of:

• Text
• Traffic Light: an icon

Refer to the Format Type of the field in the Table topic above.

This optional mapped value is applied during the design of a widget and is typically used to present a more user-friendly color or icon in a table widget, for example, to map a range of field values to have a specified color.

The design of a mapping allows for the selection of an evaluation operator to apply to the original value as an input condition and then to render the replaced color in accordance with the evaluation operator test result.

Evaluation operators that can be applied to the field values are:

• Regex : for fields with text or numeric values
• Greater than : for fields with numeric values
• Less than for fields with numeric values
• Range (with "Max" and "Min" parameters): for fields with numeric values

The Color Mappings page (data model: data/DashboardColorMapping) or Color Mappings link on the MVS-RoleManagement-Dashboard dashboard is available to provider administrators and higher to add, delete and manage mappings.

Examples:

1. If a Dashboard Color Mapping instance exists that matches the Regex .*00.*, then render the text as color: #ff0011.

   The Render section of a table widget has a field with Field Type set to "Text" and the Text Color Mapping dropdown selection is the created Dashboard Color Mapping.

   The table then displays the text the matching text accordingly, acording the selected Dashboard Color Mode (Light/Dark) of the theme that is applied - see: Create a Theme in the Business Admin Portal. The example below shows the Light theme applied.

2. If a Dashboard Color Mapping instance exists that maps the Regex value Ani, with the color: #fff200 and this instance is applied (selected under Chart Options) to a chart showing user first names that start with An, then names starting with Ani will be rendered in the chart mapping color (example below for Light theme):

Field Groupings

The Field Groupings page defines groups of similar data to facilitate common analysis and drill-down functions on a single dashboard.

Custom Reporter Resource fields

Automate provides an options to allow for the custom creation of calculated fields for a reporter resource. The customizations are added to a resource model called data/CustomResourceModel, where they can be grouped by a name and the calculated fields can be mapped to a selected resource in the reporter resources.

The screenshot below illustrates the creation of a custom field for to be used as the name_1 field as well as its selection in the design of a table widget.

Defines a list of value mappings used when retrieving data for dashboard widgets. This allows a dashboard designer to substitute a stored value with a friendlier value that will be displayed to the user. Note: Updating existing grouping configs has a refresh delay of 30 mins.

Model Details: data/DashboardValueMapping