The Sheet view displays the selected data as a spreadsheet. You can display all or some of the data and you can sort the data in each column by clicking the column name. The columns can be repositioned and re-sized by left-clicking the edge of the column and dragging to the desired position. You can select one or more transactions for more detailed analysis, and view the new selection in a new Sheet view.
The Sheet view is shown in the following screen capture. The view tab shows that the source for the data is the sample CSV file sample.csv. The information line below that tab shows the selection criteria, in this example, the APPLIDs that are selected and the date and time range.
The Sheet view shows all the data fields in the selected data source, however because of the amount of data, it is not always easy to identify out-of-line situations. By making use of the sort facility or selecting different APPLIDs or transaction IDs, you can reduce the data selection for further analysis.
When you have selected a subset, right click the selection, click Performance history, and select one of the report options to analyze the data further.
The context menus in the Sheet view are based on the type of record you are displaying. If you are looking at a Performance Summary record you can use the Performance History link to access more views on that data. If you are viewing statistical data you can use the Link menus to view records that share certain parameters and attributes thereby linking statistical records.
When you enter a Transaction ID the sheet view is not updated until you select the transaction ID.
The performance history works primarily from the performance summary rather than statistics tables. However, you can access performance history records from the Reports view or other perspectives (for example CICS IA).