Links

CSV Results

How to download and interpret CSV Results
The CSV results file forms the basis of charts in the UI, and can be downloaded at the completion of a flood load test by clicking on the gear icon and selecting CSV Results.​
You can then download the resulting CSV file. When you open it up in your text editor, it will look something like this:
Time,Elapsed Time,Account UUID,Project UUID,Project,Stream UUID,Stream,Flood UUID,Flood,Region,Measurement,Label,Value
2020-01-03 13:40:45,0,LVEISdfIkNA,1RgBAcD8IRZU6gNDE8FIOsEbfoc,JMeter,1VnQoeGRefMjYt4JEAd703j16Ae,JMeter Sample,oIV68RO9rm1f1WFqvJk54A,JMeter Sample 2,us-east-1,concurrent_users,"",1
2020-01-03 13:41:00,15,LVEISdfIkNA,1RgBAcD8IRZU6gNDE8FIOsEbfoc,JMeter,1VnQoeGRefMjYt4JEAd703j16Ae,JMeter Sample,oIV68RO9rm1f1WFqvJk54A,JMeter Sample 2,us-east-1,concurrent_users,"",1
2020-01-03 13:41:15,30,LVEISdfIkNA,1RgBAcD8IRZU6gNDE8FIOsEbfoc,JMeter,1VnQoeGRefMjYt4JEAd703j16Ae,JMeter Sample,oIV68RO9rm1f1WFqvJk54A,JMeter Sample 2,us-east-1,concurrent_users,"",1

Headers

The CSV results file has the following headers:
  • Time: the date and time of the measurement
  • Elapsed Time: the amount of time relative to the beginning of the flood
  • Account UUID: unique identifier of the account from which the flood was executed
  • Project UUID: unique identifier of the project to which the flood belongs
  • Project: name of the project
  • Stream UUID: unique identifier of the stream from which the flood was started
  • Stream: name of the stream
  • Flood UUID: unique identifier of the flood
  • Flood: name of the flood
  • Region: geographical region of the grid node
  • Measurement: string to indicate what value is being measured.
  • Label: string to indicate if this is a specific transaction measurement or a global measurement (__all).
  • Value: integer result of the measurement, aggregated (see below)

Values

Values are context-sensitive to measurements, and are recorded for the measured period (15 seconds) as follows:
  • failed is the sum total of failed transactions.
  • passed is the sum total of passed transactions.
  • response_time is the average response time in milliseconds.
  • concurrency is the maximum concurrent users of all transactions.
  • throughput is the sum total of bytes of all transactions.
  • transaction_rate is the sum total of all transactions.

Example

Let's have a look at this sample from the CSV results of a flood:
2020-01-03 13:40:45,0,LVEISdfIkNA,1RgBAcD8IRZU6gNDE8FIOsEbfoc,JMeter,1VnQoeGRefMjYt4JEAd703j16Ae,JMeter Sample,oIV68RO9rm1f1WFqvJk54A,JMeter Sample 2,us-east-1,failed,home_page,0
This line means that at the beginning of the test, for the first 15 seconds, there were no failed requests for the home_page transaction.