Trending
Trending with the Factry Histo...
Trending Event Periodic Properties
periodic properties let you analyze how process values behave during recurring events, such as batches, shifts, or machine cycles instead of simply trending data over absolute time, you can align multiple runs of the same event type and compare their performance in one overlay trend panel with periodic properties an overlay is a visualization where values from different events are plotted on the same relative time axis (time since the event start) this makes it easy to spot variations in process behavior between runs prerequisites before displaying events in grafana, ensure configuring an event docid\ e9bjftgiz2m1bxqppz3qx in factry historian configuring the factry historian datasource plugin for grafana docid\ q9t7hxoxsknylawporfdd is correctly set up in grafana to learn more about events , consult the concepts documentation why use the factry datasource for periodic properties? the factry grafana datasource is designed to work seamlessly with periodic properties it allows you to use out of the box overlay visualisation in grafana without custom queries plot relative time since the start of the event on the x axis, so multiple runs align at “time zero ” show the range of property values (e g temperature, pressure, flow) on the y axis, making run to run variations clear time zero the reference point marking the start of an event all measurements are shown relative to this moment, so multiple runs can be aligned and compared default usage to display periodic properties of events as overlays, either create a new dashboard or use the explore functionality open or create a new trend panel in grafana select the factry historian datasource plugin as the data source if it's not selected by default, then select the events tab select periodic as the query type select an asset (with events configured on it) from the asset tree by clicking the assets field select the event type from which you would like to visualize periodic properties select the event's periodic properties from the properties field optionally filter on status (e g only processed events) optionally include a viewing event properties as a table docid\ h6ybvqvqpr4v1m xxdnpo optionally include simple properties from parent events grafana will align the data on the relative time axis and draw multiple runs on top of each other for easy comparison filtering overlays by event values filters help you narrow down overlays so operators only see the events or assets they care about filter by asset → use the assets field in the query editor filter by other event values → use the where clause syntax examples where batchid = '12345' where product in ('pils', 'ipa') see the docid\ h6ybvqvqpr4v1m xxdnpo article for more details on filtering configuring display names in grafana when you overlay multiple runs, the legend should clearly identify each line configure this in the panel overrides under display name you can build custom labels using field variables from the dataset common variables ${ field displayname} → field name with labels ${ field name} → just the field name ${ field labels \<labelname>} → the value of a specific label (e g asset or batchid) ${ field labels} → all label key–value pairs combined step by step edit panel → open the panel you use for overlays go to overrides (right sidebar) click add override choose a matcher fields with name → select a specific series/field by its current name fields with regex → target multiple series that match a pattern all fields → apply to every series in the panel click add property → search for display name (under standard options ) paste your template (e g the example below) apply / save the panel if your override doesn’t seem to apply, check the matcher field names may change after transformations/aggregations use fields with regex to match more robustly example this automatically produces legend entries such as using grafana variables to populate dropdown lists you can also connect filters to grafana variables (e g dropdowns), so users can dynamically select which batch, product, or asset to display troubleshooting wrong panel type symptom your overlay appears as a standard time series chart cause you’re using the time series panel , which plots absolute time instead of relative time fix switch the panel type to trends to correctly display overlays