Skip to content

GridProtectionAlliance/GrafanaTemplates

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

14 Commits
 
 
 
 
 
 
 
 

Repository files navigation

openHistorian Grafana Data Source Templates

References

Have a dashboard you would like to share? Create a pull request to get it added!


Note: When clicking links to download JSON files, the GitHub file preview page will be shown with the JSON text. To the right above the file, to the right of the button labeled "Raw" and left of the button with an image of a pencil, there is a download button. Click this button to download the JSON to your local system. For example:

Click Download Button


ExceedsAt Threshold Dashboard

Download Template: ExceedsAtThreshold.json   >   Author: J. Ritchie Carroll / Grid Protection Alliance

This dashboard serves as a real-time threshold monitoring tool, designed to track and visualize when a specific metric exceeds or falls below a predefined threshold. It highlights threshold breaches on a dynamic time-series graph, marking exceedance points and return-to-normal points for clarity. A detailed log provides timestamps and durations of these breaches, enabling users to pinpoint critical events. Additionally, exceedance durations are categorized visually, helping to identify trends or patterns over time. This functionality is particularly useful as a template for monitoring systems where deviations from expected values are significant, such as quality control, anomaly detection, or performance monitoring.

img

Noteworthy Dashboard Details

Dashboard defines threshold and query editable variables. All panels use the same query via the query variable. The "Time series" panel defines four queries:

Label(Freq, ${query});
Label(Exceed Points, ExceedsAt(${threshold}, ${query}));
Label(Falls Below Points, ExceedsAt(${threshold}, true, ${query}))
Label(threshold, eval(1, { ${threshold} }, ${query}));

Overrides for "Exceed Points" and "Falls Below Points" define "Graph styles > styles" as "Points". To define dashed threshold line based on editable threshold, eval query exposes threshold value as a series with a constant value, overriding "Standard options > Color scheme", "Graph styles > Fill opacity", "Graph styles > Line style", and "Series > Hide in area" hiding "Tooltip" and "Legend".

The "State timeline" panel includes both start and end reports from the ExceedsAt function and reports duration instead of values. The label includes special Unicode blank characters to align panel's time axis with time series panel above:

Label('͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏͏ ͏', ExceedsAt(${threshold}, false, true, true, ${query}));

About

openHistorian Grafana DataSource Templates

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published