Use the Discrete tag analysis wizard

Use the Discrete Tag Analysis wizard to create graphs and trends, calculate statistics, and return configuration information.

To analyze a discrete tag:

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

2. Select Discrete 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 Discrete 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 the 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. 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.

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

12. Configure the analysis options.

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

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

    A4: Row or resolution

    A5: Start Time

    A6: Duration

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 B2:

    =wwDiscreteWideHistory(A1,A2,"Res" & A4,"Rel",A6 & "(" & A5 & ")","",TRUE,FALSE)

    Cell H2 (time in state)

    =SUMIF(C2:C11, "0",D3:D12)

    Cell H4 (number of transitions)

    =COUNTIF(C3:C12, 0)

    Columns E and F contain both transitions for each of the dates in Column B.

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.

    For example, change the tagname to SysPulse. You must refresh the function for columns B and C.

    

    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.