Generic filters
Exact matches only

Alert Users When Data Becomes Stale

Having real-time data is important for making the right decisions at the right time. What happens if your KPIs show data that appears valid but is actually out of date or stale? Visual KPI has a way of automatically changing the status of a KPI to ‘Stale’ and alerting users when data has not been updated for a certain period of time.

Visual KPI has a Stale status that indicates a KPI has not changed over a predetermined period of time.

 stale status

In List View, Stale status is indicated by the Stale icon () and color assigned to Stale status (see Set default Stale status attributes below).

The Stale status works by using a time offset in minutes (default is 60 minutes). Every time your data is updated, if the actual value is returned with a timestamp older than 60 minutes (the default), the status will change to Stale (including the status icon and color). You can customize the time (in minutes) for Stale status to activate for your entire KPI site or for individual KPIs.

stale status

In KPI Map view, Stale status is indicated by the color assigned to Stale.

Change default Stale status time

The default status can be set sitewide and will affect all KPIs, unless you override individual KPIs.

Using Visual KPI Designer, click the Sitewide Settings configuration icon () and select Features & Config/Website.

sitewide settings Website

The Website settings worksheet is then added to the workbook. If it already exists in the workbook, the Website configuration worksheet is activated and the current configuration data is retrieved from the database and displayed.

Under the KPI Settings section, set the KPI Stale Age (in minutes) to the time that should elapse before a KPI becomes stale (no recent data received). The time is offset (in minutes) to return a Stale status if the most recent timestamped data returned is older than the offset time.

alert users when status becomes stale

Example: The pressure of an active boiler should return a value every 15 minutes. If Visual KPI doesn’t receive another value for this KPI from one or more of the associated data sources within 60 minutes, the data is considered stale and the KPI status will be set to Stale (and an alert will be sent if configured).

Note: Don’t forget to save the Visual KPI worksheet.

Set default Stale status attributes

Using Visual KPI Designer, you can manage or override the default settings for any status, including Stale status. Learn more

alert users when status becomes stale

Alert users when data becomes stale for an individual KPI

In the KPI worksheet in Visual KPI Designer, all KPIs will have a Stale Age of Default unless it has been changed. This Default time offset means it will follow the sitewide setting (as described above). You also have the ability to override this time offset for any individual KPI.

Open the KPI worksheet in Visual KPI Designer.

Under the User Experience section of attributes, enter a KPI Stale Age (in minutes) for one or more KPIs.

alert users when status becomes stale for individual KPIs

To reset the KPI Stale Age to default, use the drop-down menu and select Default.

Save the worksheet.

Turn OFF or disable Stale status for any or all KPIs

By default, all individual KPIs are set to 60 (minutes) sitewide. To disable the Stale status, set the KPI Stale Age (time offset) to 0 (minutes).

  • To disable Stale status for all KPIs sitewide, set KPI Stale Age to 0 in sitewide settings.
  • To disable Stale status for individual KPIs, set KPI Stale Age to 0 next to an individual KPI in the KPI worksheet.


Contact us if you need help!

Learn more

Create & Configure KPIs
Configure KPI Status Options, Colors and Icons



Was this article helpful?

Related Articles