Pablo Benvenuto

Learning Labs - Production Level Report Part 2

Discussion created by Pablo Benvenuto Champion on Sep 14, 2012
Welcome to the second part of this Learning Lab.  How did it go in Part 1? OK?  Let me show you now the step by step solution.

Retrieving Sampled Data for a Daily Report

1. Open the template.
2. Select cell A12.
3. On the Ribbon, Click PI > Sampled Data.

pic1.png

4. In the task pane, make sure the PI Tag radio button is selected.
5. In the task pane, click in the Tagname field.
6. Click on cell B4.
7. In the task pane, click in the Start Time field.
8. Click on cell B5.
9. In the task pane, click in the End Time field.
10. Click on cell B6.
11. In the task pane, click in the Time Interval field.
12. Click on cell B7.
13. In the task pane, click in the Filter Expression field.
14. Click on cell B10.
15. Check the mark as filtered check box.
16. Check the show timestamps check box.
17. Click on the OK button.

pic2.png

18. Select all of the cells that contain data in column B, in my case it is the range B12:B37.
19. On the Ribbon, Click Home > Conditional Formatting > Data Bars > Blue Data Bar. You should have a data area scaled with blue bars.

pic3.png

20. Click on Conditional Formatting > Top/Bottom Rules > Top 10%...
21. Click on the OK button.
22. Click on Conditional Formatting > Top/Bottom Rules > Bottom 10%...
23. Change the number to 20%.
24. Click on the OK button.

pic5.png

You should now have a really nice Production Level Report.  Change the Upper and Lower limits in cell B8 and B9 to see the data updated.

Did you know that you can also see a completed solution in the OSIsoft Virtual Learning Environment.  It is found in C:\Labs\Visuals\Production Level Report\Solution.  To learn more about the OSIsoft Virtual Learning Environment, click here.

Outcomes