Add a Dashboard Widget

You can place widgets on the dashboard to display the status of devices you are monitoring. They can also be used as graphical elements in dashboard layout. Available widgets include shapes, images, tables, lines, gauges, and charts.
uim851
You can place widgets on the dashboard to display the status of devices you are monitoring. They can also be used as graphical elements in dashboard layout. Available widgets include shapes, images, tables, lines, gauges, and charts.
The tutorial
Creating Dashboard Widgets
in How To Videos shows how to place widgets on the dashboard canvas, move them, size them, and organize them into a logical display.
After you add a widget, assign it a data source. You can also set properties for widgets, change their appearance, and connect them with lines.
You must be in edit mode to work with widgets. Switch to Live View mode to view widgets with current data values.
Contents
Add a Shape
Add a circle or rectangle to display information about the dashboard. The shape does not display the value of its data source, but the color of the shape reflects that value. After assigning a data source to the shape, you can create a color map so that the color reflects different thresholds.
The circle and rectangle widgets support the following data sources:
  • Alarm
  • Dashboard
  • Metric
  • Probe
  • QoS
  • SLA
  • SQL
Follow these steps:
  1. Click the
    Widgets
    ( Widgets.PNG ) icon in the right pane.
  2. Click
    General
    to expand the menu.
  3. Drag a circle or rectangle onto the canvas.
You can now assign a data source for the shape, then set any properties that you wish to change.
You can also use shaped widgets as graphical elements within the dashboard, for instance, to group other widgets within a theme. You are not required to assign data sources to a shape widget. To control the layering order of widgets on the dashboard, click the
Move to front
and
Move to back
buttons on the toolbar at the top of the window.
Add a Line
Add a line to indicate a relationship between widgets or as a graphical element within a dashboard. Lines can also represent tunnels or other links between network elements and reflect operating values.
You can easily connect two widgets by drawing an anchored line between points on the widgets. When you move the widgets, the anchored lines move with the widgets.
You can also create a standalone line (not anchored to widgets) by dragging a line widget onto the canvas, adjusting its length and placement.
Lines support the following data sources:
  • Alarm
  • Dashboard
  • Metric
  • QoS
  • SQL
The line does not display the value of the data source, but the color of the line reflects the value. After assigning a data source to the line, you can create a color map so that the color changes for different thresholds. Select the line on the canvas and go to
Color
under the
Widget Properties
( DashboardProperties.png ) tab to set colors for the line.
You can also play sounds for different data values.
Follow these steps:
  1. Click the
    Widgets
    ( Widgets.PNG ) icon in the right pane.
  2. Click
    General
    to expand the menu.
  3. Drag a line widget onto the canvas.
  4. Click the
    Line Endpoints
    ( LineEndpoints.PNG ) icon on the toolbar at the top of the dashboard to turn on line endpoints.
  5. Drag an endpoint of the line to size it or to the widget where you want the line to connect. Anchor points for the widget appear when the endpoint of the line nears the widget.
    To move a line around the canvas, drag its end points or change the
    Points
    settings under
    Line
    in the
    Widget Properties
    ( DashboardProperties.png ) tab to define the coordinates of the endpoint. You can also multiselect the line and other types of widgets and move them as a group.
  6. Click the line endpoints icons on the toolbar to turn off line anchor points.
  7. Click the line to select it.
  8. Click the
    Widget Properties
    ( DashboardProperties.png ) tab.
  9. Click
    Line
    to expand the menu.
  10. Set the properties for the line:
    • Thickness
      Sets the thickness of the line.
    • Points
      Defines the coordinates for the endpoints (or mid-points) of the line.
    • x, y
      The
      x
      fields set the horizontal position of the endpoints, and the
      y
      fields set the vertical position of the endpoints. Enter the x and y position for each endpoint or mid-point and click on the canvas to move the endpoints.
    • Widget
      Names the widget if the line is connected to a widget anchor point.
    • Anchor
      Specifies the location of the anchor point on the widget where the line connects.
      If the Widget and Anchor information does not appear when creating the line, clear the line and then reselect it.
  11. (Optional) Add one or more mid-line points to the line:
    1. Click the line endpoints icon on the toolbar to turn on line end points.
    2. Click the line on the canvas to add a mid-line point. You can add as many mid-line points as you need.
    You can now drag the anchor line midpoints to create angles in the line. This can be useful when multiple lines cross to avoid confusion in their paths.
    You can add angles to a line, but you cannot create a line curved to an arc.
  12. (Optional) Add arrows to the line:
    1. Click the On/Off button next to
      Arrows
      to turn it on.
    2. Click
      Arrows
      to expand the menu.
    3. Set the properties for the arrow:
      • Type
        Defines whether there is a single or multiple arrow heads on the line. If you click
        Multiple
        , an arrow head is displayed in the center of each line segment.
      • Direction
        Sets whether the arrowheads point in the direction that the line was created (
        Head
        ) or back to the origination point (
        Tail
        ).
