Dashboard designer

In EDA, you can construct your own dashboard pages to display the data you deem important for your operation.

The Dashboards page allows you to construct a dashboard, which itself can contain one or more layouts. Each layout is a separate dashboard page, selectable using a drop-down on the main dashboard.

Each dashboard layout can be either a page consisting of a collection of dashlets, each displaying its own source data; or a single list, which is a conventional data grid displaying a single set of source data.

For dashboard layouts, you can construct each layout by selecting from a set of pre-defined dashlets. Each dashlet can show a particular type of data like counters, lists, and charts. You can then add these dashlets to a page you design, optionally distributing them among a set of rows and columns you have specified within the page. Individual dashlets can be set to span multiple rows or columns.

For each list layout or dashlet layout in the dashboard, you define source data by constructing an EDA query, natural language query, GVK definition, or specifying a URL endpoint. You can then specify details about which parts of that data are displayed, set thresholds for highlighting, and make other formatting choices depending on the dashlet type.

Dashboard builder also supports filters. Filters use variable substitution to modify dashlet queries based on user input. For example, a dashboard which displays data for all TopoNodes can be filtered to display only data from a specific TopoNode.

The Dashboard designer only displays dashboards that were created by the current user. A future release will allow users to publish and share dashboards with other users.

Dashboards page

The Dashboards page is the point from which you can access existing dashboards, and begin creating new dashboards.

Figure 1. The dashboards page
Table 1. Elements of the Dashboards page
# Name Function
1 Breadcrumb bar Displays the current position in the set of Dashboard designer pages.
2 Row actions Clicking the Table row actions icon reveals the actions available for dashboards displays in the data grid.
  • Preview: Displays a preview of the selected dashboard.
  • Edit: Opens the Dashboard designer view for this dashboard.
  • Delete: Deletes the selected dashboard.
3 Create Click to open the Dashboard Designer view for a new dashboard.
4 Create List Layout Click to open the Dashboard Designer view for a new dashboard consisting of a single list.
5 Import Click to open a file selection dialog. Select the file for a previously exported dashboard and click Open to import the selected dashboard. The new dashboard is then displayed in the Dashboards list.
6 Information panel A standard EDA information panel, displaying details about the selected dashboard.

Dashboard designer page

The dashboard designer page is the space in which to create a dashboard and its constituent layouts, and to configure the data displayed on each.

Figure 2. The dashboard designer page
Table 2. Elements of the Dashboard Designer page
# Name Function
1 Definition/Library panel The Definition tab displays basic parameters about the current dashboard layout, like its name and description.

The Library tab displays elements that you can add to the current dashboard layout: flex rows, flex columns, and dashlets.

2 Layout panel This is the area that displays the dashboard layout you are designing.

Drag objects from the Libraries tab into this space to add elements to the dashboard layout.

Select objects in this panel to view and configure their properties in the Properties tab.

3 Properties The Properties tab displays properties for the current dashboard, and for the row, column, or dashlet currently selected in the layout panel.

Use this tab to configure the basic display properties for the dashboard.

4 Filter configuration panel

Filters are an optional way to modify the data underlying dashlets contained on the dashboard.

Use this panel to configure one or more filters for the current dashboard.

Once a filter is configured, you can include a corresponding "where" clause in the queries underlying individual dashlets.

Enable the Show filters bar property to display a widget on the layout panel that allows you display and use specific filters you have configured.

See the procedure for creating dashboard filters for the steps to create a filter, add a reference to the queries for dashlets, and use the filters to constrain the data displayed by those dashlets.

4 Add Click to add another dashboard layout to the dashboard.
5 Add List Layout Select this option in the drop-down to add a List page to the dashboard.
6 Save Click to save the current dashboard design.
7 Reset Click to discard all changes since you last saved the layout, after confirmation.
8 More icon Click to view a list of available actions for the current Dashboard:
  • Preview saved changes: open a new tab that displays the current dashboard design.
  • Export: save the dashboard design as a file, which others can import into their copy of EDA.

Flex grids

Flex grids are the underlying structure of a dashboard. You must add at least one flex row or flex column to the dashboard before you can then fill the resulting grid with individual dashlets.

To add a flex row or flex column to a dashboard design, drag the flex row or flex column from the Library panel onto the Layout panel.

You can add a series of rows and columns to create a customized grid for your dashboard design. Each cell in the grid can then accept one or more dashlets.

