107 views

Description

For example, if there are two indicators:

  1. Number of open incidents > 30 days
  2. Number of open incidents

This can lead to errors, such as "Time series with sys_id 30 days is missing. The time series might have been deleted":

or "Invalid Insert":

Steps to Reproduce

Full steps to reproduce (depends on OOTB indicator 'Number of open incidents'):

  1. Create an automated indicator 'Number of open incidents > 30 days', with:
    • Direction: minimize
    • Unit: #
    • Source Tab: Indicator Source = Incidents.Open, Aggregate=Count, Value when nil=0, Collect records=true
    • Additional Conditions Tab: Add the condition = Opened relative before 30 days
    • Access Control Tab: Publish on Scorecards = true
  2. Save
  3. Edit the Breakdowns are add: State, Priority, Assignment Group, Assigned To
  4. Edit Jobs and add: [PA Incident] Daily Data Collection, [PA Incident] Historic Data Collection
  5. Save
  6. Create a formula indicator '% of open incidents > 30 Days Old', with:
    • Direction: minimize
    • Unit: %
    • Key: true
    • Formula : ( ([[Number of open incidents > 30 days]]) / [[Number of open incidents]] ) * 100 || 0
    • Access Control Tab: Publish on Scorecards = true
    • Other: Default Time Series = 'By week AVG', Apply time series to results = true
  7. Save

    Should see the errors:
    • This default time series has been excluded or is not valid given Frequency and Unit of this indicator
    • Invalid insert
    • Time series with sys_id 30 days is missing. The time series might have been deleted.

Workaround

One of the indicator names needs to be altered so that the conflict is not triggered.

For example, 'Number of open incidents' could be modified to:

Number of open-incidents


Related Problem: PRB1085754

Seen In

There is no data to report.

Fixed In

Kingston

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-10-12 06:20:19
Published:2018-10-12