{"id":10546,"date":"2023-05-10T14:44:58","date_gmt":"2023-05-10T18:44:58","guid":{"rendered":"https:\/\/www.redline13.com\/blog\/?p=10546"},"modified":"2023-06-22T14:14:33","modified_gmt":"2023-06-22T18:14:33","slug":"filtering-the-jmeter-dashboard-report","status":"publish","type":"post","link":"https:\/\/www.redline13.com\/blog\/2023\/05\/filtering-the-jmeter-dashboard-report\/","title":{"rendered":"Filtering the JMeter Dashboard Report"},"content":{"rendered":"

When you run a JMeter<\/a> load test on RedLine13 with output files<\/a> enabled, a JMeter Dashboard Report<\/a> is automatically generated. The results complement the RedLine13 test results page. In certain use cases it may be necessary to filter the data displayed and recreate the report on a subset of that data. In this post, we will cover how the report is generated, and how to filter the JMeter Dashboard Report to display customized results.<\/p>\n

\"Filtering<\/p>\n

<\/a>How is the JMeter Dashboard Report Generated?<\/h3>\n

As your JMeter load test runs, data is collected and stored in a *.JTL<\/code> result file<\/a>. Upon completion of your load test in RedLine13, we collect and merge all JTL<\/code> files from your load generator servers. From that merged JTL<\/code> file, we then create the JMeter Dashboard Report and present it as an output file for your test. The actual process of creating the report is functionality extended by the JMeter command line.<\/a><\/p>\n

<\/a>Filtering Data for the JMeter Dashboard Report<\/h3>\n

JMeter provides several command line options for filtering on data when generating the Dashboard Report. Those options are listed under general settings<\/a> on the official documentation page. In the next section we will review how to use these options to regenerate the report.<\/p>\n

There is also a second option which is more suitable if the data you are seeking to report on is more complex. The structure of a JTL<\/code> file is identical to that of a CSV<\/a> file, and can be readily modified using any spreadsheet application (e.g.<\/em>, Microsoft Excel). All you need to do is rename the file to a *.CSV<\/code> extension, as shown below:<\/p>\n

\"You
You can import any JTL<\/code> file into Excel for advanced analysis.<\/figcaption><\/figure>\n

<\/a>How to Regenerate the Dashboard Report<\/h3>\n

The JMeter Dashboard Report is compiled by the reportgenerator<\/strong> class accessible from the JMeter command line. When running the report generator command you have the opportunity to specify several settings<\/a> which can constrain your data. One common use case would be to constrain by timestamp, which would allow you to report on a particular segment of your test (e.g.<\/em>, steady-state). The following example shows how you can accomplish this:<\/p>\n

jmeter -g merged.jtl -Jjmeter.reportgenerator.start_date=\"20230505225200\" -Jjmeter.reportgenerator.end_date=\"20230505231400\" -Jjmeter.reportgenerator.report_title=RedLine13 -o .\/report<\/strong><\/pre>\n
Timestamps start_date<\/code> and end_date<\/code> are in the Java SimpleDateFormat<\/a> notation using the format \u201cyyyyMMddHHmmss<\/code>\u201d. Running the above command with any options you chose will cause JMeter to recompile the Dashboard Report to a folder on your local machine. The last parameter in the above command line example specifies the local folder where the report and supporting files will be generated.<\/p>\n
\"The
The JMeter Dashboard Report can be generated from any computer that can run JMeter locally, including Mac, Linux, and Windows devices.<\/figcaption><\/figure>\n
Another useful parameter is the overall_granularity<\/code> setting, which defines how data is aggregated and displayed on graphs. The default granularity is 60000ms<\/em> (one minute) such that graphs are displayed with one minute ticks. For very short or very long tests, your graphs can be made more readable by adjusting this number.<\/p>\n
\n
Did you know that RedLine13 offers a full-featured free trial? Sign up now<\/a> and move your JMeter testing into the cloud today!<\/p>\n","protected":false},"excerpt":{"rendered":"
When you run a JMeter load test on RedLine13 with output files enabled, a JMeter Dashboard Report is automatically generated. The results complement the RedLine13 test results page. In certain use cases it may be necessary to filter the data displayed and recreate the report on a subset of that data. In this post, we will cover how the report is generated, and how to filter the JMeter Dashboard Report to display customized results. How isRead More →<\/a><\/p>\n","protected":false},"author":11,"featured_media":10547,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,7],"tags":[283,289,318],"class_list":{"0":"entry","1":"post","2":"publish","3":"author-dkoziel","4":"post-10546","6":"format-standard","7":"has-post-thumbnail","8":"category-blog","9":"category-jmeter","10":"post_tag-jmeter","11":"post_tag-jmeter-dashboard","12":"post_tag-load-testing"},"yoast_head":"\nFiltering the JMeter Dashboard Report - RedLine13<\/title>\n<meta name=\"description\" content=\"It may be necessary to filter the data in the JMeter Dashboard Report to display customized results. It's easy to do in RedLine13.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.redline13.com\/blog\/2023\/05\/filtering-the-jmeter-dashboard-report\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Filtering the JMeter Dashboard Report - RedLine13\" \/>\n<meta property=\"og:description\" content=\"It may be necessary to filter the data in the JMeter Dashboard Report to display customized results. It's easy to do in RedLine13.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.redline13.com\/blog\/2023\/05\/filtering-the-jmeter-dashboard-report\/\" \/>\n<meta property=\"og:site_name\" content=\"RedLine13\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-10T18:44:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-22T18:14:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.redline13.com\/blog\/wp-content\/uploads\/2023\/05\/word-image-10546-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"David Koziel\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"David Koziel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.redline13.com\/blog\/2023\/05\/filtering-the-jmeter-dashboard-report\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.redline13.com\/blog\/2023\/05\/filtering-the-jmeter-dashboard-report\/\"},\"author\":{\"name\":\"David Koziel\",\"@id\":\"https:\/\/www.redline13.com\/blog\/#\/schema\/person\/51d282221e3230ab35f964f98ada9b20\"},\"headline\":\"Filtering the JMeter Dashboard Report\",\"datePublished\":\"2023-05-10T18:44:58+00:00\",\"dateModified\":\"2023-06-22T18:14:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.redline13.com\/blog\/2023\/05\/filtering-the-jmeter-dashboard-report\/\"},\"wordCount\":519,\"publisher\":{\"@id\":\"https:\/\/www.redline13.com\/blog\/#organization\"},\"keywords\":[\"JMeter\",\"JMeter Dashboard\",\"Load Testing\"],\"articleSection\":[\"Blog\",\"JMeter\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.redline13.com\/blog\/2023\/05\/filtering-the-jmeter-dashboard-report\/\",\"url\":\"https:\/\/www.redline13.com\/blog\/2023\/05\/filtering-the-jmeter-dashboard-report\/\",\"name\":\"Filtering the JMeter Dashboard Report - RedLine13\",\"isPartOf\":{\"@id\":\"https:\/\/www.redline13.com\/blog\/#website\"},\"datePublished\":\"2023-05-10T18:44:58+00:00\",\"dateModified\":\"2023-06-22T18:14:33+00:00\",\"description\":\"It may be necessary to filter the data in the JMeter Dashboard Report to display customized results. It's easy to do in RedLine13.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.redline13.com\/blog\/2023\/05\/filtering-the-jmeter-dashboard-report\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.redline13.com\/blog\/2023\/05\/filtering-the-jmeter-dashboard-report\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.redline13.com\/blog\/2023\/05\/filtering-the-jmeter-dashboard-report\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.redline13.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Filtering the JMeter Dashboard Report\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.redline13.com\/blog\/#website\",\"url\":\"https:\/\/www.redline13.com\/blog\/\",\"name\":\"RedLine13\",\"description\":\"(Almost) Free Load Testing in the Cloud\",\"publisher\":{\"@id\":\"https:\/\/www.redline13.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.redline13.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.redline13.com\/blog\/#organization\",\"name\":\"RedLine13\",\"url\":\"https:\/\/www.redline13.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.redline13.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.redline13.com\/blog\/wp-content\/uploads\/2013\/06\/cropped-rl13-header-logo.jpg\",\"contentUrl\":\"https:\/\/www.redline13.com\/blog\/wp-content\/uploads\/2013\/06\/cropped-rl13-header-logo.jpg\",\"width\":300,\"height\":68,\"caption\":\"RedLine13\"},\"image\":{\"@id\":\"https:\/\/www.redline13.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.redline13.com\/blog\/#\/schema\/person\/51d282221e3230ab35f964f98ada9b20\",\"name\":\"David Koziel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.redline13.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2babf644e0993fc86893c24d7525f1e3be114a8746c01249797f25587ae1697a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2babf644e0993fc86893c24d7525f1e3be114a8746c01249797f25587ae1697a?s=96&d=mm&r=g\",\"caption\":\"David Koziel\"},\"url\":\"https:\/\/www.redline13.com\/blog\/author\/dkoziel\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Filtering the JMeter Dashboard Report - RedLine13","description":"It may be necessary to filter the data in the JMeter Dashboard Report to display customized results. It's easy to do in RedLine13.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.redline13.com\/blog\/2023\/05\/filtering-the-jmeter-dashboard-report\/","og_locale":"en_US","og_type":"article","og_title":"Filtering the JMeter Dashboard Report - RedLine13","og_description":"It may be necessary to filter the data in the JMeter Dashboard Report to display customized results. It's easy to do in RedLine13.","og_url":"https:\/\/www.redline13.com\/blog\/2023\/05\/filtering-the-jmeter-dashboard-report\/","og_site_name":"RedLine13","article_published_time":"2023-05-10T18:44:58+00:00","article_modified_time":"2023-06-22T18:14:33+00:00","og_image":[{"width":400,"height":300,"url":"https:\/\/www.redline13.com\/blog\/wp-content\/uploads\/2023\/05\/word-image-10546-1.png","type":"image\/png"}],"author":"David Koziel","twitter_card":"summary_large_image","twitter_misc":{"Written by":"David Koziel","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.redline13.com\/blog\/2023\/05\/filtering-the-jmeter-dashboard-report\/#article","isPartOf":{"@id":"https:\/\/www.redline13.com\/blog\/2023\/05\/filtering-the-jmeter-dashboard-report\/"},"author":{"name":"David Koziel","@id":"https:\/\/www.redline13.com\/blog\/#\/schema\/person\/51d282221e3230ab35f964f98ada9b20"},"headline":"Filtering the JMeter Dashboard Report","datePublished":"2023-05-10T18:44:58+00:00","dateModified":"2023-06-22T18:14:33+00:00","mainEntityOfPage":{"@id":"https:\/\/www.redline13.com\/blog\/2023\/05\/filtering-the-jmeter-dashboard-report\/"},"wordCount":519,"publisher":{"@id":"https:\/\/www.redline13.com\/blog\/#organization"},"keywords":["JMeter","JMeter Dashboard","Load Testing"],"articleSection":["Blog","JMeter"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.redline13.com\/blog\/2023\/05\/filtering-the-jmeter-dashboard-report\/","url":"https:\/\/www.redline13.com\/blog\/2023\/05\/filtering-the-jmeter-dashboard-report\/","name":"Filtering the JMeter Dashboard Report - RedLine13","isPartOf":{"@id":"https:\/\/www.redline13.com\/blog\/#website"},"datePublished":"2023-05-10T18:44:58+00:00","dateModified":"2023-06-22T18:14:33+00:00","description":"It may be necessary to filter the data in the JMeter Dashboard Report to display customized results. It's easy to do in RedLine13.","breadcrumb":{"@id":"https:\/\/www.redline13.com\/blog\/2023\/05\/filtering-the-jmeter-dashboard-report\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.redline13.com\/blog\/2023\/05\/filtering-the-jmeter-dashboard-report\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.redline13.com\/blog\/2023\/05\/filtering-the-jmeter-dashboard-report\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.redline13.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Filtering the JMeter Dashboard Report"}]},{"@type":"WebSite","@id":"https:\/\/www.redline13.com\/blog\/#website","url":"https:\/\/www.redline13.com\/blog\/","name":"RedLine13","description":"(Almost) Free Load Testing in the Cloud","publisher":{"@id":"https:\/\/www.redline13.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.redline13.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.redline13.com\/blog\/#organization","name":"RedLine13","url":"https:\/\/www.redline13.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.redline13.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.redline13.com\/blog\/wp-content\/uploads\/2013\/06\/cropped-rl13-header-logo.jpg","contentUrl":"https:\/\/www.redline13.com\/blog\/wp-content\/uploads\/2013\/06\/cropped-rl13-header-logo.jpg","width":300,"height":68,"caption":"RedLine13"},"image":{"@id":"https:\/\/www.redline13.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.redline13.com\/blog\/#\/schema\/person\/51d282221e3230ab35f964f98ada9b20","name":"David Koziel","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.redline13.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2babf644e0993fc86893c24d7525f1e3be114a8746c01249797f25587ae1697a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2babf644e0993fc86893c24d7525f1e3be114a8746c01249797f25587ae1697a?s=96&d=mm&r=g","caption":"David Koziel"},"url":"https:\/\/www.redline13.com\/blog\/author\/dkoziel\/"}]}},"_links":{"self":[{"href":"https:\/\/www.redline13.com\/blog\/wp-json\/wp\/v2\/posts\/10546","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.redline13.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.redline13.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.redline13.com\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.redline13.com\/blog\/wp-json\/wp\/v2\/comments?post=10546"}],"version-history":[{"count":2,"href":"https:\/\/www.redline13.com\/blog\/wp-json\/wp\/v2\/posts\/10546\/revisions"}],"predecessor-version":[{"id":10554,"href":"https:\/\/www.redline13.com\/blog\/wp-json\/wp\/v2\/posts\/10546\/revisions\/10554"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.redline13.com\/blog\/wp-json\/wp\/v2\/media\/10547"}],"wp:attachment":[{"href":"https:\/\/www.redline13.com\/blog\/wp-json\/wp\/v2\/media?parent=10546"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.redline13.com\/blog\/wp-json\/wp\/v2\/categories?post=10546"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.redline13.com\/blog\/wp-json\/wp\/v2\/tags?post=10546"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}