Use the Batch analysis wizard

Use the Batch Analysis wizard to graph one analog tag over two time periods.

To create a batch analysis:

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

2. Select Batch analysis.

3. Click Next. The Tag Analysis - Step 2 of 4 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 4 dialog box appears.

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

8. In the Starting time for second time period list, enter the starting time for the second time period. Click the arrow button to select a date from a calendar.

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

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

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

    • Number of rows: The number of rows to be returned for a specified time period. For cyclic retrieval, the rows are spaced evenly across the time period, and the default row count is 50 rows. For cyclic retrieval, 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.

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

    

    In this example:

    A1: Server

    A2: Tag

    A3: Start Time 1 Chart Legend

    A4: Row or resolution

    A5: Start Time

    A6: Duration

    A8: Start Time 2 Chart Legend

    A9: Start Time 2

13. 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,"Res" & A4,"Rel",A6 & "(" & A5 & ")",FALSE," ",TRUE,FALSE)

    Cell E2:

    =wwAnalogWideHistory(A1,A2,"Res" & A4,"Rel",A6 & "(" & A9 & ")",FALSE," ",TRUE,FALSE)

14. 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.

    For example, decrease the resolution and time period by 50%.

    Note: If you reduce the resolution by half, but do not adjust the time range (duration), only half of the time is reflected in the trend chart. If you want to make changes to the input parameters that affect the total number of returned rows, you must modify the chart to reference the new cell ranges. You must also refresh the worksheet functions.