Knowledge Base

Exporting Results

by Community Manager on 07-06-2011 01:15 PM - last edited on 02-02-2012 11:42 AM

Result objects can be exported into a variety of formats:  SOASTA XML Definition, Comma Separated Value (CSV), XML Spreadsheet (which can be read by Excel) as well as RSS 2.0 files. Individual, or in some cases, multiple results can be selected and exported for the given metric by selecting one of these formats; results can be selected from either the Compositions list or from the Results list in Central.

Multiple result exports are supported for tests run in parallel for the following selections: Page Completions, Page Average Durations, Transaction Completions, Transaction Average Durations, and Fundamentals Summary.

  

Export Charts to Excel

Widgets listed under Widget Types can be exported to Microsoft Excel in CSV format using the Export to Excel (CSV) icon.

To export a chart, place the mouse cursor or the right corner of the chart’s menu bar.

 

The file is opened by the browser download mechanism and the file to export takes the form of “<Widget name> export.csv”.

The format of the exported comma-separate-value file depends on the type of widget that is exported. A single chart will have a column for each of its axes.

The same chart that has been split by a dimension will have a column for each split dimension (e.g. one column for each location/domain/clip).

For an analysis widget, the CSV file will have a column for each of the columns within the widget. For each node in the tree an additional column appears (e.g. Composition > Clip > Collection, etc.).

   

Export One or More Results from the Results List

  1. In Central, find the existing result(s) either under Results or by clicking the arrow key next to expand a composition in the Compositions list to make a multiple selection.

To select a range, hold down the SHIFT key and select the second item.
  1. Click the Export button on the toolbar (alternately, right-click and choose Export from the context menu). The Export dialog box appears.

  1. Next, choose an export format.

When you choose CSV, XML Spreadsheet, or RSS, then another drop down will display for Data Source selection.

In the example on the right, the CSV option is selected, with the available data sources appearing in the drop-down.

The Data Source list will contain the following choices:

Note: Exported results are not available for the export format, XML Definition.

  1. Press the OK button. The standard Browser download dialog will display.
  

Export Result Tables

For the selections in the Data Source drop-down list above, the following fields are exported:

Clip Element Details

This export contains information for each clip element executed during the test. It contains one row for each message or script or other element executed during the test. This information is only available if the test was run with “Save Clip Element Details” turned on.

  • Band Name – The band in which this test clip was executed.
  • Band Index – The index of the band in the test composition.
  • Track Name – The name of the track in the test composition.
  • Track Index – The index of the track in the test composition.
  • Clip Name – The name of the test clip in the test composition.
  • Clip Index – The index of the test clip in the composition.
  • Chain Name – The name of the chain in the test clip.
  • Chain Index – The index of the chain in the test clip.
  • Clip Element Name – The name of the clip element in the test clip. For example, Message1.
  • Clip Element Index – The index of the given clip element within the test clip.
  • Clip Element Type – The type of clip element, such as message, browser action, delay, checkpoint, or chain.
  • Target Name – The target name for the given clip element.
  • Operation – The type of operation. For example, in a SOAP-based WSDL.
  • Server – The test server that ran this clip element.
  • Location – The location that was defined for the given test server.
  • Start Time – The time the clip element was fired
  • Send Time – The time the clip element was sent.
  • Receive Time – The time the clip element was received.
  • Connection Establish Time – The time at which a connection was established to the target site.
  • Response Time – The time at which a response was received for the clip element.
  • Delta From Scheduled Time – The difference between the scheduled time and the actual time.
  • Delta Scheduled Duration – The difference between the scheduled duration from send to receive and the actual one.
  • Validation Error – The number of validation errors.
  • Bytes Sent – The bytes sent for the given clip element.
  • Bytes Received – The bytes received for the given clip element.

Time Aggregate

