What is the easiest way to show just the percent good data of a pi tag in PI DataLink? When I use the check box I get an array and can’t make changes to the array, like dragging the cell down to cover different days.
An option is to use the Archive Value function with a Performance Equation expression that involves the PctGood function. For instance, if you want the percent good of tag sinusoid for yesterday, you can use the following parameters:
Daniel thanks for the help,
How would I reference different times from cells in excel in the PctGood('CoolTag', starting time I want to use excel cell, ending time I want to use excel cell) ?
A slightly less complicated Excel formula to build the PE would be to use excel's text function to automatically format the time. This gets you the date in the proper format with only 1 command and eliminates the need to use the vlookup function and the table for the months. An example of what the formula would look like for the 1st row of Danial's example spreadsheet is below. This option also allows you to specify the start and end times down to the minute if needed.
=CONCATENATE("PctGood('sinusoid', '",TEXT(A2,"dd-mmm-yy hh:mm"),"' , '",TEXT(B2,"dd-mmm-yy hh:mm"),"')")
Peter's suggestion is a good one for people who keep Windows regional settings in English.
I wish either Excel's TEXT function allowed users to specify a locale different from Windows regional settings or the internal PI time format (used in Performance Equations) supported languages other than English... :)
Retrieving data ...