If you use the TimeWatcher option of the EveryStep Scripting Tool to measure the execution time of some parts of your load testing script, you can use your load test Session Log to pull statistics on the TimeWatcher results. For example, you can calculate the average of the login step execution times measured during all sessions executed within the test. In this article, we will learn how to use your load test report data to gather required TimeWatcher statistics.

If you need more details on how to set up the TimeWatcher option, please see the Time Watcher article.

Generally, you can find your TimeWatcher results for a specific test session in the session details. To see step execution times registered by TimeWatcher, open your Load Test Report and go to the Log tab. Here, you can open an in-depth session report by clicking the details link in the corresponding line of the session list. Please check the Load Test Session Details to learn how to use the session report for load test analysis.

The TimeWatcher results will be provided in the request descriptions, as shown below.

To gather the TimeWatcher statistics based on all test sessions executed within the test, you need to download the Raw Data report and use Microsoft Excel or a compatible application to easily perform calculations on statistical data.

Generally, the process includes two steps that we will discuss in this article:

  • Downloading the Raw Data Load Test report.
  • Processing the Raw Data report with Microsoft Excel.

Downloading the Raw Data Load Test Report

You can download a Raw Data report by clicking the Download button in the upper-right corner of the Load Test Report page and selecting Raw Data. The Raw Data report contains statistics on Start Time, Duration, Connection Time, First Packet Time, and other test parameters in the CSV file.

Once the report is downloaded, open the CSV file with Excel. Column G with the Name title will contain the request descriptions including the times measured by TimeWatcher.

Processing the Raw Data Report with Microsoft Excel

To easily perform mathematical calculations on specific TimeWatcher statistics, follow the steps below:

1. Filter column G by the name of the TimeWatcher.

To do this, go to the Home menu and select Sort & Filter. Then click the filter icon on the column G heading, uncheck the Select All checkbox, and under the Text Filter menu, click Contains. In the Custom Autofilter dialog, enter the TimeWatcher name as appear in the file.

2. To remove unwanted content from the column with the TimeWatcher results, Select All and Copy the filtered file content to a new Excel file.

3. Once a new file with TimeWatcher results is created, go the Home > Find & Select > Replace and copy and paste the part of the string from column G that does not contain a time value. Leave the Replace with field empty.

For example, if the string contains “Checking time for “ScriptTimeWatcher_2”. Measured time: 00:00:0X.XX.” select “Checking time for “ScriptTimeWatcher_1”. Measured time: 00:00:0” to remove.

4. Next, we need to trim the dots at the end of the TimeWatcher values in column G.

To do this, right-click the whole column to the right of column G, and then select Insert Columns. Then type the following formula into the first raw of a newly added column H:

=IF(RIGHT(G<row number>,1)=".", LEFT(G<row number>N,LEN(G<row number>)-1),G<row number>)

where <row number> is the number of the row of the first cell in column G.

Then drag the autofill handle at the right-down corner of the first cell to the cells you want to fill with the formula. The cells will be automatically filled based on the content of the corresponding cells from column G.

5. Once auto-filled cells from column H contain text strings that represent measured time values. To convert time values into a numeric format, insert a column to the right of column H and use the Value function under the Text functions menu to autofill column I with numbers presenting measured time.

Now you are all set to process the TimeWatcher measured times with various statistical functions available in Microsoft Excel.