You can now assign a data source to the line, if desired, or change other properties of the line, such as adding a shadow or border, or creating a color map.
Add an Image
Add an image widget to display an image on the dashboard. The image can be used (for instance) to represent a network or device, a network or device location (such as a map), or any other graphical element to provide context to the dashboard.
The following types of image files are supported:
  • .gif
  • .jpg
  • .jpeg
  • .tiff
  • .png
To add a background image to the dashboard, use the
Background Image
setting in the
Canvas Properties
( DashboardCanvas.png ) tab instead of an image widget. The
Background Image
setting automatically places the image at the back of the layers on the canvas, and actions you take on the canvas do not affect the image.
The image widget supports the following data sources:
  • Alarm
  • Dashboard
  • Metric
  • QoS
  • SLA
  • SQL
Follow these steps:
  1. Click the
    Widgets
    ( Widgets.PNG ) tab.
  2. Click
    General
    to expand the menu.
  3. Drag the
    Image
    widget onto the canvas.
  4. Click the image widget to select it.
  5. Click the
    Widget Properties
    ( DashboardProperties.png ) tab.
  6. Click
    Image
    to expand the menu.
  7. Click in the
    Image
    field to display the Image Gallery.
  8. Click an image to select it.
    To add an image to the Image Gallery, click
    Upload Image
    and browse to the image.
  9. Click
    Select
    .
    The image is displayed in the widget. By default
    Stretch to fit
    is turned off. To size the image to fit the frame of the widget, click the button to turn this on.