For example, in the illustration below, the dashboard includes multiple flex rows, and a flex column has been added to the first row to divide it into two cells.
Figure 3. Flex grid
When you select a specific cell in the Layout panel, the Properties panel displays two properties that you can configure for the selected flex row or column:
  • Vertical Alignment: the vertical position of any dashlets that are placed in that cell.
  • Horizontal Alignment: the horizontal position of any dashlets that are placed in that cell.

Dashlet types

Dashlets are the building block from which you can build your dashboard. Several types of dashlets are available in EDA; each can be dragged and dropped on to your dashboard design. If you have added flex columns or rows, you can distribute dashlets within the resulting grid.

The counts dashlet

The counts dashlet displays a simple count of qualifying instances of something in EDA. You select a data source, and can then specify criteria to distinguish qualifying instances of the selected data that are counted and highlighted, versus the basic number of all records in the selected data source.

Figure 4. A sample counter dashlet
Table 3. Count dashlet properties
Property Description
Common properties
Title The title of the dashlet when displayed in the EDA UI.
Subtitle A subtitle, displayed below the title and in a smaller font.
Navigation target Adds a View button to the dashlet that, when clicked, opens a selected page within the EDA UI. The target can be:
  • a page within the EDA GUI that you select from the displayed drop-down list
  • the Query Builder page. For this option, enter the navigation target /ui/main/queryapi. This causes an additional field to display among the dashlet properties: Optional Navigation Query.

    The query that is displayed on the Query Builder page after a user clicks the View link on the dashlet depends on the value in the Optional Navigation Query field. Here you can set the query that will display in the Query Builder; this could be the query that underlies the dashlet, or another.

Fill available width Dynamically changes the dashlet width based on the browser window and neighboring dashlets.
Dashlet width The relative width of the dashlet.
Dashlet height The relative height of the dashlet.
API Specification
Query Click the More icon to open a page on which to configure the data source for this dashlet.

On that page you configure the data source as one of the following:

  1. EQL Query
  2. Natural Language query
  3. GVK Definition
  4. URL Endpoint
Counters These properties configure the highlighting of values that meet criteria on the counts dashlet:
  • Label: the label shown beside qualifying values
  • Color: the color used to highlight qualifying values
  • Field: the field within the data source to be evaluated for possible highlighting
  • Criteria (Equals, Not Equal, Greater Than, Less Than): the logical operator that qualifies for this highlight (in combination with Value)
  • Value: the comparison value for the logical criterion.
Additional dashlet properties
Show total Indicates whether to display a count of all values retrieved in the source data set should be displayed on the chart, in addition to qualifying values.
Show total at end When the total is shown, controls the position of the total display. Toggles between the total being the first count, or the last.
Show percentage Indicates whether the counter should display what percentage of all values are represented by qualifying values.
Vertical lists When the total is shown, controls the position of the total count and qualifying count. Toggles between the total being above, or below the count of qualifying values.

The line chart dashlet

A line chart dashlet places a line chart on the dashboard layout. It supports both stacked line charts (in which values are successively added to show a series of cumulative totals) and overlaid (a standard line chart in which values are displayed independently, not as a sum).

Figure 5. A sample line chart dashlet
Table 4. Line chart dashlet properties
Property Description
Common properties
Title The title of the dashlet when displayed in the EDA UI.
Subtitle A subtitle, displayed below the title and in a smaller font.
Navigation target Adds a View button to the dashlet that, when clicked, opens a selected page within the EDA UI. The target can be:
  • a page within the EDA GUI that you select from the displayed drop-down list
  • the Query Builder page. For this option, enter the navigation target /ui/main/queryapi. This causes an additional field to display among the dashlet properties: Optional Navigation Query.

    The query that is displayed on the Query Builder page after a user clicks the View link on the dashlet depends on the value in the Optional Navigation Query field. Here you can set the query that will display in the Query Builder; this could be the query that underlies the dashlet, or another.

Fill available width Dynamically changes the dashlet width based on the browser window and neighboring dashlets.
Dashlet width The relative width of the dashlet.
Dashlet height The relative height of the dashlet.
API Specification
Query Click the More icon to open a page on which to configure the data source for this dashlet.

On that page you configure the data source as one of the following:

  1. EQL Query
  2. Natural Language query
  3. GVK Definition
  4. URL Endpoint
Chart Configuration These properties control the display of the line chart:
  • Maximum number of data points
  • Y-Axis Units
  • Scaling Function (None, Metric Prefix Scaling)

The donut dashlet