This export contains aggregated information for each second of the test. There is one row for each second. The fields are:

  • Start Second – the second offset into the test using a ‘round up’ method. For example a message sent at 3.454 of the test will be included in the Start Second of ‘4’.
  • Message and BrowserActions Count – Number of messages plus browser actions processed in this second.
  • Send Count – the number of messages successfully sent during this second.
  • Receive Count – the number of messages received during this second
  • Total Response Time – the sum of the response times for every message sent during the second. Only messages which are successfully sent are included.
  • Avg. Response Time – calculated as Total Response Time divided by Send Count
  • Min. Response Time – the minimum response time sent during the second. Only messages which are successfully sent are included.
  • Max. Response Time - the maximum response time sent during the second. Only messages which are successfully sent are included.
  • Total Time - the sum of the Total times for every message attempted to send during the second. Timeouts and other times are included.
  • Min. Total Time - the minimum of the Total times for every message attempted to send during the second. Timeouts and other times are included.
  • Max. Total Time - the maximum of the Total times for every message attempted to send during the second. Timeouts and other times are included.
  • Bytes Sent – The Total number of bytes sent for each message successfully sent during the second.
  • Bytes Received – the Total number of bytes received for every message received during the second.
  • Total Errors – the Total number of messages with errors for messages attempted to send during the second.
  • Total Scripts - the Total number of scripts executed during the second.
  • Total Error Scripts - the Total number of scripts with errors executed during the second.

Clip Element Aggregate

This export contains aggregated information for every clip element in the test. There is one row for each clip element and error combination.

  • Clip Name – The name of the test clip in the test composition.
  • Clip Element Name – The name of the clip element in the test clip. For example, Message1.
  • Error – Displays the error text (or NONE if no error).
  • Clip Element Type – The type of clip element, such as message, browser action, delay, checkpoint, or chain.
  • Count – The count of clip elements. For example, eight for a message with eight repeats.
  • Send Count – The send count for the clip element. For example, eight messages sent.
  • Total Response Time – The sum of response time for the clip element. For example, 3517.
  • Avg. Response Time – The average response time for the clip element. For example, 439.
  • Min Response Time – The minimum response time. For example, 199.
  • Max Response Time – The maximum response time. For example, 873
  • Total Time – The total time for the clip element, including send and receive. For example 3519.
  • Min. Total Time – The minimum total time. For example, 199.
  • Max. Total Time – The maximum total time. For example, 873.
  • Bytes Sent – The sum of bytes sent for the given clip element.
  • Bytes Received – The sum of bytes received in response to the given clip element.
  • Total Errors – The sum of errors for the given clip element.
  • Validation Errors – The sum of validation errors for the given clip element.

Clip Details

This export contains information for each clip executed during the test. It contains one row for each clip instance. This information is only available if the test was run with "Save Clip Element Details" turned on in the composition's results logging properties. See Results Logging and Play Modes.

  • Band Name – The band in which this test clip was executed.
  • Band Index – The index of the band in the test composition.
  • Track Name – The name of the track in the test composition.
  • Track Index – The index of the track in the test composition.
  • Clip Name – The name of the test clip in the test composition.
  • Clip Index – The index of the test clip in the composition. For example, in a test composition with three clips, 0, 1, or 2.
  • Error – The error text (or NONE if no error).
  • Type – The type of test clip. For example, a MessageClip.
  • Completion Status – The completion status. For example, Playing or Completed.
  • Message Response Count – The number of message responses received.
  • Total Message Response Time – The sum of response times.
  • Min. Msg. Response Time – The minimum time a response took to be received.
  • Max. Msg. Response Time – The maximum time a response took to be received.
  • Bytes Sent – The sum of bytes sent for the given clip.
  • Bytes Received – The sum of bytes received in response to the given clip.
  • Duration – The duration of play for the test clip.
  • Start Time – The time at which the clip was fired.
  • Message Count – The count of messages in the clip.
  • BrowserAction Count – The count of browser actions in the clip.
  • Script Count – The count of scripts in the clip.
  • Checkpoint Count – The count of checkpoints in the clip.
  • Delay Count – The count of time delays in the clip.
  • Effective Duration – The effective duration of the clip.

Collection Details