You can now assign a data source to the image widget or change the widget properties, including defining an image map.
Add an SQL Table
Add an SQL table widget to display data from an SQL query.
You must have an SQL data source configured to display data in the table widget. You can assign a previously written query or can create a new query while defining the widget.
Follow these steps:
  1. Click the
    Widgets
    ( Widgets.PNG ) tab.
  2. Click
    General
    to expand the menu.
  3. Drag the
    SQL Table
    widget onto the canvas.
  4. Click the
    Data Sources
    ( DataSources.PNG ) tab.
    If you do not see the
    SQL
    pane, click
    Options
    ( Options.PNG ),
    Show advanced data sources
    .
  5. Click
    SQL
    to expand the menu.
  6. Drag an SQL data source onto the table widget.
    If you do not see any SQL data sources, create one.
    The table is created with the appropriate rows and columns and is populated with data. You can set the properties for the columns in the following steps.
  7. Click the table to select it.
  8. Click the
    Widget Properties
    ( DashboardProperties.png ) tab.
  9. Click
    Table
    to expand the menu.
  10. Set the
    Row Height
    for the table.
  11. Click
    Columns
    to expand the menu.
  12. Select a column by clicking the column header in the table widget or by clicking its column header in the Header.
  13. Set the properties for the columns:
  • Header
    Sets the header of the selected column.
  • Width
    Sets the width of the selected column.
  • Data Type
    Defines the column data as alphanumeric strings or as numbers.
  • Visible
    Shows or hides a column in the widget. With the column header selected in the Properties column, click on the
    On/Off
    button to hide or display the column data. An icon ( HiddenIcon.PNG ) beside the properties header indicates that the column is hidden in the widget.
  • Renderer
    Sets the format for data display for the selected column. Choose the type of renderer from the pull-down menu. The available column properties depend on the type of renderer selected.
    • Bar:
      • Show Value
        Turns on or off the display of the numeric value next to the bar in the column.
      • Minimum
        Sets the minimum value to display for the bar.
      • Maximum
        Sets the maximum value to display for the bar.
      • Bar Color
        Sets the color of the bar.
      • Bar Color Map
        Sets different colors for different values. For example, for a bar displaying percent, you can set 90 percent to red and all values of 90 percent or greater are displayed in red in the bar. Click the plus sign to add more color settings.
    • Gauge:
      GaugeShape.PNG
      Sets the shape of the gauge, semicircle, or circle.
      • Min
        Sets the minimum value to display for the gauge.
      • Max
        Sets the maximum value to display for the gauge.
      • Default Color
        Sets the color to use to indicate the position of the gauge.
      • Color Map
        Sets different colors for different values on the gauge. For example, for a gauge displaying percent, you can set 90 percent to red and all values of 90 percent or greater are displayed in red on the gauge. Click the Add button to add more color settings.
    • Image:
      • Default Image
        Sets the image to display in the column. Click in the
        Default Image
        field to display the Image Gallery. To add an image to the Image Gallery, click
        Upload Image
        and browse to the image.
      • Stretch to fit
        Sizes the image to fit the frame of the widget. Click the button to turn this on.
      • Image Map
        Click the Add button to add different images to be displayed for different data values. For example, for a column displaying percent, you can set 90 percent to an image of a warning icon and all values of 90 percent or greater are displayed as the warning icon in the column.
    • Link:
      Click the open row or on the Add button to create a URL link to navigate to a website or to another dashboard.
      All entered URL addresses appear in a drop-down list when you right-click anywhere in the dashboard in
      Live view
      mode. An external URL opens a new page in a browser.
    • Text:
      • Font Size
        Sets the size of the text font.
      • Color
        Sets the color of the font. Click in the
        Color
        field to display a color picker. Use the slider on the right of the color picker to set the opacity for the color.
      • Color Map
        Sets different colors for different values. For example, for a column displaying percent, you can set 90 percent to red and all values of 90 percent or greater are displayed in red in the column. Click the plus sign to add more color settings.
      • Sort
        Column data is sortable as alphanumeric strings or as numbers. In the dashboard widget, click on the column header once to sort in ascending order, a second time to sort in descending order, and a third time to return to the default order. An arrow appears beside the column header to indicate an ascending or descending column data sort.
To add links to an SQL table, see Create and Assign the Data Source for a Widget.
Add a List Widget
You can add a List widget to the dashboard to provide a quick view of computer systems and performance in numeric or graphic format. You can use the List widget to add detail to dashboard widgets displaying, for instance, alarms or gauges.
Follow these steps:
  1. Click on the
    Widgets
    ( Widgets.PNG ) icon at the upper right to bring up the list of widgets.
  2. Drag a
    List
    widget icon onto the dashboard.
Filter Systems for Display
When you drag the List widget to your Dashboard, the List Designer screen starts automatically. You can create filters to populate the list and test the filters within the screen before applying them to the list. Common filters include systems and devices.
Operators in the filters include:
  • and/or
  • not
  • is/contains/starts with/ends with/in
Follow these steps:
  • Define a filter using the dropdown menus and text fields.
  • Add another filter by clicking on the
    Add filter
    ( DashboardAddDataSource.png ) icon on the right side above the filter list.
  • Delete a filter by clicking on the
    Delete filter
    ( DashboardDeleteDataSource.png ) icon to the right of the filter.
  • Reorder the filters by dragging a filter box up or down in the list of filters. If you are reordering the first two filters, the "and/or" expression automatically moves to the second filter box; otherwise, the "and/or" expression will stay with its filter.
  • Test the filters by clicking on the
    Test Filters
    button at the lower-left corner of the window.
  • Click on the
    Next
    button at the lower-right corner of the screen.
The filter screen disappears and the list layout screen appears.
Format the Display
Once you have defined the system data, you can format the display of that data. The screen creates the rows necessary to hold the information from the previous screen. The first data column is by default the system field, and shows the results of the filter test. You can add data columns as necessary.
To define the data layout:
  1. Click on the
    Add Column
    ( DashboardAddDataSource.png ) icon. A data column is added to the list.
  2. Enter the column definition fields from the dropdown menus at the bottom of the screen:
  • Column Header
  • Column Type
  • Renderer Type
  • Metric
    (metric types contain their own dropdown menus, and an additional metric filter can be entered)
  • Renderer Properties
