JMeter_Dasboard_Full_Details

{ “__inputs”: [ { “name”: “VAR_MEASUREMENT_NAME”, “type”: “constant”, “label”: “Measurement name”, “value”: “jmeter”, “description”: "" }, { “name”: “VAR_SEND_INTERVAL”, “type”: “constant”, “label”: “Backend send interval in second”, “value”: “5”, “description”: "" } ], “__requires”: [ { “type”: “grafana”, “id”: “grafana”, “name”: “Grafana”, “version”: “5.1.4” }, { “type”: “panel”, “id”: “graph”, “name”: “Graph”, “version”: “5.0.0” }, { “type”: “panel”, “id”: “singlestat”, “name”: “Singlestat”, “version”: “5.0.0” }, { “type”: “panel”, “id”: “table”, “name”: “Table”, “version”: “5.0.0” } ], “annotations”: { “list”: [ { “builtIn”: 1, “datasource”: “$data_source”, “enable”: false, “hide”: true, “iconColor”: “rgba(0, 211, 255, 1)”, “limit”: 100, “name”: “Start/stop marker”, “query”: “select text from events where $timeFilter”, “showIn”: 0, “textColumn”: “”, “type”: “dashboard” } ] }, “description”: “Dashboard for JMeter tests with Influx DB as back-end listening DB”, “editable”: true, “gnetId”: 4026, “graphTooltip”: 1, “id”: null, “iteration”: 1536230895850, “links”: [], “panels”: [ { “collapsed”: false, “gridPos”: { “h”: 1, “w”: 24, “x”: 0, “y”: 0 }, “id”: 40, “panels”: [], “repeat”: null, “title”: “Overall Test Summary”, “type”: “row” }, { “cacheTimeout”: null, “colorBackground”: false, “colorValue”: true, “colors”: [ “#1f78c1”, “#1f78c1”, “#1f78c1” ], “datasource”: “$data_source”, “decimals”: 0, “format”: “none”, “gauge”: { “maxValue”: 100, “minValue”: 0, “show”: false, “thresholdLabels”: false, “thresholdMarkers”: true }, “gridPos”: { “h”: 4, “w”: 3, “x”: 0, “y”: 1 }, “height”: “”, “id”: 51, “interval”: “[[send_interval]]s”, “links”: [], “mappingType”: 1, “mappingTypes”: [ { “name”: “value to text”, “value”: 1 }, { “name”: “range to text”, “value”: 2 } ], “maxDataPoints”: 100, “minSpan”: 11, “nullPointMode”: “connected”, “nullText”: null, “postfix”: " Users", “postfixFontSize”: “50%”, “prefix”: “”, “prefixFontSize”: “50%”, “rangeMaps”: [ { “from”: “null”, “text”: “N/A”, “to”: “null” } ], “repeatDirection”: “h”, “sparkline”: { “fillColor”: “rgba(31, 118, 189, 0.18)”, “full”: true, “lineColor”: “rgb(0, 191, 17)”, “show”: false }, “tableColumn”: “max”, “targets”: [ { “groupBy”: [ { “params”: [ “$__interval” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT last("maxAT") FROM "$measurement_name" WHERE ("transaction" = ‘internal’ AND "application" =~ /^$application$/) AND $timeFilter GROUP BY time($__interval) fill(null)”, “rawQuery”: true, “refId”: “A”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “value” ], “type”: “field” }, { “params”: [], “type”: “mean” } ] ], “tags”: [] } ], “thresholds”: “”, “title”: “Users”, “transparent”: true, “type”: “singlestat”, “valueFontSize”: “80%”, “valueMaps”: [ { “op”: “=”, “text”: “0”, “value”: “null” } ], “valueName”: “max” }, { “cacheTimeout”: null, “colorBackground”: false, “colorValue”: true, “colors”: [ “#1f78c1”, “#1f78c1”, “#1f78c1” ], “datasource”: “$data_source”, “decimals”: 2, “format”: “none”, “gauge”: { “maxValue”: 100, “minValue”: 0, “show”: false, “thresholdLabels”: false, “thresholdMarkers”: true }, “gridPos”: { “h”: 4, “w”: 3, “x”: 3, “y”: 1 }, “height”: “”, “id”: 52, “interval”: “[[send_interval]]s”, “links”: [], “mappingType”: 1, “mappingTypes”: [ { “name”: “value to text”, “value”: 1 }, { “name”: “range to text”, “value”: 2 } ], “maxDataPoints”: 100, “minSpan”: 11, “nullPointMode”: “connected”, “nullText”: null, “postfix”: " TPS", “postfixFontSize”: “50%”, “prefix”: “”, “prefixFontSize”: “50%”, “rangeMaps”: [ { “from”: “null”, “text”: “N/A”, “to”: “null” } ], “repeatDirection”: “h”, “sparkline”: { “fillColor”: “rgba(31, 118, 189, 0.18)”, “full”: true, “lineColor”: “rgb(0, 191, 17)”, “show”: false }, “tableColumn”: “max”, “targets”: [ { “groupBy”: [ { “params”: [ “$__interval” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT mean("count") / $send_interval FROM "$measurement_name" WHERE ("transaction" = ‘all’ AND "application" =~ /^$application$/) AND $timeFilter GROUP BY time($__interval) fill(null)”, “rawQuery”: true, “refId”: “A”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “value” ], “type”: “field” }, { “params”: [], “type”: “mean” } ] ], “tags”: [] } ], “thresholds”: “”, “title”: “Overall TPS (Average)”, “transparent”: true, “type”: “singlestat”, “valueFontSize”: “80%”, “valueMaps”: [ { “op”: “=”, “text”: “0”, “value”: “null” } ], “valueName”: “avg” }, { “cacheTimeout”: null, “colorBackground”: false, “colorValue”: true, “colors”: [ “#e5ac0e”, “#e5ac0e”, “#e5ac0e” ], “datasource”: “$data_source”, “decimals”: 0, “format”: “none”, “gauge”: { “maxValue”: 100, “minValue”: 0, “show”: false, “thresholdLabels”: false, “thresholdMarkers”: true }, “gridPos”: { “h”: 2, “w”: 8, “x”: 6, “y”: 1 }, “height”: “”, “id”: 26, “interval”: “[[send_interval]]s”, “links”: [], “mappingType”: 1, “mappingTypes”: [ { “name”: “value to text”, “value”: 1 }, { “name”: “range to text”, “value”: 2 } ], “maxDataPoints”: 100, “nullPointMode”: “connected”, “nullText”: null, “postfix”: " Requests", “postfixFontSize”: “50%”, “prefix”: “”, “prefixFontSize”: “50%”, “rangeMaps”: [ { “from”: “null”, “text”: “N/A”, “to”: “null” } ], “sparkline”: { “fillColor”: “rgba(31, 118, 189, 0.18)”, “full”: false, “lineColor”: “#e5ac0e”, “show”: false }, “tableColumn”: “”, “targets”: [ { “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “$__interval” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT sum("count") FROM "$measurement_name" WHERE ("application" =~ /^$application$/ AND "transaction" = ‘all’) AND $timeFilter GROUP BY time($__interval) fill(null)”, “rawQuery”: true, “refId”: “A”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “value” ], “type”: “field” }, { “params”: [], “type”: “mean” } ] ], “tags”: [] } ], “thresholds”: “”, “title”: “Total Requests”, “transparent”: true, “type”: “singlestat”, “valueFontSize”: “80%”, “valueMaps”: [ { “op”: “=”, “text”: “0”, “value”: “null” } ], “valueName”: “total” }, { “cacheTimeout”: null, “colorBackground”: false, “colorValue”: true, “colors”: [ “#e24d42”, “#ef843c”, “#299c46” ], “datasource”: “$data_source”, “decimals”: 2, “format”: “percentunit”, “gauge”: { “maxValue”: 1, “minValue”: 0, “show”: true, “thresholdLabels”: false, “thresholdMarkers”: true }, “gridPos”: { “h”: 4, “w”: 5, “x”: 14, “y”: 1 }, “id”: 36, “interval”: “[[send_interval]]s”, “links”: [], “mappingType”: 1, “mappingTypes”: [ { “name”: “value to text”, “value”: 1 }, { “name”: “range to text”, “value”: 2 } ], “maxDataPoints”: 100, “nullPointMode”: “connected”, “nullText”: null, “postfix”: “”, “postfixFontSize”: “50%”, “prefix”: “”, “prefixFontSize”: “50%”, “rangeMaps”: [ { “from”: “null”, “text”: “N/A”, “to”: “null” } ], “sparkline”: { “fillColor”: “rgba(31, 118, 189, 0.18)”, “full”: false, “lineColor”: “rgb(31, 120, 193)”, “show”: false }, “tableColumn”: “”, “targets”: [ { “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “$__interval” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT (sum("all") - sum("error")) / sum("all") FROM (SELECT sum("count") AS "all" FROM "$measurement_name" WHERE "transaction" = ‘all’ AND "application" =~ /^$application$/ AND $timeFilter GROUP BY time($__interval) fill(null)), (SELECT sum("countError") AS "error" FROM "$measurement_name" WHERE "transaction" = ‘all’ AND "application" =~ /^$application$/ AND $timeFilter GROUP BY time($__interval) fill(null))”, “rawQuery”: true, “refId”: “A”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “value” ], “type”: “field” }, { “params”: [], “type”: “mean” } ] ], “tags”: [] } ], “thresholds”: “0,0.01”, “title”: “Pass %”, “transparent”: true, “type”: “singlestat”, “valueFontSize”: “70%”, “valueMaps”: [ { “op”: “=”, “text”: “0”, “value”: “null” } ], “valueName”: “total” }, { “cacheTimeout”: null, “colorBackground”: false, “colorValue”: true, “colors”: [ “#299c46”, “#ef843c”, “#e24d42” ], “datasource”: “$data_source”, “decimals”: 2, “format”: “percentunit”, “gauge”: { “maxValue”: 1, “minValue”: 0, “show”: true, “thresholdLabels”: false, “thresholdMarkers”: true }, “gridPos”: { “h”: 4, “w”: 4, “x”: 19, “y”: 1 }, “id”: 29, “interval”: “[[send_interval]]s”, “links”: [], “mappingType”: 1, “mappingTypes”: [ { “name”: “value to text”, “value”: 1 }, { “name”: “range to text”, “value”: 2 } ], “maxDataPoints”: 100, “nullPointMode”: “connected”, “nullText”: null, “postfix”: “”, “postfixFontSize”: “50%”, “prefix”: “”, “prefixFontSize”: “50%”, “rangeMaps”: [ { “from”: “null”, “text”: “N/A”, “to”: “null” } ], “sparkline”: { “fillColor”: “rgba(31, 118, 189, 0.18)”, “full”: false, “lineColor”: “rgb(31, 120, 193)”, “show”: false }, “tableColumn”: “”, “targets”: [ { “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “$__interval” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT sum("error") / sum("all") FROM (SELECT sum("count") AS "all" FROM "$measurement_name" WHERE "transaction" = ‘all’ AND "application" =~ /^$application$/ AND $timeFilter GROUP BY time($__interval) fill(null)), (SELECT sum("countError") AS "error" FROM "$measurement_name" WHERE "transaction" = ‘all’ AND "application" =~ /^$application$/ AND $timeFilter GROUP BY time($__interval) fill(null))”, “rawQuery”: true, “refId”: “A”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “value” ], “type”: “field” }, { “params”: [], “type”: “mean” } ] ], “tags”: [] } ], “thresholds”: “0,0.01”, “title”: “Fail %”, “transparent”: true, “type”: “singlestat”, “valueFontSize”: “70%”, “valueMaps”: [ { “op”: “=”, “text”: “0”, “value”: “null” } ], “valueName”: “total” }, { “cacheTimeout”: null, “colorBackground”: false, “colorValue”: true, “colors”: [ “rgb(73, 222, 35)”, “rgb(69, 212, 31)”, “rgb(32, 212, 23)” ], “datasource”: “$data_source”, “decimals”: 0, “format”: “none”, “gauge”: { “maxValue”: 100, “minValue”: 0, “show”: false, “thresholdLabels”: false, “thresholdMarkers”: true }, “gridPos”: { “h”: 2, “w”: 4, “x”: 6, “y”: 3 }, “height”: “”, “id”: 38, “interval”: “[[send_interval]]s”, “links”: [], “mappingType”: 1, “mappingTypes”: [ { “name”: “value to text”, “value”: 1 }, { “name”: “range to text”, “value”: 2 } ], “maxDataPoints”: 100, “minSpan”: 11, “nullPointMode”: “connected”, “nullText”: null, “postfix”: " Passed", “postfixFontSize”: “50%”, “prefix”: “”, “prefixFontSize”: “50%”, “rangeMaps”: [ { “from”: “null”, “text”: “N/A”, “to”: “null” } ], “repeat”: null, “repeatDirection”: “h”, “sparkline”: { “fillColor”: “rgba(31, 118, 189, 0.18)”, “full”: false, “lineColor”: “rgb(0, 191, 17)”, “show”: true }, “tableColumn”: “”, “targets”: [ { “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “$__interval” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “measurement”: “/^$measurement_name$/”, “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT (sum("count") - sum("countError")) FROM "$measurement_name" WHERE ("transaction" = ‘all’ AND "application" =~ /^$application$/) AND $timeFilter GROUP BY time($__interval) fill(null)\n”, “rawQuery”: false, “refId”: “A”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “count” ], “type”: “field” }, { “params”: [], “type”: “sum” } ] ], “tags”: [ { “key”: “application”, “operator”: “=”, “value”: “/^$application$/” }, { “condition”: “AND”, “key”: “statut”, “operator”: “=”, “value”: “ok” } ] } ], “thresholds”: “”, “title”: “Passed Requests”, “transparent”: true, “type”: “singlestat”, “valueFontSize”: “80%”, “valueMaps”: [ { “op”: “=”, “text”: “0”, “value”: “null” } ], “valueName”: “total” }, { “cacheTimeout”: null, “colorBackground”: false, “colorValue”: true, “colors”: [ “#299c46”, “#e24d42”, “#d44a3a” ], “datasource”: “$data_source”, “decimals”: 0, “format”: “none”, “gauge”: { “maxValue”: 100, “minValue”: 0, “show”: false, “thresholdLabels”: false, “thresholdMarkers”: true }, “gridPos”: { “h”: 2, “w”: 4, “x”: 10, “y”: 3 }, “height”: “”, “id”: 37, “interval”: “[[send_interval]]s”, “links”: [], “mappingType”: 1, “mappingTypes”: [ { “name”: “value to text”, “value”: 1 }, { “name”: “range to text”, “value”: 2 } ], “maxDataPoints”: 100, “nullPointMode”: “connected”, “nullText”: null, “postfix”: " Failed", “postfixFontSize”: “50%”, “prefix”: “”, “prefixFontSize”: “50%”, “rangeMaps”: [ { “from”: “null”, “text”: “N/A”, “to”: “null” } ], “sparkline”: { “fillColor”: “rgba(31, 118, 189, 0.18)”, “full”: false, “lineColor”: “#bf1b00”, “show”: true }, “tableColumn”: “”, “targets”: [ { “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “$__interval” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “measurement”: “/^$measurement_name$/”, “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT sum("countError") FROM "$measurement_name" WHERE ("transaction" = ‘all’ AND "application" = /^$application$/) AND $timeFilter GROUP BY time($__interval) fill(null)”, “rawQuery”: false, “refId”: “A”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “count” ], “type”: “field” }, { “params”: [], “type”: “sum” } ] ], “tags”: [ { “key”: “application”, “operator”: “=”, “value”: “/^$application$/” }, { “condition”: “AND”, “key”: “statut”, “operator”: “=”, “value”: “ko” } ] } ], “thresholds”: “”, “title”: “Failed Requests”, “transparent”: true, “type”: “singlestat”, “valueFontSize”: “80%”, “valueMaps”: [ { “op”: “=”, “text”: “0”, “value”: “null” } ], “valueName”: “total” }, { “aliasColors”: { “Threads”: “#1f78c1”, “Users”: “#1f78c1”, “threads”: “#614d93” }, “bars”: false, “dashLength”: 10, “dashes”: false, “datasource”: “$data_source”, “decimals”: 0, “fill”: 2, “gridPos”: { “h”: 6, “w”: 12, “x”: 0, “y”: 5 }, “id”: 31, “interval”: “[[send_interval]]s”, “legend”: { “alignAsTable”: true, “avg”: false, “current”: true, “max”: true, “min”: false, “show”: true, “total”: false, “values”: true }, “lines”: true, “linewidth”: 3, “links”: [], “nullPointMode”: “null”, “percentage”: false, “pointradius”: 5, “points”: false, “renderer”: “flot”, “seriesOverrides”: [], “spaceLength”: 10, “stack”: false, “steppedLine”: false, “targets”: [ { “alias”: “Users”, “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “$__interval” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT last("maxAT") FROM "$measurement_name" WHERE ("transaction" = ‘internal’ AND "application" = /^$application$/) AND $timeFilter GROUP BY time($__interval) fill(null)”, “rawQuery”: true, “refId”: “A”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “value” ], “type”: “field” }, { “params”: [], “type”: “mean” } ] ], “tags”: [] } ], “thresholds”: [], “timeFrom”: null, “timeShift”: null, “title”: “Number of Users”, “tooltip”: { “shared”: true, “sort”: 0, “value_type”: “individual” }, “transparent”: true, “type”: “graph”, “xaxis”: { “buckets”: null, “mode”: “time”, “name”: null, “show”: true, “values”: [] }, “yaxes”: [ { “decimals”: 0, “format”: “short”, “label”: null, “logBase”: 1, “max”: null, “min”: null, “show”: true }, { “format”: “short”, “label”: null, “logBase”: 1, “max”: null, “min”: null, “show”: true } ], “yaxis”: { “align”: false, “alignLevel”: null } }, { “aliasColors”: { “No of Errors”: “#6ED0E0”, “Req / s”: “#6ed0e0”, “Req / sec”: “#65c5db”, “Transactions”: “#1f78c1”, “Transactions/sec”: “#705da0” }, “bars”: false, “dashLength”: 10, “dashes”: false, “datasource”: “$data_source”, “decimals”: 2, “editable”: true, “error”: false, “fill”: 1, “gridPos”: { “h”: 6, “w”: 12, “x”: 12, “y”: 5 }, “id”: 4, “interval”: “[[send_interval]]s”, “legend”: { “alignAsTable”: true, “avg”: true, “current”: false, “max”: true, “min”: true, “rightSide”: false, “show”: true, “sort”: null, “sortDesc”: null, “total”: false, “values”: true }, “lines”: true, “linewidth”: 1, “links”: [], “nullPointMode”: “null”, “percentage”: false, “pointradius”: 1, “points”: false, “renderer”: “flot”, “seriesOverrides”: [], “spaceLength”: 10, “stack”: false, “steppedLine”: false, “targets”: [ { “alias”: “Transactions/sec”, “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “$__interval” ], “type”: “time” } ], “measurement”: “jmeter”, “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT mean("count") / $send_interval FROM "$measurement_name" WHERE ("transaction" = ‘all’ AND "application" =~ /^$application$/) AND $timeFilter GROUP BY time($__interval) fill(null)”, “rawQuery”: true, “refId”: “B”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “count” ], “type”: “field” }, { “params”: [], “type”: “last” } ] ], “tags”: [ { “key”: “transaction”, “operator”: “=”, “value”: “all” }, { “condition”: “AND”, “key”: “application”, “operator”: “=”, “value”: “/^$application$/” } ] } ], “thresholds”: [], “timeFrom”: null, “timeShift”: null, “title”: “Total Transactions per second”, “tooltip”: { “msResolution”: false, “shared”: true, “sort”: 0, “value_type”: “individual” }, “transparent”: true, “type”: “graph”, “xaxis”: { “buckets”: null, “mode”: “time”, “name”: null, “show”: true, “values”: [] }, “yaxes”: [ { “format”: “short”, “label”: null, “logBase”: 1, “max”: null, “min”: null, “show”: true }, { “format”: “short”, “label”: null, “logBase”: 1, “max”: null, “min”: null, “show”: false } ], “yaxis”: { “align”: false, “alignLevel”: null } }, { “columns”: [], “datasource”: “$data_source”, “fontSize”: “100%”, “gridPos”: { “h”: 8, “w”: 24, “x”: 0, “y”: 11 }, “id”: 42, “links”: [], “pageSize”: null, “scroll”: true, “showHeader”: true, “sort”: { “col”: 1, “desc”: false }, “styles”: [ { “alias”: “Time”, “dateFormat”: “YYYY-MM-DD HH:mm:ss”, “link”: false, “pattern”: “Time”, “type”: “hidden” }, { “alias”: “”, “colorMode”: null, “colors”: [ “rgba(245, 54, 54, 0.9)”, “rgba(237, 129, 40, 0.89)”, “rgba(50, 172, 45, 0.97)” ], “dateFormat”: “YYYY-MM-DD HH:mm:ss”, “decimals”: 0, “pattern”: “Pass”, “thresholds”: [], “type”: “number”, “unit”: “none” }, { “alias”: “”, “colorMode”: “row”, “colors”: [ “#3f6833”, “#890f02”, “#890f02” ], “dateFormat”: “YYYY-MM-DD HH:mm:ss”, “decimals”: 2, “pattern”: “90 Percentile”, “thresholds”: [ “1000” ], “type”: “number”, “unit”: “ms” }, { “alias”: “”, “colorMode”: null, “colors”: [ “rgba(245, 54, 54, 0.9)”, “rgba(237, 129, 40, 0.89)”, “rgba(50, 172, 45, 0.97)” ], “dateFormat”: “YYYY-MM-DD HH:mm:ss”, “decimals”: 0, “pattern”: “Fail”, “thresholds”: [], “type”: “number”, “unit”: “none” }, { “alias”: “”, “colorMode”: null, “colors”: [ “rgba(50, 172, 45, 0.97)”, “#e24d42”, “rgba(245, 54, 54, 0.9)” ], “decimals”: 2, “link”: false, “pattern”: “/.*/”, “thresholds”: [ “3000” ], “type”: “number”, “unit”: “ms” } ], “targets”: [ { “groupBy”: [ { “params”: [ “transaction” ], “type”: “tag” } ], “measurement”: “/^$measurement_name$/”, “orderByTime”: “ASC”, “policy”: “default”, “refId”: “A”, “resultFormat”: “table”, “select”: [ [ { “params”: [ “avg” ], “type”: “field” }, { “params”: [], “type”: “mean” }, { “params”: [ “Average” ], “type”: “alias” } ], [ { “params”: [ “pct90.0” ], “type”: “field” }, { “params”: [], “type”: “last” }, { “params”: [ “90 Percentile” ], “type”: “alias” } ], [ { “params”: [ “max” ], “type”: “field” }, { “params”: [], “type”: “max” }, { “params”: [ “Max” ], “type”: “alias” } ], [ { “params”: [ “count” ], “type”: “field” }, { “params”: [], “type”: “sum” }, { “params”: [ “Pass” ], “type”: “alias” } ] ], “tags”: [ { “key”: “application”, “operator”: “=”, “value”: “/^$application$/” }, { “condition”: “AND”, “key”: “statut”, “operator”: “=”, “value”: “ok” } ] }, { “groupBy”: [ { “params”: [ “transaction” ], “type”: “tag” } ], “measurement”: “/^$measurement_name$/”, “orderByTime”: “ASC”, “policy”: “default”, “refId”: “B”, “resultFormat”: “table”, “select”: [ [ { “params”: [ “count” ], “type”: “field” }, { “params”: [], “type”: “sum” }, { “params”: [ “Fail” ], “type”: “alias” } ] ], “tags”: [ { “key”: “application”, “operator”: “=”, “value”: “/^$application$/” }, { “condition”: “AND”, “key”: “statut”, “operator”: “=”, “value”: “ko” } ] } ], “title”: “Transaction Response Times”, “transform”: “table”, “transparent”: false, “type”: “table” }, { “aliasColors”: { “banner”: “#508642” }, “bars”: false, “dashLength”: 10, “dashes”: false, “datasource”: “$data_source”, “decimals”: 2, “editable”: true, “error”: false, “fill”: 0, “gridPos”: { “h”: 7, “w”: 12, “x”: 0, “y”: 19 }, “height”: “”, “id”: 23, “interval”: “[[send_interval]]s”, “legend”: { “alignAsTable”: true, “avg”: false, “current”: false, “hideEmpty”: true, “hideZero”: true, “max”: false, “min”: false, “rightSide”: true, “show”: true, “sideWidth”: null, “total”: false, “values”: false }, “lines”: true, “linewidth”: 1, “links”: [], “nullPointMode”: “null”, “percentage”: false, “pointradius”: 1, “points”: false, “renderer”: “flot”, “seriesOverrides”: [], “spaceLength”: 10, “stack”: false, “steppedLine”: false, “targets”: [ { “alias”: “$tag_transaction”, “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “transaction” ], “type”: “tag” } ], “measurement”: “jmeter”, “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT mean("pct95.0") FROM "$measurement_name" WHERE ("statut" = ‘ok’ AND "application" = /^$application$/) AND $timeFilter GROUP BY "transaction", time($__interval) fill(null)”, “rawQuery”: false, “refId”: “B”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “pct90.0” ], “type”: “field” } ] ], “tags”: [ { “key”: “statut”, “operator”: “=”, “value”: “ok” }, { “condition”: “AND”, “key”: “application”, “operator”: “=”, “value”: “/^$application$/” } ] } ], “thresholds”: [ { “colorMode”: “ok”, “fill”: false, “line”: false, “op”: “lt”, “value”: 2500 }, { “colorMode”: “warning”, “fill”: false, “line”: false, “op”: “gt”, “value”: 2500 }, { “colorMode”: “critical”, “fill”: false, “line”: false, “op”: “gt”, “value”: 3000 } ], “timeFrom”: null, “timeShift”: null, “title”: “Transactions Response Times (90th percentile)”, “tooltip”: { “msResolution”: false, “shared”: true, “sort”: 0, “value_type”: “individual” }, “transparent”: false, “type”: “graph”, “xaxis”: { “buckets”: null, “mode”: “time”, “name”: null, “show”: true, “values”: [] }, “yaxes”: [ { “format”: “ms”, “label”: “Response Time”, “logBase”: 1, “max”: null, “min”: null, “show”: true }, { “format”: “short”, “label”: null, “logBase”: 1, “max”: null, “min”: null, “show”: false } ], “yaxis”: { “align”: false, “alignLevel”: null } }, { “aliasColors”: { “banner”: “#508642” }, “bars”: false, “dashLength”: 10, “dashes”: false, “datasource”: “$data_source”, “decimals”: 2, “editable”: true, “error”: false, “fill”: 0, “gridPos”: { “h”: 7, “w”: 12, “x”: 12, “y”: 19 }, “height”: “”, “id”: 50, “interval”: “[[send_interval]]s”, “legend”: { “alignAsTable”: true, “avg”: false, “current”: false, “hideEmpty”: true, “hideZero”: true, “max”: false, “min”: false, “rightSide”: true, “show”: true, “sideWidth”: null, “total”: false, “values”: false }, “lines”: true, “linewidth”: 1, “links”: [], “nullPointMode”: “null”, “percentage”: false, “pointradius”: 1, “points”: false, “renderer”: “flot”, “seriesOverrides”: [], “spaceLength”: 10, “stack”: false, “steppedLine”: false, “targets”: [ { “alias”: “$tag_transaction”, “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “transaction” ], “type”: “tag” } ], “hide”: false, “measurement”: “jmeter”, “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT mean("pct95.0") FROM "$measurement_name" WHERE ("statut" = ‘ok’ AND "application" = /^$application$/) AND $timeFilter GROUP BY "transaction", time($__interval) fill(null)”, “rawQuery”: false, “refId”: “B”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “avg” ], “type”: “field” } ] ], “tags”: [ { “key”: “statut”, “operator”: “=”, “value”: “ok” }, { “condition”: “AND”, “key”: “application”, “operator”: “=”, “value”: “/^$application$/” } ] } ], “thresholds”: [ { “colorMode”: “ok”, “fill”: false, “line”: false, “op”: “lt”, “value”: 2500 }, { “colorMode”: “warning”, “fill”: false, “line”: false, “op”: “gt”, “value”: 2500 }, { “colorMode”: “critical”, “fill”: false, “line”: false, “op”: “gt”, “value”: 3000 } ], “timeFrom”: null, “timeShift”: null, “title”: “Transactions Response Times (Average)”, “tooltip”: { “msResolution”: false, “shared”: true, “sort”: 0, “value_type”: “individual” }, “transparent”: false, “type”: “graph”, “xaxis”: { “buckets”: null, “mode”: “time”, “name”: null, “show”: true, “values”: [] }, “yaxes”: [ { “format”: “ms”, “label”: “Response Time”, “logBase”: 1, “max”: null, “min”: null, “show”: true }, { “format”: “short”, “label”: null, “logBase”: 1, “max”: null, “min”: null, “show”: false } ], “yaxis”: { “align”: false, “alignLevel”: null } }, { “aliasColors”: { “Hits per second”: “#f4d598”, “Num of Errors”: “#bf1b00”, “num of errors”: “#bf1b00” }, “bars”: false, “dashLength”: 10, “dashes”: false, “datasource”: “$data_source”, “decimals”: 0, “fill”: 1, “gridPos”: { “h”: 6, “w”: 12, “x”: 0, “y”: 26 }, “id”: 32, “interval”: “[[send_interval]]s”, “legend”: { “alignAsTable”: true, “avg”: true, “current”: true, “max”: false, “min”: false, “rightSide”: false, “show”: true, “total”: true, “values”: true }, “lines”: true, “linewidth”: 1, “links”: [], “nullPointMode”: “null”, “percentage”: false, “pointradius”: 1, “points”: false, “renderer”: “flot”, “seriesOverrides”: [], “spaceLength”: 10, “stack”: false, “steppedLine”: false, “targets”: [ { “alias”: “Hits per second”, “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “$__interval” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “hide”: false, “measurement”: “/^$measurement_name$/”, “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT sum("count") FROM "$measurement_name" WHERE "application" = /^$application$/ AND "transaction" = "all" AND "statut" = ‘ko’ AND $timeFilter GROUP BY time($__interval) fill(null)”, “rawQuery”: false, “refId”: “A”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “hit” ], “type”: “field” }, { “params”: [], “type”: “mean” } ] ], “tags”: [ { “key”: “application”, “operator”: “=”, “value”: “/^$application$/” } ] } ], “thresholds”: [], “timeFrom”: null, “timeShift”: null, “title”: “Hits per second”, “tooltip”: { “shared”: true, “sort”: 0, “value_type”: “individual” }, “type”: “graph”, “xaxis”: { “buckets”: 1, “mode”: “time”, “name”: null, “show”: true, “values”: [] }, “yaxes”: [ { “decimals”: 0, “format”: “short”, “label”: null, “logBase”: 1, “max”: null, “min”: null, “show”: true }, { “format”: “short”, “label”: null, “logBase”: 1, “max”: null, “min”: null, “show”: true } ], “yaxis”: { “align”: false, “alignLevel”: null } }, { “aliasColors”: { “Errors/sec”: “#bf1b00”, “Num of Errors”: “#bf1b00”, “num of errors”: “#bf1b00” }, “bars”: false, “dashLength”: 10, “dashes”: false, “datasource”: “$data_source”, “decimals”: 0, “fill”: 5, “gridPos”: { “h”: 6, “w”: 12, “x”: 12, “y”: 26 }, “id”: 43, “interval”: “[[send_interval]]s”, “legend”: { “alignAsTable”: true, “avg”: true, “current”: true, “max”: false, “min”: false, “rightSide”: false, “show”: true, “total”: true, “values”: true }, “lines”: true, “linewidth”: 1, “links”: [], “nullPointMode”: “null”, “percentage”: false, “pointradius”: 1, “points”: false, “renderer”: “flot”, “seriesOverrides”: [], “spaceLength”: 10, “stack”: false, “steppedLine”: false, “targets”: [ { “alias”: “Errors/sec”, “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “$__interval” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “hide”: false, “measurement”: “/^$measurement_name$/”, “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT sum("count") FROM "$measurement_name" WHERE "application" = /^$application$/ AND "transaction" = "all" AND "statut" = ‘ko’ AND $timeFilter GROUP BY time($__interval) fill(null)”, “rawQuery”: false, “refId”: “A”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “countError” ], “type”: “field” }, { “params”: [], “type”: “mean” } ] ], “tags”: [ { “key”: “application”, “operator”: “=”, “value”: “/^$application$/” } ] } ], “thresholds”: [], “timeFrom”: null, “timeShift”: null, “title”: “Errors”, “tooltip”: { “shared”: true, “sort”: 0, “value_type”: “individual” }, “type”: “graph”, “xaxis”: { “buckets”: 1, “mode”: “time”, “name”: null, “show”: true, “values”: [] }, “yaxes”: [ { “decimals”: 0, “format”: “short”, “label”: null, “logBase”: 1, “max”: null, “min”: null, “show”: true }, { “format”: “short”, “label”: null, “logBase”: 1, “max”: null, “min”: null, “show”: true } ], “yaxis”: { “align”: false, “alignLevel”: null } }, { “columns”: [], “datasource”: “$data_source”, “fontSize”: “100%”, “gridPos”: { “h”: 5, “w”: 24, “x”: 0, “y”: 32 }, “id”: 27, “interval”: “[[send_interval]]s”, “links”: [], “pageSize”: null, “scroll”: true, “showHeader”: true, “sort”: { “col”: 0, “desc”: true }, “styles”: [ { “alias”: “Time”, “dateFormat”: “YYYY-MM-DD HH:mm:ss”, “pattern”: “Time”, “type”: “hidden” }, { “alias”: “”, “colorMode”: null, “colors”: [ “rgba(245, 54, 54, 0.9)”, “rgba(237, 129, 40, 0.89)”, “rgba(50, 172, 45, 0.97)” ], “decimals”: 0, “pattern”: “/.*/”, “thresholds”: [], “type”: “number”, “unit”: “short” } ], “targets”: [ { “alias”: “$tag_responseCode”, “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “responseCode” ], “type”: “tag” }, { “params”: [ “responseMessage” ], “type”: “tag” } ], “measurement”: “/^$measurement_name$/”, “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT sum("count") FROM "$measurement_name" WHERE ("application" = /^$application$/ AND "responseCode" !~ /^$/) AND $timeFilter GROUP BY "responseCode","responseMessage"”, “rawQuery”: false, “refId”: “A”, “resultFormat”: “table”, “select”: [ [ { “params”: [ “count” ], “type”: “field” }, { “params”: [], “type”: “sum” } ] ], “tags”: [ { “key”: “application”, “operator”: “=”, “value”: “/^$application$/” }, { “condition”: “AND”, “key”: “responseCode”, “operator”: “=”, “value”: “/.*/” } ] } ], “title”: “Error Info”, “transform”: “table”, “transparent”: false, “type”: “table” }, { “collapsed”: false, “gridPos”: { “h”: 1, “w”: 24, “x”: 0, “y”: 37 }, “id”: 35, “panels”: [], “repeat”: null, “title”: “Individual Transaction Metrics - $transaction”, “type”: “row” }, { “cacheTimeout”: null, “colorBackground”: true, “colorValue”: false, “colors”: [ “#3f6833”, “#58140c”, “#58140c” ], “datasource”: “$data_source”, “decimals”: 2, “description”: “Shows the 90th percentile response time of the chosen transaction. (RED means it is breaching the SLA)”, “format”: “ms”, “gauge”: { “maxValue”: 100, “minValue”: 0, “show”: false, “thresholdLabels”: false, “thresholdMarkers”: false }, “gridPos”: { “h”: 6, “w”: 5, “x”: 0, “y”: 38 }, “height”: “”, “id”: 53, “interval”: “[[send_interval]]s”, “links”: [], “mappingType”: 1, “mappingTypes”: [ { “name”: “value to text”, “value”: 1 }, { “name”: “range to text”, “value”: 2 } ], “maxDataPoints”: 100, “minSpan”: 11, “nullPointMode”: “connected”, “nullText”: null, “postfix”: “”, “postfixFontSize”: “50%”, “prefix”: “”, “prefixFontSize”: “50%”, “rangeMaps”: [ { “from”: “null”, “text”: “N/A”, “to”: “null” } ], “repeatDirection”: “h”, “sparkline”: { “fillColor”: “rgba(31, 118, 189, 0.18)”, “full”: false, “lineColor”: “rgb(0, 191, 17)”, “show”: false }, “tableColumn”: “”, “targets”: [ { “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “$__interval” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “hide”: false, “measurement”: “/^$measurement_name$/”, “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT sum("count") FROM "$measurement_name" WHERE ("application" =~ /^$application$/ AND "transaction" =~ /^$transaction$/ AND "statut" = ‘ok’) AND $timeFilter GROUP BY time($__interval) fill(null)\n”, “rawQuery”: false, “refId”: “A”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “pct90.0” ], “type”: “field” }, { “params”: [], “type”: “last” } ] ], “tags”: [ { “key”: “application”, “operator”: “=”, “value”: “/^$application$/” }, { “condition”: “AND”, “key”: “transaction”, “operator”: “=”, “value”: “/^$transaction$/” }, { “condition”: “AND”, “key”: “statut”, “operator”: “=”, “value”: “ok” } ] } ], “thresholds”: “1000”, “title”: “Response Time (90th Percentile) - $transaction”, “transparent”: true, “type”: “singlestat”, “valueFontSize”: “70%”, “valueMaps”: [ { “op”: “=”, “text”: “0”, “value”: “null” } ], “valueName”: “current” }, { “cacheTimeout”: null, “colorBackground”: false, “colorValue”: true, “colors”: [ “#299c46”, “#e5ac0e”, “#d44a3a” ], “datasource”: “$data_source”, “decimals”: 0, “format”: “none”, “gauge”: { “maxValue”: 100, “minValue”: 0, “show”: false, “thresholdLabels”: false, “thresholdMarkers”: true }, “gridPos”: { “h”: 3, “w”: 7, “x”: 5, “y”: 38 }, “height”: “”, “id”: 46, “interval”: “[[send_interval]]s”, “links”: [], “mappingType”: 1, “mappingTypes”: [ { “name”: “value to text”, “value”: 1 }, { “name”: “range to text”, “value”: 2 } ], “maxDataPoints”: 100, “nullPointMode”: “connected”, “nullText”: null, “postfix”: " Requests", “postfixFontSize”: “50%”, “prefix”: “”, “prefixFontSize”: “50%”, “rangeMaps”: [ { “from”: “null”, “text”: “N/A”, “to”: “null” } ], “sparkline”: { “fillColor”: “rgba(31, 118, 189, 0.18)”, “full”: false, “lineColor”: “#e5ac0e”, “show”: false }, “tableColumn”: “”, “targets”: [ { “groupBy”: [ { “params”: [ “$__interval” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “measurement”: “/^$measurement_name$/”, “orderByTime”: “ASC”, “policy”: “default”, “refId”: “A”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “count” ], “type”: “field” }, { “params”: [], “type”: “sum” } ] ], “tags”: [ { “key”: “application”, “operator”: “=”, “value”: “/^$application$/” }, { “condition”: “AND”, “key”: “transaction”, “operator”: “=”, “value”: “/^$transaction$/” }, { “condition”: “AND”, “key”: “statut”, “operator”: “=”, “value”: “all” } ] } ], “thresholds”: “”, “title”: “Total Requests - $transaction”, “transparent”: true, “type”: “singlestat”, “valueFontSize”: “80%”, “valueMaps”: [ { “op”: “=”, “text”: “0”, “value”: “null” } ], “valueName”: “total” }, { “cacheTimeout”: null, “colorBackground”: false, “colorValue”: true, “colors”: [ “#e24d42”, “#ef843c”, “#299c46” ], “datasource”: “$data_source”, “decimals”: 2, “format”: “percentunit”, “gauge”: { “maxValue”: 1, “minValue”: 0, “show”: true, “thresholdLabels”: false, “thresholdMarkers”: true }, “gridPos”: { “h”: 6, “w”: 5, “x”: 13, “y”: 38 }, “id”: 47, “interval”: “[[send_interval]]s”, “links”: [], “mappingType”: 1, “mappingTypes”: [ { “name”: “value to text”, “value”: 1 }, { “name”: “range to text”, “value”: 2 } ], “maxDataPoints”: 100, “nullPointMode”: “connected”, “nullText”: null, “postfix”: “”, “postfixFontSize”: “50%”, “prefix”: “”, “prefixFontSize”: “50%”, “rangeMaps”: [ { “from”: “null”, “text”: “N/A”, “to”: “null” } ], “sparkline”: { “fillColor”: “rgba(31, 118, 189, 0.18)”, “full”: false, “lineColor”: “rgb(31, 120, 193)”, “show”: false }, “tableColumn”: “”, “targets”: [ { “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “$__interval” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT (sum("pass") /sum("all")) FROM (SELECT sum("count") AS "all" FROM "$measurement_name" WHERE "transaction" =~ /^$transaction$/ AND "application" =~ /^$application$/ AND "statut" = ‘all’ AND $timeFilter GROUP BY time($__interval) fill(null)), (SELECT sum("count") AS "pass" FROM "$measurement_name" WHERE "transaction" =~ /^$transaction$/ AND "application" =~ /^$application$/ AND "statut" = ‘ok’ AND $timeFilter GROUP BY time($__interval) fill(null))”, “rawQuery”: true, “refId”: “A”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “value” ], “type”: “field” }, { “params”: [], “type”: “mean” } ] ], “tags”: [] } ], “thresholds”: “0,0.01”, “title”: “Pass % - $transaction”, “transparent”: true, “type”: “singlestat”, “valueFontSize”: “50%”, “valueMaps”: [ { “op”: “=”, “text”: “0”, “value”: “null” } ], “valueName”: “total” }, { “cacheTimeout”: null, “colorBackground”: false, “colorValue”: true, “colors”: [ “#299c46”, “#ef843c”, “#e24d42” ], “datasource”: “$data_source”, “decimals”: 2, “format”: “percentunit”, “gauge”: { “maxValue”: 1, “minValue”: 0, “show”: true, “thresholdLabels”: false, “thresholdMarkers”: true }, “gridPos”: { “h”: 6, “w”: 5, “x”: 18, “y”: 38 }, “id”: 48, “interval”: “[[send_interval]]s”, “links”: [], “mappingType”: 1, “mappingTypes”: [ { “name”: “value to text”, “value”: 1 }, { “name”: “range to text”, “value”: 2 } ], “maxDataPoints”: 100, “nullPointMode”: “connected”, “nullText”: null, “postfix”: “”, “postfixFontSize”: “50%”, “prefix”: “”, “prefixFontSize”: “50%”, “rangeMaps”: [ { “from”: “null”, “text”: “N/A”, “to”: “null” } ], “sparkline”: { “fillColor”: “rgba(31, 118, 189, 0.18)”, “full”: false, “lineColor”: “rgb(31, 120, 193)”, “show”: false }, “tableColumn”: “”, “targets”: [ { “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “$__interval” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT sum("error") / sum("all") FROM (SELECT sum("count") AS "all" FROM "$measurement_name" WHERE "transaction" =~ /^$transaction$/ AND "application" =~ /^$application$/ AND "statut" = ‘all’ AND $timeFilter GROUP BY time($__interval) fill(null)), (SELECT sum("count") AS "error" FROM "$measurement_name" WHERE "transaction" =~ /^$transaction$/ AND "application" =~ /^$application$/ AND "statut" = ‘ko’ AND $timeFilter GROUP BY time($__interval) fill(null))”, “rawQuery”: true, “refId”: “A”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “value” ], “type”: “field” }, { “params”: [], “type”: “mean” } ] ], “tags”: [] } ], “thresholds”: “0,0.01”, “title”: “Fail % - $transaction”, “transparent”: true, “type”: “singlestat”, “valueFontSize”: “50%”, “valueMaps”: [ { “op”: “=”, “text”: “0”, “value”: “null” } ], “valueName”: “total” }, { “cacheTimeout”: null, “colorBackground”: false, “colorValue”: true, “colors”: [ “rgb(73, 222, 35)”, “rgb(69, 212, 31)”, “rgb(32, 212, 23)” ], “datasource”: “$data_source”, “decimals”: 0, “format”: “none”, “gauge”: { “maxValue”: 100, “minValue”: 0, “show”: false, “thresholdLabels”: false, “thresholdMarkers”: true }, “gridPos”: { “h”: 3, “w”: 4, “x”: 5, “y”: 41 }, “height”: “”, “id”: 44, “interval”: “[[send_interval]]s”, “links”: [], “mappingType”: 1, “mappingTypes”: [ { “name”: “value to text”, “value”: 1 }, { “name”: “range to text”, “value”: 2 } ], “maxDataPoints”: 100, “minSpan”: 11, “nullPointMode”: “connected”, “nullText”: null, “postfix”: " Passed", “postfixFontSize”: “50%”, “prefix”: “”, “prefixFontSize”: “50%”, “rangeMaps”: [ { “from”: “null”, “text”: “N/A”, “to”: “null” } ], “repeatDirection”: “h”, “sparkline”: { “fillColor”: “rgba(31, 118, 189, 0.18)”, “full”: false, “lineColor”: “rgb(0, 191, 17)”, “show”: false }, “tableColumn”: “”, “targets”: [ { “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “$__interval” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “hide”: false, “measurement”: “/^$measurement_name$/”, “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT sum("count") FROM "$measurement_name" WHERE ("application" =~ /^$application$/ AND "transaction" =~ /^$transaction$/ AND "statut" = ‘ok’) AND $timeFilter GROUP BY time($__interval) fill(null)\n”, “rawQuery”: false, “refId”: “A”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “count” ], “type”: “field” }, { “params”: [], “type”: “sum” } ] ], “tags”: [ { “key”: “application”, “operator”: “=”, “value”: “/^$application$/” }, { “condition”: “AND”, “key”: “transaction”, “operator”: “=”, “value”: “/^$transaction$/” }, { “condition”: “AND”, “key”: “statut”, “operator”: “=”, “value”: “ok” } ] } ], “thresholds”: “”, “title”: “Passed Requests - $transaction”, “transparent”: true, “type”: “singlestat”, “valueFontSize”: “50%”, “valueMaps”: [ { “op”: “=”, “text”: “0”, “value”: “null” } ], “valueName”: “total” }, { “cacheTimeout”: null, “colorBackground”: false, “colorValue”: true, “colors”: [ “#299c46”, “#e24d42”, “#d44a3a” ], “datasource”: “$data_source”, “decimals”: 0, “format”: “none”, “gauge”: { “maxValue”: 100, “minValue”: 0, “show”: false, “thresholdLabels”: false, “thresholdMarkers”: true }, “gridPos”: { “h”: 3, “w”: 3, “x”: 9, “y”: 41 }, “height”: “”, “id”: 45, “interval”: “[[send_interval]]s”, “links”: [], “mappingType”: 1, “mappingTypes”: [ { “name”: “value to text”, “value”: 1 }, { “name”: “range to text”, “value”: 2 } ], “maxDataPoints”: 100, “nullPointMode”: “connected”, “nullText”: null, “postfix”: " Failed", “postfixFontSize”: “50%”, “prefix”: “”, “prefixFontSize”: “50%”, “rangeMaps”: [ { “from”: “null”, “text”: “N/A”, “to”: “null” } ], “sparkline”: { “fillColor”: “rgba(31, 118, 189, 0.18)”, “full”: true, “lineColor”: “#bf1b00”, “show”: false }, “tableColumn”: “”, “targets”: [ { “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “$__interval” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “measurement”: “/^$measurement_name$/”, “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT sum("count") FROM "$measurement_name" WHERE ("application" =~ /^$application$/ AND "transaction" =~ /^$transaction$/ AND "statut" = ‘ko’) AND $timeFilter GROUP BY time($__interval) fill(null)”, “rawQuery”: false, “refId”: “A”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “count” ], “type”: “field” }, { “params”: [], “type”: “sum” } ] ], “tags”: [ { “key”: “application”, “operator”: “=”, “value”: “/^$application$/” }, { “condition”: “AND”, “key”: “transaction”, “operator”: “=”, “value”: “/^$transaction$/” }, { “condition”: “AND”, “key”: “statut”, “operator”: “=”, “value”: “ko” } ] } ], “thresholds”: “”, “title”: “Failed Requests - $transaction”, “transparent”: true, “type”: “singlestat”, “valueFontSize”: “50%”, “valueMaps”: [ { “op”: “=”, “text”: “0”, “value”: “null” } ], “valueName”: “total” }, { “aliasColors”: { “90th Percentage”: “#f2c96d”, “90th Percentile”: “#447ebc”, “95th Percentage”: “#EF843C”, “99th Percentage”: “#bf1b00”, “99th Percentile”: “#614d93”, “Average”: “#508642”, “Max”: “#962d82”, “Median”: “#6ed0e0”, “median”: “#6ed0e0” }, “bars”: false, “dashLength”: 10, “dashes”: false, “datasource”: “$data_source”, “decimals”: 2, “editable”: true, “error”: false, “fill”: 0, “gridPos”: { “h”: 7, “w”: 24, “x”: 0, “y”: 44 }, “height”: “”, “id”: 5, “interval”: “[[send_interval]]s”, “legend”: { “alignAsTable”: true, “avg”: true, “current”: true, “hideEmpty”: true, “max”: true, “min”: false, “rightSide”: true, “show”: true, “sortDesc”: true, “total”: false, “values”: true }, “lines”: true, “linewidth”: 2, “links”: [], “nullPointMode”: “null”, “percentage”: false, “pointradius”: 1, “points”: false, “renderer”: “flot”, “seriesOverrides”: [ { “alias”: “Average”, “yaxis”: 1 } ], “spaceLength”: 10, “stack”: false, “steppedLine”: false, “targets”: [ { “alias”: “Median”, “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “$aggregation” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “hide”: false, “measurement”: “jmeter”, “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT last("pct50.0") FROM "$measurement_name" WHERE ("transaction" =~ /^$transaction$/ AND "statut" = ‘ok’) AND $timeFilter GROUP BY time($__interval)”, “rawQuery”: true, “refId”: “F”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “pct50.0” ], “type”: “field” }, { “params”: [], “type”: “last” } ] ], “tags”: [ { “key”: “transaction”, “operator”: “=”, “value”: “/^$request$/” }, { “condition”: “AND”, “key”: “statut”, “operator”: “=”, “value”: “all” } ] }, { “alias”: “90th Percentile”, “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “$aggregation” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “measurement”: “jmeter”, “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT last("pct90.0") FROM "$measurement_name" WHERE ("transaction" = /^$transaction$/ AND "statut" = ‘ok’) AND $timeFilter GROUP BY time($__interval) fill(null)”, “rawQuery”: true, “refId”: “B”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “pct90.0” ], “type”: “field” }, { “params”: [], “type”: “last” } ] ], “tags”: [ { “key”: “transaction”, “operator”: “=”, “value”: “/^$request$/” }, { “condition”: “AND”, “key”: “statut”, “operator”: “=”, “value”: “all” } ] }, { “alias”: “95th Percentile”, “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “$aggregation” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “hide”: false, “measurement”: “jmeter”, “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT last("pct95.0") FROM "$measurement_name" WHERE ("transaction" = /^$transaction$/ AND "statut" = ‘ok’) AND $timeFilter GROUP BY time($__interval) fill(null)”, “rawQuery”: true, “refId”: “C”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “pct95.0” ], “type”: “field” }, { “params”: [], “type”: “last” } ] ], “tags”: [ { “key”: “transaction”, “operator”: “=”, “value”: “/^$request$/” } ] }, { “alias”: “99th Percentile”, “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “$aggregation” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “hide”: false, “measurement”: “jmeter”, “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT last("pct99.0") FROM "$measurement_name" WHERE ("transaction" = /^$transaction$/ AND "statut" = ‘ok’) AND $timeFilter GROUP BY time($__interval) fill(null)”, “rawQuery”: true, “refId”: “D”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “pct99.0” ], “type”: “field” }, { “params”: [], “type”: “last” } ] ], “tags”: [ { “key”: “transaction”, “operator”: “=”, “value”: “/^$request$/” } ] }, { “alias”: “Max”, “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “$aggregation” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “measurement”: “jmeter”, “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT last("max") FROM "$measurement_name" WHERE ("transaction" = /^$transaction$/ AND "statut" = ‘ok’) AND $timeFilter GROUP BY time($__interval) fill(null)”, “rawQuery”: true, “refId”: “E”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “max” ], “type”: “field” }, { “params”: [], “type”: “last” } ] ], “tags”: [ { “key”: “transaction”, “operator”: “=”, “value”: “/^$request$/” }, { “condition”: “AND”, “key”: “statut”, “operator”: “=”, “value”: “ok” } ] }, { “alias”: “Average”, “groupBy”: [ { “params”: [ “$__interval” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “measurement”: “/^$measurement_name$/”, “orderByTime”: “ASC”, “policy”: “default”, “refId”: “A”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “avg” ], “type”: “field” }, { “params”: [], “type”: “last” } ] ], “tags”: [ { “key”: “application”, “operator”: “=”, “value”: “/^$application$/” }, { “condition”: “AND”, “key”: “transaction”, “operator”: “=”, “value”: “/^$transaction$/” }, { “condition”: “AND”, “key”: “statut”, “operator”: “=”, “value”: “ok” } ] } ], “thresholds”: [], “timeFrom”: null, “timeShift”: null, “title”: “Response Times - $transaction”, “tooltip”: { “msResolution”: false, “shared”: true, “sort”: 0, “value_type”: “individual” }, “type”: “graph”, “xaxis”: { “buckets”: null, “mode”: “time”, “name”: null, “show”: true, “values”: [] }, “yaxes”: [ { “format”: “ms”, “label”: null, “logBase”: 1, “max”: null, “min”: null, “show”: true }, { “format”: “short”, “label”: null, “logBase”: 1, “max”: null, “min”: null, “show”: false } ], “yaxis”: { “align”: false, “alignLevel”: null } }, { “aliasColors”: { “90th Percentage”: “#EAB839”, “95th Percentage”: “#EF843C”, “99th Percentage”: “#99440A”, “Average”: “#3F6833”, “Max”: “#58140C”, “Req / s”: “#6ed0e0” }, “bars”: false, “dashLength”: 10, “dashes”: false, “datasource”: “$data_source”, “decimals”: 2, “editable”: true, “error”: false, “fill”: 7, “gridPos”: { “h”: 6, “w”: 12, “x”: 0, “y”: 51 }, “height”: “”, “id”: 10, “interval”: “[[send_interval]]s”, “legend”: { “alignAsTable”: true, “avg”: true, “current”: false, “max”: true, “min”: true, “rightSide”: false, “show”: true, “total”: false, “values”: true }, “lines”: true, “linewidth”: 1, “links”: [], “nullPointMode”: “null”, “percentage”: false, “pointradius”: 1, “points”: false, “renderer”: “flot”, “seriesOverrides”: [ { “alias”: “Average”, “yaxis”: 1 } ], “spaceLength”: 10, “stack”: false, “steppedLine”: false, “targets”: [ { “alias”: “Req / s”, “dsType”: “influxdb”, “groupBy”: [ { “params”: [ “$__interval” ], “type”: “time” } ], “measurement”: “jmeter”, “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT last("count") / $send_interval FROM "$measurement_name" WHERE ("transaction" = /^$transaction$/ AND "statut" = ‘ok’) AND $timeFilter GROUP BY time($__interval)”, “rawQuery”: true, “refId”: “B”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “count” ], “type”: “field” }, { “params”: [], “type”: “sum” }, { “params”: [ “5s” ], “type”: “non_negative_derivative” } ] ], “tags”: [ { “key”: “transaction”, “operator”: “=”, “value”: “/^$transaction$/” }, { “condition”: “AND”, “key”: “statut”, “operator”: “=”, “value”: “ok” } ] } ], “thresholds”: [], “timeFrom”: null, “timeShift”: null, “title”: “Transactions per second - $transaction”, “tooltip”: { “msResolution”: false, “shared”: true, “sort”: 0, “value_type”: “individual” }, “type”: “graph”, “xaxis”: { “buckets”: null, “mode”: “time”, “name”: null, “show”: true, “values”: [] }, “yaxes”: [ { “format”: “short”, “label”: null, “logBase”: 1, “max”: null, “min”: null, “show”: true }, { “format”: “short”, “label”: null, “logBase”: 1, “max”: null, “min”: null, “show”: false } ], “yaxis”: { “align”: false, “alignLevel”: null } }, { “aliasColors”: { “Errors/sec”: “#bf1b00”, “Num of Errors”: “#bf1b00”, “jmeter.last”: “#bf1b00”, “num of errors”: “#bf1b00” }, “bars”: false, “dashLength”: 10, “dashes”: false, “datasource”: “$data_source”, “decimals”: 0, “fill”: 1, “gridPos”: { “h”: 6, “w”: 12, “x”: 12, “y”: 51 }, “id”: 49, “interval”: “[[send_interval]]s”, “legend”: { “alignAsTable”: true, “avg”: true, “current”: true, “max”: false, “min”: false, “rightSide”: false, “show”: true, “total”: true, “values”: true }, “lines”: true, “linewidth”: 1, “links”: [], “nullPointMode”: “null”, “percentage”: false, “pointradius”: 1, “points”: false, “renderer”: “flot”, “seriesOverrides”: [], “spaceLength”: 10, “stack”: false, “steppedLine”: false, “targets”: [ { “groupBy”: [ { “params”: [ “$__interval” ], “type”: “time” }, { “params”: [ “null” ], “type”: “fill” } ], “orderByTime”: “ASC”, “policy”: “default”, “query”: “SELECT last("count") / $send_interval FROM "$measurement_name" WHERE ("transaction" = /^$transaction$/ AND "statut" = ‘ko’) AND $timeFilter GROUP BY time($__interval)”, “rawQuery”: true, “refId”: “A”, “resultFormat”: “time_series”, “select”: [ [ { “params”: [ “value” ], “type”: “field” }, { “params”: [], “type”: “mean” } ] ], “tags”: [] } ], “thresholds”: [], “timeFrom”: null, “timeShift”: null, “title”: “Errors - $transaction”, “tooltip”: { “shared”: true, “sort”: 0, “value_type”: “individual” }, “type”: “graph”, “xaxis”: { “buckets”: 1, “mode”: “time”, “name”: null, “show”: true, “values”: [] }, “yaxes”: [ { “decimals”: 0, “format”: “short”, “label”: null, “logBase”: 1, “max”: null, “min”: null, “show”: true }, { “format”: “short”, “label”: null, “logBase”: 1, “max”: null, “min”: null, “show”: true } ], “yaxis”: { “align”: false, “alignLevel”: null } } ], “refresh”: false, “schemaVersion”: 16, “style”: “dark”, “tags”: [], “templating”: { “list”: [ { “current”: { “selected”: true, “text”: “TIAA”, “value”: “TIAA” }, “hide”: 0, “label”: “Data Source”, “name”: “data_source”, “options”: [], “query”: “influxdb”, “refresh”: 1, “regex”: “”, “type”: “datasource” }, { “current”: { “value”: “${VAR_MEASUREMENT_NAME}”, “text”: “${VAR_MEASUREMENT_NAME}” }, “hide”: 2, “label”: “Measurement name”, “name”: “measurement_name”, “options”: [ { “value”: “${VAR_MEASUREMENT_NAME}”, “text”: “${VAR_MEASUREMENT_NAME}” } ], “query”: “${VAR_MEASUREMENT_NAME}”, “type”: “constant” }, { “allValue”: null, “current”: {}, “datasource”: “$data_source”, “hide”: 0, “includeAll”: false, “label”: “Application Tested”, “multi”: false, “name”: “application”, “options”: [], “query”: “SHOW TAG VALUES FROM "$measurement_name" WITH KEY = "application"”, “refresh”: 1, “regex”: “”, “sort”: 0, “tagValuesQuery”: null, “tags”: [], “tagsQuery”: null, “type”: “query”, “useTags”: false }, { “allValue”: null, “current”: {}, “datasource”: “$data_source”, “hide”: 0, “includeAll”: false, “label”: “Transaction to be shown in transaction level metrics panel”, “multi”: true, “name”: “transaction”, “options”: [], “query”: “SHOW TAG VALUES FROM "$measurement_name" WITH KEY = "transaction" WHERE "application" =~ /^$application$/ AND "transaction" != ‘internal’ AND "transaction" != ‘all’”, “refresh”: 1, “regex”: “”, “sort”: 0, “tagValuesQuery”: null, “tags”: [], “tagsQuery”: null, “type”: “query”, “useTags”: false }, { “current”: { “value”: “${VAR_SEND_INTERVAL}”, “text”: “${VAR_SEND_INTERVAL}” }, “hide”: 2, “label”: “Backend send interval in second”, “name”: “send_interval”, “options”: [ { “value”: “${VAR_SEND_INTERVAL}”, “text”: “${VAR_SEND_INTERVAL}” } ], “query”: “${VAR_SEND_INTERVAL}”, “type”: “constant” } ] }, “time”: { “from”: “2018-09-05T07:53:00.000Z”, “to”: “2018-09-05T08:53:30.000Z” }, “timepicker”: { “refresh_intervals”: [ “5s”, “10s”, “30s”, “1m”, “5m”, “15m”, “30m”, “1h”, “2h”, “1d” ], “time_options”: [ “5m”, “15m”, “1h”, “6h”, “12h”, “24h”, “2d”, “7d”, “30d” ] }, “timezone”: “browser”, “title”: “JMeter_Dasboard_Full_Details”, “uid”: “tN6XJ7Diz”, “version”: 5 }