Result
Understand how to add event context to a measure and add the measure to an Event-based table chart.
Tutorial steps
- Create a new Measure to count the total good production of Filler 1
- Add Event Context to the newly created measure
- Add the measure to the Event-based Table Chart
Let’s go back to your "Packaging Event Report", wouldn’t it be useful if you could add additional columns to your report?
Let’s see how we can do this with new measures. Set your Measure Defaults to "Tag" with a format of "0" (i.e. no decimal places).
Locate the "FL001.BottleCount" tag in your Historian, drag it across to the "Filler 1" Metric and rename it to "Good Production".
Now drag the "FL001.BottleCount" Flow Tag that you just created and drop it onto the Hourly interval type on the Flow Zone to create an hourly Measure. Name this measure "Good Production". Open the Measure Editor by double-clicking on the "Good Production" hourly measure. Set its retrieval aggregation method to "Counter".
Before you deploy your new measure, expand the "Context" section, and drag the "Filler 1 Run" Event into it ...
Now deploy the new measure.
Let’s discuss what you have just done. By adding the "Filler 1 Run" Event into the "Context" of the new measure, you have told Flow to "overlay" the time period information from the measure AND the event period information from the event. Flow effectively "slices" the overlaid time and event period information, allowing you to present it from different perspectives (or dimensions).
Let’s add this measure to the Event Report you created earlier. Open the "Packaging Event Report", expand the "Filler 1" Section and drag this new "Good Production (bottles)" measure onto the "Filler 1 Run" event. Set its "Title" property to "Good Production" …
Refresh your "Packaging Event Report" and notice the additional column of information …