Additional display parameters can be defined at the bottom of the screen. To move between parameters for each column, click in the column display at the top of the screen. Table characteristics (number and height of rows) can be adjusted through the
Table Properties
tab. The screen displays a sample of the output so you can make changes before committing to the dashboard.
Once the output is acceptable, click
Finish
. The List widget is added to your dashboard.
You can rerun the list filters on the List widget by clicking the 
Reload Data
 ( UIMHealthRestart.png ) icon or can edit the widget by clicking the
Open Wizard
( WizardWand.png ) icon, both on the tab at the upper-right side of the widget.
Add Text
A text widget allows you to place text on the dashboard.
A text widget is different from a widget label. Use a label to assign a title or name to a widget. Use a text widget instead of a label if you want to:
  • Use standalone text.
  • Use a different text format, such as date or numeric.
  • Assign a different data source to the text than the widget.
  • Set properties for the text separately from the widget.
    For example, using a text widget allows you to position the text independently of the widget or to apply a shadow to the text box rather than to the widget.
There are two types of variables you can use in text widgets:
  • $VAR - Use this to display the current value of the data source.
  • Parameters - Use variables that you created in the  DashboardParameters.png (Parameters) tab.
The text widget supports the following data sources:
  • Alarm
  • Metric
  • Probe
  • QoS
  • SLA
  • SQL
Follow these steps:
  1. Click the
    Widgets
    ( Widgets.PNG ) icon in the right pane.
  2. Click
    General
    to expand the menu.
  3. Drag a text widget onto the canvas.
  4. Click the text widget to select it.
  5. Click the
    Widget Properties
    ( DashboardProperties.png ) tab.
  6. Click
    Text
    to expand the menu.
  7. Choose the text format that you want from the
    Type
    menu. Additional menu items associated with the chosen text type is displayed.
    • Date
      Sets the format for the text as
      mm/dd/yy hh:mm
      by default.
    • Show natural date
      Communicates time in "natural" language, for example: "Yesterday". 
    • Use current date and time
      Continuously displays the current date and time.
    • Date Format
      Sets your preferred format.
    • Time zone
      Sets your preferred time zone.
    • Numeric
      Sets the value based on the following fields:
    • Default Number
      Sets the initial number value.
    • Fixed Decimal Places
      Sets the number of places to the right of the decimal. The value is rounded to the number of decimal places specified.
    • Unit Multiplier
      Sets the number that the numeric value is multiplied by.
    • Unit Divisor
      Sets the number that the numeric value is divided by.
    • String
      Sets the text format as alphanumeric, which accepts all character keys on the keyboard.
    • Default Value
      Sets the initial character string. You might also set this value by double-clicking the widget on the canvas and entering text.
    • Font Size
      Sets the size of the text.
    • Word Wrap
      Turns the word wrap feature on or off. When on, text that is too wide for the text widget is displayed on multiple lines. When off, text that is too wide for the text widget is displayed on a single line with an ellipsis (...) indicating that not all text is visible.
    • Text Vertical Alignment
      Defines whether the text appears at the top, middle, or bottom of the text box.
    • Text Color
      Sets the color of the text. Enter a hex code, or click in the
      Text Color
      field to display a color picker. Use the slider on the right of the color picker to set the opacity for the color.
    • Background Color
      Sets the background color for the text widget. Enter a hex code, or click in the
      Background Color
      field to display a color picker. Use the slider on the right of the color picker to set the opacity for the color.
  8. (Optional) Set a background image for the text widget:
    1. Click
      Background Image
      to expand the menu.
    2. Click in the
      Image
      field to display the Image Gallery.
    3. Click an image to select it. To add an image to the Image Gallery, click
      Upload Image
      and browse to the image.
    4. Click
      Select
      .
The image is displayed in the text widget. By default
Stretch to fit
is off. To size the image to fit the frame of the widget, click the button to turn this function on.
You can now assign a data source to the text widget. Depending on the assigned data source type, you can define additional properties on the
Widget Properties
tab, such as a color map using the
Color
menu or an audio notification using the
Sound
menu.
Add a Gauge
Add a gauge widget to display a data value within a semi-circular or circular needle gauge in the dashboard.
The gauge widget supports the following data sources:
  • Metric
  • Probe
  • QoS
  • SLA
  • SQL
