Create indicators for query conditions

Query conditions are one of the data sources used to collect data for the treemap.

  1. Navigate to Business Services > Administration > Indicator.
  2. Click New.
  3. Complete the form using the following table.
    Field Description
    Name* Name of the new indicator.
    Category* Select the category with which you want this indicator to be grouped. For example, the out-of-box indicators for availability are grouped under the category Operation, while indicators for inherent and residual risk scores are grouped under the Risk category.
    Direction* Options are Minimize or Maximize. Choose the direction that is considered a positive change for the indicator. If the goal of the indicator is to Minimize the score, then large value scores will have larger tiles. The reverse is true for Maximize. For example, the goal of Risk is to minimize the risk, so the direction is set to minimize so that higher risk scores appear more prominently in larger tiles.
    Note: This field only appears if Data Source is set to Custom Script or Query Condition.
    Result Limit* Defines the maximum number of results allowed. The upper limit is 100.
    Result Precision* Select the number of decimal digits to display in the scores for the indicators.
    Note: This only appears if Data Source is set to Custom Script or Query Condition.
    Automatic Refresh Interval Used to identify the refresh frequency for the treemap.
    Active If this check box is not selected, the indicator does not display in the treemap.
    Order The order that an indicator appears in the drop-down menu and list for a particular category. The order must correspond to the order value of the category to which you want the indicator to belong. For example, if the category order is 100, then the indicator order would start at 100 and increase to 101, 102, and so on, incrementally.
    Data Source Defines the location from which this indicator receives data. The following options are available.
    • Performance Analytics, which populates the treemap with the scores from indicators created in Performance Analytics. Indicators must be created in Performance Analytics prior to being created as an indicator in Service 360.
    • Custom Script, which allows you to write a script that collects data from another application to display in the treemap. Custom scripts only display on the treemap, and are not shown on the Service 360 dashboard.
    • Query Condition, which allows you to select a table to run filters on to obtain data to display in the treemap. Results from the query conditions only display in the treemap, and are not shown on the Service 360 dashboard.
    PA indicator* Select the indicator from Performance Analytics that is to be displayed on the treemap.
    Note: This field only appears if Data Source is set to Performance Analytics.
    Default Breakdown* Select the default breakdown that determines how the indicator is displayed. In the case of Service 360, the default breakdown is Business Service so that the indicator displays the scores for each business service in the system respectively, if the data is available.
    Note: This field only appears if Data Source is set to Performance Analytics.
    Custom Script* HTML editor that allows you to create and customize the script.
    Note: This field only appears if Data Source is set to Custom Script.
    Query Table* Source table to be queried.
    Note: This field only appears if Data Source is set to Query Condition.
    Aggregate Type* The function to apply when calculating the score for a query on the query table. Possible values are Count, Sum, Average, Minimum, or Maximum.
    Note: This field only appears if Data Source is set to Query Condition.
    Aggregate Field The field on the Query Table on which the Aggregate Type is run.
    Note: This field only appears if Data Source is set to Query Condition.
    Group by* Select the field to sort the queried data.
    Note: This field only appears if Data Source is set to Query Condition.
    Query Conditions As needed, set filter conditions to enhance the query.
    Note: This field only appears if Data Source is set to Query Condition.
    Click Through URL Navigation Type This feature enables the treemap to drill-in to another display when a tile on the treemap is selected. For Service 360, when a tile is selected you are re-directed to the Service 360 dashboard in Performance Analytics. There are three options: New Window, Current Window, or Modal Dialog.
    Click Through URL Script Edit the sample script using the HTML editor to customize the URL that you are re-directed to when a tile on the treemap is selected.
    Important: Ensure that the Data Source field is set to Query Condition. Additional fields display at the top of the form and beneath the Data Source field. Complete the query as appropriate.
  4. Click Submit.