A donut dashlet places a pie chart on the dashboard layout. You must configure a data source, and then set criteria for various pie slices describing qualifying subsets of that data. Many parameters are available to control the way the appearance of the chart and the individual pie slices.

Figure 6. A sample donut dashlet
Table 5. Donut dashlet properties
Property Description
Common properties
Title The title of the dashlet when displayed in the EDA UI.
Subtitle A subtitle, displayed below the title and in a smaller font.
Navigation target Adds a View button to the dashlet that, when clicked, opens a selected page within the EDA UI. The target can be:
  • a page within the EDA GUI that you select from the displayed drop-down list
  • the Query Builder page. For this option, enter the navigation target /ui/main/queryapi. This causes an additional field to display among the dashlet properties: Optional Navigation Query.

    The query that is displayed on the Query Builder page after a user clicks the View link on the dashlet depends on the value in the Optional Navigation Query field. Here you can set the query that will display in the Query Builder; this could be the query that underlies the dashlet, or another.

Fill available width Dynamically changes the dashlet width based on the browser window and neighboring dashlets.
Dashlet width The relative width of the dashlet.
Dashlet height The relative height of the dashlet.
Charts
Charts A single pie chart dashlet can include multiple pie charts.

Use this space to add and configure each pie chart.

After configuring a pie chart, click the + icon to add and configure an additional pie chart for this dashlet.

Donut Chart Details

An individual pie chart within the donut dashlet is configured on this page.

Query Definition Specifies the data source on which the pie chart's segments is based. Choose from:
  • EQL Query
  • Natural Language query
  • GVK Definition
  • URL Endpoint
Hide title Indicates whether to show the chart title on the chart, or not.

Toggles Yes or No.

Show total Indicates whether the sum of all segments should be displayed on the chart, or not.

Toggles Yes or No

Show slice labels

Indicates whether each chart segment should display a label for its data.

Possible values: All, Percent, None

Slices: these properties control the display of each slices in the chart.

Configure and add as many slices as your chart requires.

Label Indicates whether this slice should display its own label.
Color The shading color applied to this slice.
Field From the selected data source, the individual field corresponding to this slide.
Criteria The logical criterion for this slide (Equals, Not Equal, Greater Than, Less Than)
Value The fixed value against which the current field value and the Criteria are compared.
+ Click this icon to add the slice configuration to the set of slices included in this chart.

The data view dashlet

A data view dashlet places a data grid on the dashboard. You must specify a data source as part of the dashlet design..

Figure 7. A sample dataview dashlet
Table 6. Dataview dashlet properties
Property Description
Common properties
Title The title of the dashlet when displayed in the EDA UI.
Subtitle A subtitle, displayed below the title and in a smaller font.
Navigation target Adds a View button to the dashlet that, when clicked, opens a selected page within the EDA UI. The target can be:
  • a page within the EDA GUI that you select from the displayed drop-down list
  • the Query Builder page. For this option, enter the navigation target /ui/main/queryapi. This causes an additional field to display among the dashlet properties: Optional Navigation Query.

    The query that is displayed on the Query Builder page after a user clicks the View link on the dashlet depends on the value in the Optional Navigation Query field. Here you can set the query that will display in the Query Builder; this could be the query that underlies the dashlet, or another.

Fill available width Dynamically changes the dashlet width based on the browser window and neighboring dashlets.
Dashlet width The relative width of the dashlet.
Dashlet height The relative height of the dashlet.
Charts
Query Click the More icon to open a page on which to configure the data source for this dashlet.

On that page you configure the data source as one of the following:

  1. EQL Query
  2. Natural Language query
  3. GVK Definition
  4. URL Endpoint
Show information panel Indicates whether an information panel should be available on this dashlet.
Show status bar Indicates whether to include a status bar on the dashlet, showing (for example) whether any filters are applied, and the total number of rows in the list.

The bar chart dashlet

A bar chart dashlet places a bar chart on the dashboard layout. It supports both horizontal and vertical bar charts.

You can also configure the chart to show stacked bars contributing to a total value, with the elements in the stack indicated as either a raw value or a percentage of the whole.

Figure 8. A sample bar chart dashlet
Table 7. Bar chart dashlet properties
Property Description
Common properties
Title The title of the dashlet when displayed in the EDA UI.
Subtitle A subtitle, displayed below the title and in a smaller font.
Navigation target Adds a View button to the dashlet that, when clicked, opens a selected page within the EDA UI. The target can be:
  • a page within the EDA GUI that you select from the displayed drop-down list
  • the Query Builder page. For this option, enter the navigation target /ui/main/queryapi. This causes an additional field to display among the dashlet properties: Optional Navigation Query.

    The query that is displayed on the Query Builder page after a user clicks the View link on the dashlet depends on the value in the Optional Navigation Query field. Here you can set the query that will display in the Query Builder; this could be the query that underlies the dashlet, or another.