Follow these steps:
  1. Click the
    Widgets
    ( Widgets.PNG ) icon in the right pane.
  2. Click
    Gauges
    to expand the menu.
  3. Drag a gauge onto the canvas.
  4. Click the gauge to select it.
  5. Click the
    Widget Properties
    ( DashboardProperties.png ) tab.
  6. Click
    Gauge
    to expand the menu.
  7. Set the properties for the gauge:
    GaugeShape.PNG
    • Sets the shape of the gauge: semicircle or circle.
    • Min
      Sets the minimum value for the gauge.
    • Max
      Sets the maximum value for the gauge.
    • Unit Divisor, Unit Multiplier
      Performs calculations on the data before displaying the value. For example, a value reported in bytes per second can be displayed as bits per second by setting the Unit Multiplier to 8 and the Unit Divisor to 1.
    • Default Color
      Sets the color to use to indicate the position of the gauge.
    • Color Map
      Sets different colors for different values on the gauge. For example, for a gauge displaying percent, you can set 90 percent to red and all values of 90 percent or greater are displayed in red on the gauge. Click the plus sign to add more color settings.
    • Decimal Places
      Sets the number of decimal places that are displayed on the gauge. Add decimal places to see finer grained measurements. For example, for a metric that has a minimum value of 0 and a maximum value of 5, you may want to add a decimal place so that the gauge needle displays a more precise position. However, for percentages, with a minimum value of 0 and a maximum value of 100, you might want to leave the decimal places set to 0.
You can now assign a data source to the gauge or change properties such as the label, size and position.
Add a Linear Gauge
Add a linear gauge to display a data value within a thermometer-style gauge. This gauge can be oriented vertically or horizontally.
The linear gauge widget supports the following data sources:
  • Metric
  • Probe
  • QoS
  • SLA
  • SQL
Follow these steps:
  1. Click the
    Widgets
    ( Widgets.PNG ) icon in the right pane.
  2. Click
    Gauges
    to expand the menu.
  3. Drag a linear gauge onto the canvas.
  4. Click the linear gauge to select it.
  5. Click the
    Widget Properties
    ( DashboardProperties.png ) tab.
  6. Click
    Gauge
    to expand the menu.
  7. Set the properties for the linear gauge:
    • Vertical
      Defines whether the gauge is vertical or horizontal. Turn on for a vertical gauge, off for a horizontal gauge.
    • Ticks Visible
      Defines whether ticks (lines) indicating unit intervals are shown.
    • Labels Visible
      Defines whether labels for the ticks are shown.
    • Labels Size
      Sets the size of the numbers on the gauge.
    • Labels Offset
      Sets how far from the ticks, and on which side, the numbers are displayed.
    • Min
      Sets the minimum value for the gauge.
    • Max
      Sets the maximum value for the gauge.
    • Unit Divisor, Unit Multiplier
      Performs calculations on the data before displaying the value. For example, a value reported in bytes per second can be displayed as bits per second by setting the Unit Multiplier to 8 and the Unit Divisor to 1.
    • Bar Thickness
      Defines the width of the bar that indicates the value.
    • Bar Offset
      Sets where the bar is displayed.
    • Tick Size
      Defines the vertical length of the ticks.
You can now assign a data source to the linear gauge or change properties, such as its label, size, and position.
Add a Line Chart
Add a line chart to display a graph of data in the dashboard.
The line chart widget can display data series for one or more data sources. Data that are collected while a data source is in maintenance mode displays in the chart with a gray overlay.
The line chart widget supports the following data sources:
  • Metric
  • QoS
  • SQL query
