Build a PV Grid with Tag Aggregates

Purpose: Learn how to use the PVGrid to show current values alongside aggregates for a set of tags.

Task: Build a grid that shows the following information for three tags: description, current value, time average over last hour, time average from start of current production day to now, and time average over last full production day.

Steps:

1. Add a PVGrid to the canvas.

   

2. Resize the grid. Add three more rows and four more columns.

   

3. Widen the first column, then switch it to fixed width mode.

   

4. Hold Shift, then click and drag from the top left cell to the bottom right cell to select all of the cells.

   

5. Use the font alignment tools on the Edit tab to center the text in the cells.

   

6. Double-click in the grid to make it the active layer (notice orange border).

   

7. Double-click the text within a cell to edit it. Make the following column headers: TAG, CURRENT, LASTHOUR, TODAY, LASTDAY.

   

8. Open the Tag Browser and choose three tags. For each tag, add it to every column within a row.

   

9. For the text blocks in the Tag column, change the Value Type to Description.

   

10. For the text blocks in the LastHour column, change the Read Mode to Aggregate FromNow. (Remember to expand the UTag section at the top). Leave the Aggregate and Read Span with their default values to get a time-weighted average over the last hour.

    

11. For text blocks in the Today column, change the Read Mode to Aggregate FromPeriod. Change the Period Type to Production Day (note: the Production Day period type must be configured in System Configuration). Leave the Period Offset at 0 to see the time-weighted average from the start of the production day up until now.

    

12. For text blocks in the LASTDAY column, change the Read Mode to Aggregate FromPeriod. Change the Period Type to Production Day. Change the Period Offset tot -1 to see the time-weighted average over the last full production day.

    

13. Click Run to test.