Exporting report items¶
Bench Report Items can be exported anytime using the Export Item Button .
This button appears on the top right corner of a report item when you place your mouse hover it.
If you prefer to export the whole report at once, please refer to the Exporting a Bench Report documentation page.
Exporting tables¶
Table report items like statistics tables, delta tables or errors tables can be exported as CSV files.
For example exporting the table above will generate the following CSV file:
"Action","Avg. response time (sec)","Response time percentile 90 (sec)","Hits count (hits)","Errors count (errors)"
"GET https://petstore.octoperf.com:443/actions/Order.action?newOrderForm=","0.605","0.717","61","0"
"RESOURCE https://petstore.octoperf.com:443/actions/Order.action?newOrderForm=","0.19","0.225","610","0"
"POST https://petstore.octoperf.com:443/actions/Account.action","0.2","0.236","66","0"
"GET https://petstore.octoperf.com:443/actions/Account.action?signoff=","0.184","0.222","60","0"
"GET https://petstore.octoperf.com:443/actions/Order.action?newOrder=&confirmed=true","0.232","0.268","60","60"
"POST https://petstore.octoperf.com:443/actions/Order.action","0.613","0.709","60","0"
"RESOURCE https://petstore.octoperf.com:443/actions/Order.action","0.19","0.223","600","0"
"GET https://petstore.octoperf.com:443/actions/Catalog.action?viewCategory=&categoryId=${RandomCategory}","0.599","0.649","64","0"
"RESOURCE https://petstore.octoperf.com:443/actions/Catalog.action?viewCategory=&categoryId=${RandomCategory}","0.186","0.205","640","0"
"GET https://petstore.octoperf.com:443/actions/Catalog.action","0.538","0.622","65","0"
"RESOURCE https://petstore.octoperf.com:443/actions/Catalog.action","0.167","0.199","1040","0"
"GET https://petstore.octoperf.com:443/actions/Catalog.action","0.515","0.644","60","0"
"RESOURCE https://petstore.octoperf.com:443/actions/Catalog.action","0.162","0.196","960","0"
"GET https://petstore.octoperf.com:443/actions/Account.action?signonForm=","0.624","0.696","67","0"
"RESOURCE https://petstore.octoperf.com:443/actions/Account.action?signonForm=","0.19","0.218","670","0"
"GET https://petstore.octoperf.com:443/actions/Catalog.action","0.248","0.352","65","0"
"RESOURCE https://petstore.octoperf.com:443/actions/Catalog.action","0.065","0.097","1040","0"
"GET https://petstore.octoperf.com:443/actions/Catalog.action?viewProduct=&productId=${RandomProduct}","0.581","0.644","63","0"
"RESOURCE https://petstore.octoperf.com:443/actions/Catalog.action?viewProduct=&productId=${RandomProduct}","0.181","0.21","630","0"
Some tables may contain timestamps that will not properly render in Microsoft excel, you can fix this by using a formula to format the date in excel-compatible date format:
=(A2/86400000)+DATE(1970,1,1)
You can then format the resulting column as a date and pick your date format to get exactly what you want.
Note
The CSV configuration is:
- Quoted values,
- Comma
,
as the separator, - First line is the columns titles.
Exporting charts¶
All graphical report items like line charts, percentiles or pie chart can be exported as PNG files.
For example exporting the above monitoring line chart will result in the following image:
Note
The exported line chart does not include the legend. You may want to do a print screen or Export the whole Bench Report if you want it.