Fill available width Dynamically changes the dashlet width based on the browser window and neighboring dashlets.
Dashlet width The relative width of the dashlet.
Dashlet height The relative height of the dashlet.
API Specification
Query Click the More icon to open a page on which to configure the data source for this dashlet.

On that page you configure the data source as one of the following:

  1. EQL Query
  2. Natural Language query
  3. GVK Definition
  4. URL Endpoint
Chart Configuration These properties control the display of the line chart:
  • Group By
  • Secondary Grouping
  • Value Field
  • Unit of Measure
  • Scaling Function (None, Metric Prefix Scaling)
  • Use Columns instead of Bars (yes/no)
  • Show stacked data (Off/Value/Percent)

Using the dashboards list

  1. Open the Dashboards page in the EDA GUI by selecting Main > Dashboards.
    The Dashboards list displays, showing all currently configured dashboards.
    Note: By default, the list shows Custom dashboards. The Core dashboards list (selectable using a drop-down the navigation bar at the top of the page) is not currently enabled.
  2. Do any of the following:
    • To preview an existing dashboard, click the Table row actions icon and select Preview from the displayed list.
    • To edit an existing dashboard, click the Table row actions icon and select Edit from the displayed list.
    • To delete an existing dashboard, click the Table row actions icon and select Delete from the displayed list, then click OK in the resulting confirmation dialog.

Designing a dashboard

This task guides you through the steps of adding and configuring layouts within a single dashboard by:
  • creating the new dashboard
  • adding a single layout: either a list layout, or a dashboard layout consisting of one or more dashlets
  • configuring the data source for each list or dashlet, and configuring the appearance and behavior of each.
  • optionally adding more list or dashboard layouts to the same dashboard
  • saving your layout
  1. Open the Dashboards page by selecting Main > Dashboards form the navigation menu.
    This opens the Dashboards page, showing a list of already-configured dashboards.
  2. Choose one of the following:
    • To create a dashboard with a list layout, go to step 3.
    • To create a dashboard with a set of dashlets, go to step 9.
  3. Use the drop-down control beside the Create button to select Create List Layout.
  4. In the Definition panel, configure basic properties for the dashboard:
    • Layout name: an internal name for this layout. This name cannot include spaces or special characters.
    • Display name: the name for this layout, as displayed within the EDA GUI. Unlike the layout name, you can include spaces in the Display name.
    • Description: an optional description of the layout and its purpose.
    • Show navigation toolbar?: governs whether a breadcrumb bar displays above the dashboard.
  5. Click on the list in the center configuration panel to reveal properties for the list in the Properties panel.
  6. Configure display properties for the list:
    • Show information panel
    • Show status bar
    • Show column filters
  7. Configure the source data for the list:
    1. Click the vertical dots icon beside the Query field to open a window in which to configure data source for the list.
    2. In the Data View Details window, use the first drop-down to select a source type for the dashlet's query:
      • EQL Query
      • Natural Language query
      • GVK Definition
      • URL Endpoint
    3. Use the second field to enter the query expression, or to specify the GVK definition or URL endpoint.
    4. Click Query to retrieve data associated with the expression you entered.
    5. Click Save.
  8. Go to step 20
  9. Click Create.
  10. In the Definition panel, configure basic properties for the dashboard:
    • Layout name: an internal name for this layout. This name cannot include spaces or special characters.
    • Display name: the name for this layout, as displayed within the EDA GUI. Unlike the layout name, you can include spaces in the Display name.
    • Description: an optional description of the layout and its purpose.
    • Show navigation toolbar?:
  11. In the Properties panel, configure screen properties for the dashboard:Screen Name:
    • Screen Name
    • Screen Type: This is set to Dashboard and cannot be altered.
    • Show screen in Navigation Bar?:
    • Default screen when layout is loaded?:
  12. Optionally configure one or more filters for this dashboard.
    Note: See the separate procedure for creating a dashboard filter for the steps to:
    • configure one or more dashboard filters
    • modify the queries underlying one or more dashlets to incorporate those filters
  13. Click the Library tab to configure the dashboard layout.
  14. Optionally, add rows and columns to the dashboard:
    Note: You can arrange dashlets on the dashboard even without creating rows and columns in advance; but configuring a grid gives you more control over dashlet positioning, and allows you to configure dashlets to span multiple cells in the grid arrangement.
    1. To add rows to the dashboard, drag the Flex Row control into the layout panel. Repeat this to add more rows to the dashboard.
    2. To add columns to the dashboard, drag the Flex Column control into the layout panel. Repeat this to add more columns to the dashboard.
    3. In the Properties panel, configure the flex row or flex column you added by setting the Vertical Alignment and Horizontal Alignment properties.
  15. Add a dashlet to the dashboard by selecting a Dashlet control from those displayed, and dragging it into the layout area. If you previously added rows or columns, drop the dashlet into the appropriate position.
  16. Click on the dashlet in the center configuration panel to reveal properties for the dashlet in the Properties panel.
  17. Configure the dashlet by setting:
    • Screen properties (these are common to all dashlets).
    • Dashlet properties (some are common to all dashlets; others vary by dashlet type).
    Note: See the topics for dashlet types for details about the individual parameters available for each type of dashlet.
  18. To configure the source data for the dashlet (among the dashlet properties):
    1. Click the vertical dots icon beside the Query field to open a window in which to configure data source for the dashlet.
    2. In the Details window, use the first drop-down to select a source type for the dashlet's query:
      • EQL Query
      • Natural Language query
      • GVK Definition
      • URL Endpoint
    3. Use the second field to enter the query expression, or to specify the GVK definition or URL endpoint.
    4. Click Query to retrieve data associated with the expression you entered.
    5. Click Save.
    6. Configure additional properties for the data, if they are available for your dashlet type.
      Note: For example, a Counter dashlet allows you to specify here whether the counter should display a total, total at end, percentage, or a vertical list of values.
  19. Repeat steps 15, 17 and 18 to add more dashlets to the dashboard if required, until all dashlets are configured.
  20. Do any of the following:
    • To save your dashboard, click the Save icon.
    • To add a new dashboard layout to your dashboard, click Add.
    • To add a new list layout to your dashboard, use the drop-down beside the Add control to select Add list Layout.
    • To preview your dashboard, click the More icon and select Preview Saved Changes from the list of actions.
    • To save your dashboard layout as a file, suitable for others to import into their EDA system, click the More icon and select Export from the list of actions.