SQL data sources must contain data from two columns in the SQL query: a timestamp (date/time or milliseconds) column and a values column.
Follow these steps:
  1. Click the
    Widgets
    ( Widgets.PNG ) icon in the right pane.
  2. Click
    Charts
    to expand the menu.
  3. Drag a line chart onto the canvas.
  4. Click the chart to select it.
  5. Click the
    Widget Properties
    ( DashboardProperties.png ) tab.
  6. Click
    Chart
    to expand the menu.
  7. Set the properties for the chart:
    • X-Axis Label
      Displays a label for the x- (horizontal) axis. The x-axis displays the time interval for the chart.
    • Y-Axis Label
      Displays a label for the y (vertical) axis. The y-axis displays the unit for the QOS measurement.
    • Series Duration in Hours
      Sets the number of hours of data that are displayed, ending with the current full hour. For example, if the current time is 10:15 and you set the duration to 4 hours, data from 6:00 to 10:00 is displayed.
    • Min Value
      Sets the minimum value to display on the y-axis. If no value is entered, the chart will use autoscaling to define the range.
    • Max Value
      Sets the maximum value to display on the y-axis. If no value is entered, the chart will use autoscaling to define the range.
    • Timezone
      Sets the time zone for the chart.
  8. Click
    Series
    to expand the menu.
  9. Click the
    Add
    ( DashboardAddDataSource.png ) sign to add a data series to the chart.
  10. Click the name of the data series to select it.
  11. Enter a name for the data series.
  12. Set the properties for the data series:
    • Series Data Source Type
      Sets the type of data source for the selected data series.
    • Series Data Source Name
      Sets the data source for the selected data series. If no data sources are listed in the pull-down menu, create the data sources for the chart.
    • Display Type
      Sets the type of chart to display for the selected data series: area, line, or plot.
    • Color
      Sets the color for the selected data series. Click in the
      Color
      field to display a color picker. Use the slider on the right of the color picker to set the opacity for the color.
    • Size
      Sets the size of the line or plot points for the selected data series.
    • Drop Shadow
      Turns on or off the display of a shadow below the selected data series.
    • Unit Multiplier, Unit Divisor
      Performs calculations on the data before displaying the value. For example, a value reported in bytes per second can be displayed as bits per second by setting the Unit Multiplier to 8 and the Unit Divisor to 1.
  13. (Optional) Create additional data series.
  14. (Optional) Use the up and down arrows to move the selected data series up or down in the list.
    If data for multiple data series overlaps, the series highest in the list is displayed. For example, if you have a data series measuring CPU usage for the user and a data series measuring CPU usage for the system, and the values for both are 0 for the time interval, the data for the data series that appears first in the list is displayed.
You can now change other properties for the line chart, such as its label or size and position.
Add a Pie Chart
Add a pie chart to display a percentage distribution chart in the dashboard.
The pie chart widget supports the following data sources:
  • SQL
    You must use an SQL data source where the query returns at least two columns of information. The first column must be a label, the second column a quantity. The following example shows a database query that returns the severity (label) and count (quantity).
    SELECT severity, count(severity) FROM nas_alarms GROUP by severity
Follow these steps:
  1. Click the
    Widgets
    ( Widgets.PNG ) icon in the right pane.
  2. Click
    Charts
    to expand the menu.
  3. Drag a pie chart onto the canvas.
  4. Click the chart to select it.
  5. Click the
    Widget Properties
    ( DashboardProperties.png ) tab.
  6. (Optional) Add a legend to the pie chart:
    1. Click
      Pie
      to expand the menu.
    2. Click the
      On/Off
      button next to
      Legend
      to set whether the legend displays or not.
  7. (Optional) Display labels on the pie chart:
    1. Click the
      On/Off
      button next to
      Pie Labels
      to set whether labels display or not.
    2. When labels for the pie chart are shown, click
      Pie Labels
      to expand the menu.
    3. Set the properties for the labels in the pie chart, such as alignment, font size, font color, or background color.
  8. (Optional) Add a label for the pie chart:
    1. Click
      Label
      to expand the menu.
    2. You can now add or change the label properties.
  9. (Optional) Change the size or position of the pie chart in the dashboard:
    1. Click
      Size & Position
      to expand the menu.
    2. You can now set the size or position properties of the pie chart.