This export contains information for each chain executed during the test. It contains one row for each chain instance. This information is only available if the test was run with "Save Clip Element Details" turned on.

  • Band Name – The band in which this test clip was executed.
  • Band Index – The index of the band in the test composition.
  • Track Name – The name of the track in the test composition.
  • Track Index – The index of the track in the test composition.
  • Clip Name – The name of the test clip in the test composition.
  • Clip Index – The index of the test clip in the composition.
  • Chain Name – The name of the chain.
  • Chain Index – The index of the chain in the test clip.
  • Error – The error text (or NONE if no error).
  • Type – The chain type.
  • Completion Status – The completion status. For example, Playing or Completed.
  • Message Response Count – The number of message responses received.
  • Total Msg. Response Time – The total message response time.
  • Min. Msg. Response Time – The minimum message response time.
  • Bytes Sent – The sum of bytes sent for the given clip.
  • Bytes Received – The sum of bytes received in response to the given clip.
  • Duration – The duration of play for the test clip.
  • Start Time – The time the chain was fired
  • Message Count – The count of messages in the clip.
  • BrowserAction Count – The count of browser actions in the clip.
  • Script Count – The count of scripts in the clip.
  • Checkpoint Count – The count of checkpoints in the clip.
  • Delay Count – The count of time delays in the clip.
  • Effective Duration – The effective duration of the clip.

Clip Aggregate

 

This export contains aggregated information for each clip executed during the test. It contains one row for each clip/error/completion status/Start Time combination regardless of how many times that clip was executed during the second or from which track or band it was executed.

  • Clip Name – The name of the test clip in the test composition.
  • Error – The error text (or NONE if no error).
  • Completion Status – The completion status. For example, Playing or Completed.
  • Start Second – The second when the given clip started.
  • Count – The count for the clip aggregate.
  • Total Duration – The total duration for the clip aggregate.
  • Min. Duration – The minimum clip duration.
  • Max. Duration – The maximum clip duration.
  • Total Msg. Response Time – The total message response time.
  • Min. Msg. Response Time – The minimum message response time.
  • Max. Msg. Response Time – The maximum message response time.
  • Message Response Count – The count of messages responses.
  • Bytes Sent – The sum of bytes sent.
  • Bytes Received – The sum of bytes received.

Collection Aggregate

This export contains aggregated information for each chain executed during the test. It contains one row for each clip/chain/error/completion status/Start Time combination regardless of how many times that chain was executed during the second or from which track or band it was executed.

  • Clip Name – The name of the test clip in the test composition.
  • Collection Name – The name of the chain in the test clip.
  • Error – The error text (or NONE if no error).
  • Completion Status – The completion status. For example, Playing or Completed.
  • Start Second – The second when the given chain started.
  • Count – The count for the chain.
  • Total Duration – The total duration for the chain.
  • Min. Duration – The minimum chain duration.
  • Max. Duration – The maximum chain duration.
  • Total Msg. Response Time – The total message response time.
  • Min. Msg. Response Time – The minimum message response time.
  • Max. Msg. Response Time – The maximum message response time.
  • Message Response Count – The count of message responses.
  • Bytes Sent – The sum of bytes sent.
  • Bytes Received – The sum of bytes received.

Track Aggregate

This export contains aggregated information for each track executed during the test. It contains one row for each clip/chain/error/completion status/Start Time combination regardless of how many times that track was executed during the second or from which band it was executed.

  • Track Name – The name of the track in the test composition.
  • Error – The error text (or NONE if no error).
  • Completion Status – The completion status. For example, Playing or Completed.
  • Start Second – The second when the given chain started.
  • Count – The count for the chain.
  • Total Duration – The total duration for the chain.
  • Min. Duration – The minimum chain duration.
  • Max. Duration – The maximum chain duration.
  • Total Msg. Response Time – The total message response time.
  • Min. Msg. Response Time – The minimum message response time.
  • Max. Msg. Response Time – The maximum message response time.
  • Message Response Count – The count of message responses.
  • Bytes Sent – The sum of bytes sent.
  • Bytes Received – The sum of bytes received.

Error Aggregate

