Use the analog Tag Analysis wizard

Use the Analog Tag Analysis wizard to generate graphs and statistics for an analog tag.

To analyze an analog tag:

1. On the Historian tab, in the Tag Management group, click Tag Analysis. The Tag Analysis dialog box appears.

2. Select Analog tag analysis.

3. Click Next. The Tag Analysis - Step 2 of 5 dialog box appears.

4. In the Servers list, click the name of the server to use.

5. In the Analog tag list, specify the name of the tag to analyze. Click the ellipsis button to open the Tag Picker and browse for the tag. For more information, see Tag Picker.

6. Click Next. The Tag Analysis - Step 3 of 5 dialog box appears.

7. In the Starting time list, enter the starting time for a query. Click the arrow button to select a date from a calendar.

8. In the Duration lists, specify the duration and the duration unit. For example, 10 minutes. The duration is used to calculate the end date for the query.

9. Click Next. The Tag Analysis - Step 4 of 5 dialog box appears.

10. Configure the resolution for the data to be returned.

    • Number of rows: The number of rows to be returned for a specified time period using cyclic retrieval. The rows are spaced evenly across the time period, and the default row count is 50 rows. The row count is applied for each tag in a query.

    • Values spaced every: The sampling rate, in milliseconds, for retrieving the data in cyclic mode.

11. Click Next. The Tag Analysis - Step 5 of 5 dialog box appears.

12. Select the analysis options to include.

    • Plot trend (tag vs. time): If selected, the value of the tag over time will be plotted in a trend chart.

    • Statistics: If selected, tag statistics will be included in the output.

    • Pie graph: If selected, a pie graph will be created.

    • Limit 1: The highest limit as was configured in InTouch. If no InTouch limits are set for the tag, then this value is equal to the maximum engineering unit.

    • Limit 2: The lowest limit as was configured in InTouch. If no InTouch limits are set for the tag, then this value is equal to the minimum engineering unit.

    • Minimum: The minimum value for the tag.

    • Maximum: The maximum value for the tag.

    • Average: The average value for the tag.

    • Sum: The sum of all values for the tag.

    • Range: The difference between the maximum and the minimum value for the tag.

    • Standard deviation: The statistical standard deviation of all values for the tag.

    • Resolution: The sampling rate for retrieving the data that is used for calculating the aggregations (Minimum, Maximum, etc.)

13. Click Finish. Information that you specified using the wizard is assigned to cells in the worksheet. For example:

    

    In this particular example:

    A1: Server

    A2: Tag

    A4: Row or resolution

    A5: Start Time

    A6: Duration

    A7: Low Limit

    A8: High Limit

    Note: The assignments are not absolute and may change in future releases.

14. Click in the Workbook to view the functions that are inserted to create the analysis report.

    In this example, click in the following cells to view the functions.

    Cell C2:

    =wwAnalogWideHistory(A1,A2,"Row" & A4,"Rel",A6 & "(" & A5 & ")",FALSE," ",TRUE,FALSE)

    each results cell for the aggregation column (column F):

    For delta stored tags, the resolution you specified in the wizard is used:

    =wwAggregateWide(A1,A2,"Res60000","Rel",A6 & "(" & A5 & ")","Min","")

    For cyclic stored tags, the storage rate is used as the retrieval resolution:

    =wwAggregateWide(A1,A2,"ResFull","Rel",A6 & "(" & A5 & ")","Min","")

15. Optionally alter the results by changing values that appear in the first column of the worksheet.

    If the calculation mode is set to automatic, any changes you make to the values in this column are immediately reflected in the worksheet.

    Note: If you change the resolution and/or duration, this may change the cells that are referenced by the graph and statistics.

    For example, you can change the tagname from ReactLevel to ReactTemp.

    

    Change the limits to the correct limits so that the statistics and trend chart reflect the data.

    

    The information for the analysis headings and units is stored in cells outside of the maximum range for a formula array. To see this information, scroll down in the worksheet to near row 6000.

    

    You can also change the duration in column A1 and watch the data in the report change.