You can now assign a data source to the pie chart or change the widget properties.
Add a Context Selector
Add a context selector widget to the dashboard to display data in other widgets dynamically. Use of context selectors allow you to view data otherwise requiring multiple dashboards.
Context selectors include a time selector, custom selectors, and dashboard links. The Time selector passes time values that are used by dashboard SQL data sources. A custom selector passes values from a URL link, SQL query, or static table as SQL parameters to other dashboard widgets. A Dashboard selector passes context values to other dashboards with common parameters.
You can use the time selector to view data for one particular time interval and then change the parameter to view the same data for a different time interval. You can use the custom context selector to switch dashboard SQL parameters at runtime. You can use the dashboard selector to pass parameters from one dashboard to other dashboards in order to view data in series.
Follow these steps.
For a Time selector:
  1. Click the
    Widgets
    ( Widgets.PNG ) tab.
  2. Click
    General
    to expand the menu.
  3. Drag the
    Context Selector 
    widget onto the canvas. The
    Time
    selector is the default.
  4. Pull down the dropdown menu for the
    Time
    selector (the default) and click on a time period.
    Dropdown selections within the Time selector perform parameter substitution within dashboard SQL queries on the start and end times in milliseconds since epoch. The format for the parameters in the SQL query is
    ${startTime} ${endTime}
    . For example, the following SQL query can be defined through the Advanced Data Sources tab and assigned to a widget and time values assigned at runtime: the base query displays the names of resources that are in the UIM inventory and the Time selector allows you to filter by date.
    select name, create_time from cm_computer_system where
    create_time > dateadd (SECOND, ${startTime}/1000, '1970-1-1') and
    create_time < dateadd (SECOND, ${endTime}/1000, '1970-1-1') and
    origin = '${originTag}'
    At runtime, the ${startTime} and ${endTime} values are taken from the Time selector selection. Remember that SQL data returned is limited by the type of widget used. 
  5. Click the
    Widget Properties
    ( DashboardProperties.png ) tab and the Add context selector ( DashboardAddDataSource.png ) icon to add a context selector.
  6. Click on the type of column being added:
    • Custom
    • Dashboard
  7. Double-click on the header name for the context selector in the Properties column to change the header name.
  8. Insert the parameter name for the column value.
    Custom context selections take precedence over any parameter that might be defined elsewhere with the same name.
  9. For a Custom context selector, click on the option button for the data source type:
    • URL
    • SQL
    • Manually entered values
    For a website location:
    1. Enter the URL for an external REST web service.
      An external web service for a URL data source must:
      • Accept a GET request to the specified URL.
      • Return a JSON string that includes the label and value for each entry in the required format.
      For example:
      [
        {
          "label": "foo",
          "value": "bar",
          "children": [
            {
              "label": "foochild",
              "value": "barchild"
            }
          ]
        }
      ]
    For an existing SQL query:
    1. Click on the dropdown list in the
      Database
      section.
    2. Click on the name of an existing SQL query.
    For a new SQL query:
    1. Click Add button.
    2. In the dialog box, enter a name for the query in the
      Name
      field.
    3. Click on the
      Database
      for interest.
    4. Enter a query in the
      Query
      field.
    5. Click on
      Test Query
      .
    6. If the query does not return a failure message, click
      Save
      .
      Custom SQL context selectors require one or two data columns. The data appear under one of these conditions:
      • The SQL query returns a single column of data when the column is used for both a label and a value.
      • The SQL query returns two columns of data for a label and value pair.
      • The SQL query returns the first two columns of data where more than two columns are queried.
    For manually entered values:
    1. Type the label and values into the open fields in the
      Properties
      column.
    2. Click on the context selector pulldown menu and the label for the desired value.
  10. Click on
    Dashboard, Live View
    to view the data results.
When both dashboards contain common custom context selectors (such as the Time selector), the value from the custom context dashboard is passed to the linked dashboard. Custom context selector values in a linked dashboard can be set to another value, but those new values are not passed back to the previous dashboard.
The Dashboard selector allows you to navigate between dashboards during runtime. The list of available dashboards can be limited to a specified folder.
For a Dashboard selector:
  1. Click on the header for the
    Dashboard
    selector.
  2. Click on the dashboard folder in the
    Dashboard Folder
    section.
  3. Click on the dashboard of interest.
  4. Click on
    Live view
    .
  5. Click on the
    Dashboard
    selector to navigate to the linked dashboard. Parameters from the linking dashboard are automatically passed to the linked dashboard.
A list of substituted values is displayed in the Inherited section under the
Parameters
tab. The sequence of opened dashboards appears beside the
Modes
menu in the top-center tab of the
Live view
window.
A list of substituted parameters in linked dashboards are displayed in the Edit mode, under the
Parameters
tab, in the Inherited section.
dashPieChart