[Quicktip] JMeter – Own graphs/diagrams using csv-export

You want to create good looking graphs, but JMeter doesn’t provide them? You want to compare several testruns and present the results in one graph? But you do not want to code a plugin for JMeter or don’t want to parse the *.jtl file via XSLT?

Then use the easy but often overlooked  csv-export feature of JMeter:

  • Add a listener like “Aggregate Report” (includes 90% line) or “Summary Report” (includes standard deviation) to your project.
  • Record or load your testdata
  • Navigate to the listener and click on the button “Save Table Data” at the bottom and save the result as a file.

That did the trick. You got a CSV file, which you can import into your favourite spreadsheet application and create diagrams from the data.

With a little bit of tweaking the diagram options you can create diagrams like the following example, which compares two testruns. Such type of diagram is easy to understand and shows possible performance improvements in the same scale…

About these ads

3 thoughts on “[Quicktip] JMeter – Own graphs/diagrams using csv-export

  1. Can u please tell me how did u get the report using that CSV. Basically i have generated the CSV file using Jmeter. But then the graph is not that great in Jmeter to understand. So i want an easy representation of the CSV file. Like X-axis as the date/time and Y-axis the response time.Suggest me an application where I represent this

    Reply
    • When you imported the CSV file correctly you have several columns like min, max, 90%, median and so on.

      * Create a worksheet for each type (min, max or median) – and copy only the relevant column to column B (do not forget to copy the label column to column A, too).
      * Execute another testrun (after you made a performance-fix) and repeat the copying to the worksheets, but now copy the relevant column to column C.
      * Execute another testrun (after you made another performance-fix) and repeat the copying to the worksheets, but now copy the relevant column to column D.
      * And so on.

      Now create the graphs from the previously worksheets for the specific types and you able to compare the testruns.

      Another approach is to write a small JAVA programm using Apache POI, which converts the CSV to XLS.

      Reply
  2. All this is nice as long as u run in GUI mode. Once you switch yo non-GUI/ cmd you no longer get the STDev -real shame

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s