This export contains lists summary information about message and script activity within that second for only those messages that had an error. There is one row for each second, error combination.

  • Second (Relative) – The second expressed as relative time.
  • Second (Absolute) – The second expressed in absolute time.
  • Error – The error text (or NONE if no error).
  • Message and BrowserActions Count – The count of messages/actions.
  • Send Count – The messages/actions sent for the error.
  • Total Response Time – The sum of response times.
  • Avg. Response Time – The average response time.
  • Min. Response Time – The minimum message response time.
  • Max. Response Time – The maximum message response time.
  • Total Response Time – The total message/action response time.
  • Min. Total Time – The minimum of the Total times for every error.
  • Max. Total Time – The minimum of the Total times for every error.
  • Avg TTFB – The average time to first byte for the error.
  • Avg. TTLB-TTFB – The average time to last byte minus the time to first byte for the error.
  • Bytes Sent – The average of bytes sent for the error.
  • Bytes Received – The bytes received for the error.
  • Total Errors – The total errors received for the error.
  • Total Scripts - the Total number of scripts executed during the second.
  • Total Error Scripts - the Total number of scripts with errors executed during the second.

URL Aggregate

This export lists summary information about the URLs in a test. There is one row for each URL and error combination. The following fields are included in the exported data:

  • URL Protocol – The transport protocol for the given URL (e.g. http, ftp, etc.).
  • URL Domain – The URL’s domain.
  • URL Path – The remaining path, after root, for the given URL on a domain.
  • Error – Displays the error text (or NONE if no error)..
  • Count – The count for the URL.
  • Send Count – the number of messages successfully sent for this URL.
  • Total Response Time – The total URL response time.
  • Avg. Response Time – The average URL response time.
  • Min. Total Time – The minimum of the Total times for every URL attempted.
  • Max. Total Time – The minimum of the Total times for every URL attempted
  • Avg TTFB – The average time to first byte for the URL.
  • Avg. TTLB-TTFB – The average time to last byte minus the time to first byte for the URL.
  • Avg Bytes Sent – The average of bytes sent for the URL.
  • Avg Bytes Received – The average of bytes received for the URL.
  • Total Errors – The total errors received for the URL.

Page Completions

This export lists summary information about page completions. There is one row for each minute of the test with a separate column for each page. Multiple results can be combined if the tests were run in parallel.

  • Minute of Test – The minute of the test composition as an integer.
  • Time – The minute as date time. For example, "9/12/2011 10:46:00 AM"
  • Page Name – The remaining rows are the page by name, one column each for each distinct page name.

Page Average Durations

This export lists summary information about page average durations. There is one row for each minute of the test with a separate column for each page. Multiple results can be combined if the tests were run in parallel.

  • Minute of Test – The minute of the test composition as an integer.
  • Time – The minute as date time. For example, "9/12/2011 10:46:00 AM"
  • Page Name – The remaining rows are the page by name, one column each for each distinct page name.

Transaction Completions

This export lists summary information about transaction completions. There is one row for each minute of the test with a separate column for each page. Multiple results can be combined if the tests were run in parallel.

  • Minute of Test – The minute of the test composition as an integer.
  • Time – The minute as date time. For example, "9/12/2011 10:46:00 AM"
  • Page Name – The remaining rows are the transaction by name, one column each for each distinct transaction name.

Transaction Average Durations

This export lists summary information about transaction average durations. There is one row for each minute of the test with a separate column for each transaction. Multiple results can be combined if the tests were run in parallel.

  • Minute of Test – The minute of the test composition as an integer.
  • Time – The minute as date time. For example, "9/12/2011 10:46:00 AM"
  • Page Name – The remaining rows are the transaction by name, one column each for each distinct transaction name.

Fundamentals Summary

This export lists summary information about a test. Multiple results can be combined if the tests were run in parallel.

    • Minute of Test – The minute of the test composition as an integer.
    • Time – The minute as date time. For example, "9/12/2011 10:46:00 AM"
    • Page Views – The number of page views for the given minute of the test.
    • ART (ms) – The average response time in milliseconds for the given minute of the test.
    • VU – The virtual users for the given minute of the test.
    • Throughput (Mbit) – The throughput in Mbits for the given minute of the test.
    • Errors – The errors for the given minute of the test.

 

  

0