Pablo Benvenuto

Learning Labs - Production Level Report Part 1

Discussion created by Pablo Benvenuto Champion on Sep 14, 2012
In this Learning Lab you will create a report and learn how to use the Filter Expression option of the Sampled Data function to constrain the values that are extracted.  You will also combine PI values with Excel conditional formatting for more intuitive reports.

Let’s say you are a quality control manager and you want to examine the tank level of product over the last 12 hours for a tag that does not report many values due to its lack of volatility, and thus it has a high compression rate on the PI Sever. Since there are only a few values passing through the compression test, it is better to perform a Sampled Data query rather than a Compressed Data query.

The tag you will use is SINUSOID. You want to build a report that will filter out mean tank levels, which is defined as a level between 30 and 80. You want to use red conditional formatting to know the times of low product level, defined as the lowest 20% of values, which should be highlighted in red. For all values returned, data bars should be used to visually show the overall level of the product in the tank. Then change the upper and lower limits to 75 and 25, respectively, to test your report.

We will use the PI DataLink Sampled Data function to get evenly spaced data. Since we only want to see data that are outside of the norm, we will apply filters to show high values, low values, and a list including both.

Final Production Level Report with Conditional Formatting

The template for this exercise can be downloaded from here.  I will be using the OSIsoft Virtual Learning Environment for this exercise and the template is located in C:\Labs\Visuals\Production Level Report\Workspace.  This is what the final report should look like:


Do you think you can do it on your own?  Give it a shot, or go to Part 2 to see the step by step solution.


Check out the PI DataLink Workshop Outline.
You can watch this Learning Lab in video format below.