Table Widgets#

  • Condition: The display of the widget on the dashboard can be controlled by entering a condition that resolves to boolean True or False, for example in accordance with enabled features, services, and devices as in the Global Settings. The conditions are in the form of system macros. See for example the macros listed under the Links topic.

  • Data Source: Insights or Automate

Available menus and fields upon Data Source selection:

  • Insights

    • Resource options available in accordance with the Insights database

    • Fields: select fields from the resource to show in the table

    • Filters: filter field values from the table

    • Sorts: order the table (ascending, descending) by a selected field value

  • Automate: Model Type, Field Display Policy, Configuration Template

  • Table Options are available for both data sources.

    • Options to limit, show, hide or format table data and elements

    • Additional field display customization using Renderers for fields

  • Drilldown options: see Drilldown Options and Conditional Syntax

Besides standard menu options, a displayed table can also show additional menu options in accordance with enabled features such as:

  • Description (circled i icon)

  • Drilldown (lightning bolt)

  • Filter (funnel icon)

../../_images/dashboard-widget-table-menu.png

When a table widget is selected, it is also possible to switch to another widget format during the edit and design process. The Widget Type can be updated from the dropdown. Changes are reflected in real-time during the design of a widget or by using the widget’s Refresh icon.

Table widget example with Select Query and Partition By#

The example below shows a table widget configuration using an Insights resource, with Select Query and Partition By operations on fields, as well as a Filter on one of the fields. Consider the following Data Settings:

  • Resource: Cisco UCM User

  • Fields:

    • Site. Operation: Select Query

    • firstName. Operation: Partition By

    • firstName. Operation: Select Query

  • Filters

    • firstName. Operation: Regex (Case sensitive), Filter Value: ^Be

In this case, sites and user first names are selected where first names are used to

Table widget example with drilldown#

The example below shows a table widget configuration using an Insights resource, the resultant output display and also a drilldown result.

  • Configuration

    • Resource: Cisco CUC User

    ../../_images/table-widget-example-data-settings.png

    • Fields:

      • Playback volume (integer) is selected as a table column and similar values are grouped using Operation: Grouping Count

      • The user’s DisplayName is as a table column

    • Filters

      • DisplayName values containing regex CFT are excluded with a filter.

    • Sorts: no sorting is done on any column.

    ../../_images/table-widget-example-fields.png

    • Table Options

      • Series Limit: left at default All so no restriction on the number of values to show.

      • Over Time: For table data containing timestamp columns, this option can be enabled to expose a Use Over Time Day Pagination checkbox and an Interval dropdown so that table paging of data can be grouped and the paging range can be shown according to the selected interval.

      • Hide Count Column: enabled so an additional column containing the Count is not shown.

      • Hide Index Column: enabled so an additional first column containing an index value (row number) is not shown.

      • Selection Type: left at default so that a table entry selection selects an entire row.

      • Renderers: the Volume field configured so that its integer value has Suffix: %.

        ../../_images/table-widget-example-table-options.png

      Other Renderers options:

      The Format Type of a field on a table can also be modified if the Resource is Automate Analyze:

      • Default: field type remains as defined (default)

      • Text: field value rendered as text - allows for a default theme-related color mapping of text (Text Color Mapping) and table cell (Cell Color Mapping) to apply.

        Contact VOSS if a custom color mapping is required.

        The Font Size and Font Weight can also be set here if the Format Type of a field is Text.

      • Traffic Light: field value replaced by a “traffic light” colored icon - allows for default theme-related color mapping.

      • Tick Cross: field value replaced by a “cross” (X) colored icon - does not allow for color mapping.


  • Drilldown Options

    • Filter Options: set to IN so that a drilldown display contains DisplayName.

    • Drilldown Options: selecting a row - the choice will Link to Automate Resource specified as Type

    • Type: the Automate resource type: selected the related Automate resource: relation/Voicemail.

    • Drilldown Fields: the field to highlight in the table as a drilldown link: selected DisplayName.

../../_images/table-widget-example-drilldown.png

  • Output

    The table shows 2 columns:

    • Volume values with % suffix

    • DisplayName with drilldown link

    ../../_images/table-widget-example-output.png

  • Drilldown result

    Selecting a row link from the table shows the item as listed in the selected Drilldown Options.

    ../../_images/table-widget-example-output-drilldown.png