Creating a dashboard filter

Filters allow you to constrain the data used by the dashlets on a dashboard. After you have configured filters, you can modify the underlying query of any dashlet on the dashboard to include a reference to one or more of those filters. When you specify a value within the filter field on the dashboard, those dashlets will then display only results that satisfy that filter.

For example, a dashboard which displays data for all TopoNodes can be filtered to display only data from a specific TopoNode you specify in the filter field.

At a high level, configuring and using filters involves the following steps:
  1. Configure one or more filters on the dashboard design page.
  2. For each dashlet to which a dashboard filter should apply, edit the dashlet's underlying query to include a "where" expression referring to one or more of the dashboard filters.
    Note: A sample of each filter's "where" expression is displayed on this page to help you with the correct syntax. A field also displays on this page for each dashboard filter, and you can test the filters by entering values in those fields.
  3. On the dashboard design page, enter values into one or more of the filter fields. All dashlets on the dashboard whose underlying query incorporates a filter then update to display only results that satisfy that filter.
The dashboard designer supports three kinds of filters:
  • String filter: allows you to add a simple string filter field. As part of each dashlet's query design, you specify a field within the data set against which the filter string is compared. The "where" clause for a string filter resembles where (<column> = "${StringFilter}").
  • Custom filter: allows you to create a specify a particular field among query results, whose value must match what is entered later as the filter value. The "where" clause for a custom filter resembles where (<column> = "${CustomFilter}").
  • Name/Namespace: constrains query results to only those associated with a particular name and namespace you enter later as the filter value.

    A Name/Namespace filter is like a Custom filter for which Name/Namespace is hard-coded as the selected filter field. The "where" clause for a Name/Namespace filter resembles where (<column1> = "${NNFilter.name}" and <column2> = "${NNFilter.namespace}")

