Event property configuration

once an event has been configured, you can start configuring the properties of the event detection mode detection mode historian the historian detection mode works by getting the sampled calculations docid\ pfijxixgtlkcdqtblugdy value of a data reference for the time period of the event an event property is either simple or periodic a simple event property will return a single aggregated value a periodic one will return a list of periodically aggregated values for periodic event properties you will additionally need to define an interval priority the priority determines the order in which properties are evaluated within the same event properties with a lower priority number are evaluated before those with a higher priority number to ensure that ‘priority’ works effectively with ‘close after’, set an equal or longer ‘close after’ period for properties with a higher priority number note that priority only affects the order of execution for open properties a property with a higher priority number can retrieve a value earlier and close before a property with a lower priority number start/stop offset will apply an offset on the start/stop time of the event when getting the value(s) for this property close after the “close after” period refers to the additional time allowed beyond the event stop time during which the event processor will continue attempting to retrieve a value if none is found this is useful in cases where the data may be delayed or not immediately available default value default value that is used if there is no data available preview to be able to see the properties for an ongoing event you can enable a preview for an event property this will periodically update the property before getting finalized when the event closes good points only by default, only points with a status of good will be used, this option can be disabled to include points without a status or a bad status detection mode manual when selecting the manual detection mode, the event property will be completed by manual entry you can optionally configure a list of predefined values in the section possible values under settings this offers the possibility of mapping certain values to a more human friendly display name in the manual entry form to add such a mapping enter the “friendly” name of the value in the input field add value and click + icon next to it then enter the value that should be stored in the database below we have an example configuration where we map a number property color to their corresponding colors if the datatype of the event property is a string, you can also configure validation for manual entry this can be done by entering a regular expression in the validation field if the entered value does not match the regular expression, the manual entry form will show an error message detection mode historian advanced the historian advanced detection mode provides advanced capabilities for realigning and resampling data based on an additional measurement dimension (for example, a spatial coordinate or process parameter) this mode is particularly useful when sensors are positioned in different locations or capture measurements from varied perspectives as a result, at any given timestamp, each sensor might record data corresponding to different points along a common dimension using this mode, you can align the data to a unified reference and resample the measurements at consistent intervals along that dimension (e g , every 10 cm) example scenario imagine an extrusion process with the following measurements length measurement source a metering device at position 0 m on the extrusion line timeseries extruder 1\metering\length frequency every second thickness measurement source a sensor located at 1 2 m from the start timeseries extruder 1\thickness sampling rate every 10 seconds associated dimension a measurement indicating the sensor’s perceived length, available as extruder 1\thickness\length cut event measurement extruder 1\metering\cut role defines the start and stop of the extrusion event using historian advanced, you can align the thickness measurement with the length measurement and resample it at intervals (e g , every 10 cm) configuration walkthrough before starting, ensure you have already created an event type extrusion with a property length representing the extruded product’s length an event configuration for asset extruder 1 that uses the extruder 1\metering\cut measurement to define event boundaries follow these steps to configure an event property that captures the thickness at every 10 cm along the extrusion select event type navigate to events → event types choose the event type extrusion add a new property click add property name the property (e g , thickness by length) set the property type to periodic with dimension configure the asset go to assets and select asset extruder 1 for the new property, choose the detection mode historian advanced define the input timeseries measurement extruder 1\thickness aggregation mean interval 1 second (this input will be realigned and resampled ) define the reference (dimension) timeseries measurement extruder 1\thickness\length (this timeseries represents the dimension along which the input data will be resampled ) set resample interval enter a dimension resample interval of 0 1 (representing 10 cm) enable realignment activate the realign on dimension option choose a realign strategy select the start strategy to ensure that the first resampled thickness value corresponds with the first value of the length measurement specify the offset source as extruder 1\metering\length (this setting ensures that the thickness data aligns with the reference length measurement ) detailed explanations dimension data reference the dimension data reference is a simple timeseries that defines the measurement dimension (e g , length) its values must be monotonically increasing or decreasing during the event this reference is used to both resample and realign the input data this measurement represents the dimension seen in the perspective of the input data for example, if the input data is a thickness measurement, the dimension data reference could be the length of the extruded product as seen from the thickness sensor resample by dimension the resample by dimension option allows you to resample the input timeseries at specified intervals along the dimension timeseries the interval is set in the dimension resample interval field the resulting periodic property will have a value for each interval (e g , every 10 cm) for input timeseries with numerical data, the resampled value will be linearly interpolated between the two nearest values for input timeseries with string or boolean data, the resampled value will be the closest value from the input timeseries realign on dimension this option shifts the timestamps of the captured data so that they correspond to the reference timeseries’ domain for example, if the dimension timeseries represents the length of an extruded product, the realigned data will match the positions indicated by that length measurement realign strategy overview use the realign strategy to synchronize data based on a dimension timeseries the strategy locates timestamps by finding the dimension value closest to (and not exceeding) a reference, then anchors the data to either the start or stop of the event the total duration remains limited by the event’s overall start and stop times strategy when to use how it works start if you need the first data point to align with a specific dimension value example the dimension is 0 m at the start, but your sensor reads –1 2 m at that actual start historian finds the timestamp of the dimension value ≤ the desired reference that becomes the start point, capturing data until the event ends stop if you want the final data point to match a certain dimension value example the dimension timeseries ends at 10 m, but the sensor runs up to 11 2 m historian finds the timestamp of the dimension value ≤ the desired reference that becomes the end point, capturing data from the event start up to this stop point examples start strategy if extruder 1\length spans 0 m to 10 m, and extruder 1\thickness\length spans –1 2 m to 8 8 m, selecting start ensures 0 m in the sensor timeseries aligns with the event’s start stop strategy if extruder 1\length spans 0 m to 10 m, but extruder 1\width\length spans 1 2 m to 11 2 m, selecting stop ensures 10 m in the sensor timeseries aligns with the event’s end offset source the offset source configuration determines which data is used to realign your timeseries data based on the dimension timeseries it can be configured as either a simple timeseries that represents the dimension values of that event (e g , a length measurement for the event), or a simple property of the event that has the value of the start or end dimension value key requirements the offset source must be numeric ; it should either be a numeric timeseries or a simple property with a number datatype example if using the start strategy, the offset source could be the length measurement of the extruded product ( extruder 1\length ) or a simple property of the event that represents the start position of the extruded product detection mode external database the external database detection mode works by querying the external database for either a single value in the case of a simple event property, or a series of rows containing a timestamp in the first column and a value in the second column for a periodic event property you can add query parameters in the options to constrain the data being returned the query parameters can consist of the start time or end time of the event or the value of another simple property for that event for simple properties we also support the preview enabled option in cases where the query may occasionally yield no data, you have the option to specify a ‘default value’ to be applied in such instances given the following database table and configuration items created name time value batch1 2023 09 01 00 01 15 batch2 2023 09 01 00 01 20 batch1 2023 09 02 00 01 6 configuration the result for an event with start time 2023 09 01 00 00 00 and stop time 2023 09 01 03 00 00 with batch id = batch1 would be 15 and the executed query would have been select value from items created where time > '2023 09 01 00 00 00' and time < '2023 09 01 03 00 00 with' and name = 'batch1' and example table and query (script) for a periodic property would be ph samples name time ph sample batch1 2023 09 01 00 20 4 batch2 2023 09 01 00 20 5 batch1 2023 09 01 01 00 6 batch2 2023 09 01 01 00 3 batch1 2023 09 01 01 20 7 batch2 2023 09 01 01 20 7 batch1 2023 09 02 01 01 8 batch2 2023 09 02 01 01 4 script (query with parameters) select time, ph sample from ph samples where time > '2023 09 01 00 00 00' and time < '2023 09 01 03 00 00 with' and name = 'batch1' would result in a periodic value for the previously mentions timestamp of offset (in seconds) value 1200 4 3600 6 4800 7 re evaluation of event properties by selecting an event property configuration and pressing the re evaluate button in the top right corner, all event properties for that event property configuration will be re evaluated for the chosen time period