For example, the following query includes a where clause referring to three different filters:
.namespace.node.srl.interface.statistics where (out-octets != 0 and in-octets != 0 and .namespace.node.name = "${nodename}" and .namespace.name = "${target.namespace}" and .namespace.node.srl.interface.name = "${custom}") delta milliseconds 250
After you have configured one or more filters, corresponding filter fields are displayed in the following places in the EDA GUI:
  • on the query configuration page for every dashlet within the dashboard. On the query configuration page you can add the filter expression to the dashlet's underlying query. Once the query includes the filter expression, you can test the result by entering filter values to immediately constrain the dashlet's underlying data set.
  • on the dashboard configuration page (if you enable their display). Entering a filter value here immediately impacts the data displayed in each dashlet whose underlying data set refers to the filter.
  • on the dashlet itself.

If a dashlet's Navigation Target is set to the Query Builder page, then filters can also have an effect on the query displayed on that page.

If you have configured filters for the dashboard, the filter widget displays at the top of the dashboard. Clicking the widget allows you to select a filter field; and you can then enter a value in that field to be applied to the query.

The query that is displayed on the Query Builder page includes the "where" clause but is content depends on whether you have applied any filters:
  • if you have applied no filters, the "where" clause is present, but all filter values are set to wildcards (*) so the filter has no effect.
  • if you have applied one or more filters, the filter "where" clause is present, and the filter values you entered are included within the query string and are applied to the displayed results.
  1. Click the + beside the Filters label.
  2. Select the type of filter you are creating in the Type list control:
    • to add a string filter: go to step 3.
    • to add a Name/Namespace filter: go to step 5.
    • to add a custom filter: go to step 7.
  3. Configure a String filter for the dashboard by doing the following:
    1. Enter a Name for the filter.
    2. Click Save.
  4. Go to step 8.
  5. Configure a Name/Namespace filter for the dashboard by doing the following:
    1. Enter a Name for the filter.
    2. Use the Query field to create a query that will generate the data set against which this filter will be applied. This query can be in the form of an EQL Query, Natural Language query, GVK Definition, or URL Endpoint.
      Note: The resulting data set must include the Name and Namespace fields. If those fields are not present in the data set, this filter will fail.
    3. While the focus is still on the Query field, press the Enter key to signal that you have finished configuring the query.
      Note: If you do not press the Enter key, the EDA UI will not recognize that the query is complete and you will be unable to proceed.
    4. Click Save.
  6. Go to step 8.
  7. Configure a Custom filter for the dashboard by doing the following:
    1. Enter a Name for the filter.
    2. Use the Query field to create a query that will produce the data against which this filter will be applied. This query can be in the form of an EQL Query, Natural Language query, GVK Definition, or URL Endpoint.
    3. While the focus is still on the Query field, press the Enter key to signal that you have finished configuring the query.
      Note: If you do not press the Enter key, the EDA UI will not recognize that the query is complete and you will be unable to proceed.
      Note: You may need to wait a moment for the system to finish resolving the query before selecting a field from the query results in the next step.
    4. After you have created the query, and the system has had a chance to resolve it and can identify the fields of data returned, use the Field list to select one of the fields within the resulting data set. The field you select here is the field against which the filter text you enter later is compared.
    5. Click Save.
  8. To apply one or more of the dashboard's filters to one of its dashlets, do the following:
    1. Select the dashlet and open its Details page to configure its underlying query.
      Note: On the Details page, a field displays for each filter you have configured for the dashboard. Beneath each filter field is a text template for a "where" clause that refers to that filter. Because the syntax for a "where" clause must be precise, these templates are a useful starting point for incorporating the filter in to the dashlet's query.
    2. Choose a filter and copy its template "where" clause text.
    3. Paste the template text to the appropriate position for a "where" clause within the dashlet query string.
    4. Edit the "where" clause so that it refers to a valid field within the query's data set.
      Note: Take care to ensure that the resulting "where" clause precisely matches the spacing and syntax of the template provided. Symbols and spaces must all be placed correctly. If there is any error in the formatting of the clause, the query will fail.
    5. Repeat steps b, c, and d to add more filters to the query if required. Be sure to precisely follow the correct syntax for multiple filters in a query.
  9. Repeat step 8 for every dashlet on the dashboard that should be subject to the dashboard's filters.
  10. To apply dashboard filters to the dashlets on the dashboard designer page, do the following:
    1. Enable the Show filters bar toggle on the dashboard designer page to display the filter fields on the dashboard designer page.
      The filters bar displays at the top of the dashboard's Layouts panel.
    2. Click the filter icon on the filters bar to display a list of available filters, and select a filter from the list.
    3. Repeat step b to display additional filter fields if required.
    4. Enter values into one or more of the displayed filter fields.
      All dashlets on the dashboard whose underlying queries refer to one of the filter values update to constrain their data to results matching the filter values.