How to create a table with multiple fields using UQL

  • What Grafana version and what operating system are you using?
    Grafana v10.2.2

  • What are you trying to achieve?
    i am trying to create a table from a json response using UQL with Infinity datasource.

how do i create a table containing 3 columns flattenedHierarchy ,time ,averageResponseTime . this json is a huge file i have only attached a sample.

  • Using this below UQL to try to achieve the above.
    parse-json
    | jsonata "*.time"
    | project "minute","time","metrics"

output table using above UQL:

Sample JSON data:
{
“flattenedHierarchies”: [
{
“containerType”: “transaction”,
“flattenedHierarchy”: “SC05 - Jackpot Bet v1.0/APP_01_Open App”,
“time”: [
{
“metrics”: {
“averageResponseTime”: 427,
“bytesReceived”: 8592992,
“bytesSent”: 408120,
“completed”: 32,
“effectiveDuration”: 410388,
“effectiveDurationStandardOfDeviation”: 1595.8484054988849,
“errors”: 0,
“fullDuration”: 411925,
“maxEffectiveDuration”: 9254,
“maxResponseTime”: 4166,
“minEffectiveDuration”: 4189,
“minResponseTime”: 9,
“percentiles”: [
{
“percentile”: 95,
“value”: 9150
}
],
“started”: 60,
“totalHtmlPageResponseTime”: 410388,
“totalHtmlPageTTFB”: 406335,
“totalHtmlResponseCount”: 960,
“totalResponseCount”: 960,
“totalResponseTime”: 410388,
“tps”: 0.04020110603292973
},
“minute”: “1”,
“time”: “2023-10-27T05:53:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 560,
“bytesReceived”: 4086508,
“bytesSent”: 204060,
“completed”: 58,
“effectiveDuration”: 268734,
“effectiveDurationStandardOfDeviation”: 1106.6570983522101,
“errors”: 0,
“fullDuration”: 269459,
“maxEffectiveDuration”: 10114,
“maxResponseTime”: 5254,
“minEffectiveDuration”: 5800,
“minResponseTime”: 11,
“percentiles”: [
{
“percentile”: 95,
“value”: 10057
}
],
“started”: 30,
“totalHtmlPageResponseTime”: 268734,
“totalHtmlPageTTFB”: 266424,
“totalHtmlResponseCount”: 480,
“totalResponseCount”: 480,
“totalResponseTime”: 268734,
“tps”: 0.07286450468468514
},
“minute”: “2”,
“time”: “2023-10-27T05:54:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 1168,
“bytesReceived”: 8599404,
“bytesSent”: 408120,
“completed”: 34,
“effectiveDuration”: 1121369,
“effectiveDurationStandardOfDeviation”: 4112.670051195451,
“errors”: 0,
“fullDuration”: 1122856,
“maxEffectiveDuration”: 25584,
“maxResponseTime”: 13986,
“minEffectiveDuration”: 9058,
“minResponseTime”: 11,
“percentiles”: [
{
“percentile”: 95,
“value”: 25114
}
],
“started”: 60,
“totalHtmlPageResponseTime”: 1121369,
“totalHtmlPageTTFB”: 1113040,
“totalHtmlResponseCount”: 960,
“totalResponseCount”: 960,
“totalResponseTime”: 1121369,
“tps”: 0.04271367515998784
},
“minute”: “3”,
“time”: “2023-10-27T05:55:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 2021,
“bytesReceived”: 6615594,
“bytesSent”: 292486,
“completed”: 54,
“effectiveDuration”: 1390226,
“effectiveDurationStandardOfDeviation”: 3813.8631394573704,
“errors”: 0,
“fullDuration”: 1391373,
“maxEffectiveDuration”: 38418,
“maxResponseTime”: 17450,
“minEffectiveDuration”: 20861,
“minResponseTime”: 11,
“percentiles”: [
{
“percentile”: 95,
“value”: 37599
}
],
“started”: 43,
“totalHtmlPageResponseTime”: 1390226,
“totalHtmlPageTTFB”: 1381871,
“totalHtmlResponseCount”: 688,
“totalResponseCount”: 688,
“totalResponseTime”: 1390226,
“tps”: 0.06783936643056893
},
“minute”: “4”,
“time”: “2023-10-27T05:56:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 3361,
“bytesReceived”: 7669754,
“bytesSent”: 319694,
“completed”: 32,
“effectiveDuration”: 2527386,
“effectiveDurationStandardOfDeviation”: 13392.077389580401,
“errors”: 0,
“fullDuration”: 2529037,
“maxEffectiveDuration”: 69340,
“maxResponseTime”: 32122,
“minEffectiveDuration”: 28125,
“minResponseTime”: 11,
“percentiles”: [
{
“percentile”: 95,
“value”: 68420
}
],
“started”: 47,
“totalHtmlPageResponseTime”: 2527386,
“totalHtmlPageTTFB”: 2513383,
“totalHtmlResponseCount”: 752,
“totalResponseCount”: 752,
“totalResponseTime”: 2527386,
“tps”: 0.04020110603292973
},
“minute”: “5”,
“time”: “2023-10-27T05:57:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 6122,
“bytesReceived”: 10513265,
“bytesSent”: 408120,
“completed”: 30,
“effectiveDuration”: 5877514,
“effectiveDurationStandardOfDeviation”: 13485.939103377264,
“errors”: 0,
“fullDuration”: 5879596,
“maxEffectiveDuration”: 121050,
“maxResponseTime”: 54541,
“minEffectiveDuration”: 72814,
“minResponseTime”: 11,
“percentiles”: [
{
“percentile”: 95,
“value”: 119999
}
],
“started”: 60,
“totalHtmlPageResponseTime”: 5877514,
“totalHtmlPageTTFB”: 5850486,
“totalHtmlResponseCount”: 960,
“totalResponseCount”: 960,
“totalResponseTime”: 5877514,
“tps”: 0.03768853690587162
},
“minute”: “6”,
“time”: “2023-10-27T05:58:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 10829,
“bytesReceived”: 1952726,
“bytesSent”: 164234,
“completed”: 30,
“effectiveDuration”: 4082485,
“effectiveDurationStandardOfDeviation”: 5702.979273480661,
“errors”: 15,
“fullDuration”: 4083225,
“maxEffectiveDuration”: 136212,
“maxResponseTime”: 60831,
“minEffectiveDuration”: 121079,
“minResponseTime”: 11,
“percentiles”: [
{
“percentile”: 95,
“value”: 134687
}
],
“started”: 32,
“totalHtmlPageResponseTime”: 4082485,
“totalHtmlPageTTFB”: 4077636,
“totalHtmlResponseCount”: 377,
“totalResponseCount”: 377,
“totalResponseTime”: 4082485,
“tps”: 0.03768853690587162
},
“minute”: “7”,
“time”: “2023-10-27T05:59:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 12225,
“bytesReceived”: 1404428,
“bytesSent”: 248474,
“completed”: 30,
“effectiveDuration”: 6834033,
“effectiveDurationStandardOfDeviation”: 7798.784643378294,
“errors”: 41,
“fullDuration”: 6834792,
“maxEffectiveDuration”: 123667,
“maxResponseTime”: 60921,
“minEffectiveDuration”: 83566,
“minResponseTime”: 11,
“percentiles”: [
{
“percentile”: 95,
“value”: 123399
}
],
“started”: 58,
“totalHtmlPageResponseTime”: 6834033,
“totalHtmlPageTTFB”: 6832309,
“totalHtmlResponseCount”: 559,
“totalResponseCount”: 559,
“totalResponseTime”: 6834033,
“tps”: 0.03768853690587162
},
“minute”: “8”,
“time”: “2023-10-27T06:00:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 8624,
“bytesReceived”: 3293746,
“bytesSent”: 453802,
“completed”: 35,
“effectiveDuration”: 9141584,
“effectiveDurationStandardOfDeviation”: 27725.62497411879,
“errors”: 12,
“fullDuration”: 9142970,
“maxEffectiveDuration”: 262717,
“maxResponseTime”: 113573,
“minEffectiveDuration”: 83099,
“minResponseTime”: 11,
“percentiles”: [
{
“percentile”: 95,
“value”: 176666
}
],
“started”: 73,
“totalHtmlPageResponseTime”: 9141584,
“totalHtmlPageTTFB”: 9135659,
“totalHtmlResponseCount”: 1060,
“totalResponseCount”: 1060,
“totalResponseTime”: 9141584,
“tps”: 0.043969959723516895
},
“minute”: “9”,
“time”: “2023-10-27T06:01:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 9503,
“bytesReceived”: 3296944,
“bytesSent”: 442506,
“completed”: 60,
“effectiveDuration”: 9864278,
“effectiveDurationStandardOfDeviation”: 35197.976242999255,
“errors”: 11,
“fullDuration”: 10014440,
“maxEffectiveDuration”: 214465,
“maxResponseTime”: 111944,
“minEffectiveDuration”: 82420,
“minResponseTime”: 11,
“percentiles”: [
{
“percentile”: 95,
“value”: 199285
}
],
“started”: 73,
“totalHtmlPageResponseTime”: 9864278,
“totalHtmlPageTTFB”: 9858174,
“totalHtmlResponseCount”: 1032,
“totalResponseCount”: 1038,
“totalResponseTime”: 9864278,
“tps”: 0.07537707381174324
},
“minute”: “10”,
“time”: “2023-10-27T06:02:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 10505,
“bytesReceived”: 2559084,
“bytesSent”: 325776,
“completed”: 60,
“effectiveDuration”: 8078627,
“effectiveDurationStandardOfDeviation”: 35894.23219324275,
“errors”: 11,
“fullDuration”: 9143196,
“maxEffectiveDuration”: 196567,
“maxResponseTime”: 114242,
“minEffectiveDuration”: 62437,
“minResponseTime”: 11,
“percentiles”: [
{
“percentile”: 95,
“value”: 184999
}
],
“started”: 66,
“totalHtmlPageResponseTime”: 8078627,
“totalHtmlPageTTFB”: 8073400,
“totalHtmlResponseCount”: 749,
“totalResponseCount”: 769,
“totalResponseTime”: 8078627,
“tps”: 0.07537707381174324
},
“minute”: “11”,
“time”: “2023-10-27T06:03:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 8803,
“bytesReceived”: 1732362,
“bytesSent”: 237945,
“completed”: 66,
“effectiveDuration”: 5308203,
“effectiveDurationStandardOfDeviation”: 41206.16987383143,
“errors”: 0,
“fullDuration”: 7716225,
“maxEffectiveDuration”: 124677,
“maxResponseTime”: 115889,
“minEffectiveDuration”: 49363,
“minResponseTime”: 0,
“percentiles”: [
{
“percentile”: 95,
“value”: 123274
}
],
“started”: 76,
“totalHtmlPageResponseTime”: 5308203,
“totalHtmlPageTTFB”: 5305452,
“totalHtmlResponseCount”: 538,
“totalResponseCount”: 603,
“totalResponseTime”: 5308203,
“tps”: 0.08291478119291756
},
“minute”: “12”,
“time”: “2023-10-27T06:04:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 792,
“bytesReceived”: 348155,
“bytesSent”: 54344,
“completed”: 49,
“effectiveDuration”: 121963,
“effectiveDurationStandardOfDeviation”: 9717.000629052156,
“errors”: 0,
“fullDuration”: 1863644,
“maxEffectiveDuration”: 63375,
“maxResponseTime”: 60064,
“minEffectiveDuration”: 1365,
“minResponseTime”: 0,
“percentiles”: [
{
“percentile”: 95,
“value”: 3219
}
],
“started”: 40,
“totalHtmlPageResponseTime”: 121963,
“totalHtmlPageTTFB”: 121751,
“totalHtmlResponseCount”: 114,
“totalResponseCount”: 154,
“totalResponseTime”: 121963,
“tps”: 0.06155794361292365
},
“minute”: “13”,
“time”: “2023-10-27T06:05:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 398,
“bytesReceived”: 246625,
“bytesSent”: 37378,
“completed”: 186,
“effectiveDuration”: 46121,
“effectiveDurationStandardOfDeviation”: 1229.1654314593852,
“errors”: 0,
“fullDuration”: 410094,
“maxEffectiveDuration”: 3311,
“maxResponseTime”: 1671,
“minEffectiveDuration”: 574,
“minResponseTime”: 0,
“percentiles”: [
{
“percentile”: 95,
“value”: 3189
}
],
“started”: 38,
“totalHtmlPageResponseTime”: 46121,
“totalHtmlPageTTFB”: 46082,
“totalHtmlResponseCount”: 78,
“totalResponseCount”: 116,
“totalResponseTime”: 46121,
“tps”: 0.23366892881640405
},
“minute”: “14”,
“time”: “2023-10-27T06:06:21.119+00:00”
}
]
},
{
“containerType”: “transaction”,
“flattenedHierarchy”: “SC05 - Jackpot Bet v1.0/Repeat in same Session/If BetId exist/Open and Place JP Bet/APP_21_Open JackPot Bet”,
“time”: [
{
“metrics”: {
“averageResponseTime”: 119,
“bytesReceived”: 254941,
“bytesSent”: 32112,
“completed”: 36,
“effectiveDuration”: 8561,
“effectiveDurationStandardOfDeviation”: 117.01911050004705,
“errors”: 0,
“fullDuration”: 8758,
“maxEffectiveDuration”: 810,
“maxResponseTime”: 501,
“minEffectiveDuration”: 116,
“minResponseTime”: 47,
“percentiles”: [
{
“percentile”: 95,
“value”: 339
}
],
“started”: 36,
“totalHtmlPageResponseTime”: 8561,
“totalHtmlPageTTFB”: 8486,
“totalHtmlResponseCount”: 72,
“totalResponseCount”: 72,
“totalResponseTime”: 8561,
“tps”: 0.04522624428704595
},
“minute”: “1”,
“time”: “2023-10-27T05:53:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 189,
“bytesReceived”: 1056339,
“bytesSent”: 125772,
“completed”: 140,
“effectiveDuration”: 53353,
“effectiveDurationStandardOfDeviation”: 310.8526252260532,
“errors”: 0,
“fullDuration”: 54052,
“maxEffectiveDuration”: 3368,
“maxResponseTime”: 3037,
“minEffectiveDuration”: 131,
“minResponseTime”: 57,
“percentiles”: [
{
“percentile”: 95,
“value”: 819
}
],
“started”: 141,
“totalHtmlPageResponseTime”: 53353,
“totalHtmlPageTTFB”: 52894,
“totalHtmlResponseCount”: 282,
“totalResponseCount”: 282,
“totalResponseTime”: 53353,
“tps”: 0.17587983889406758
},
“minute”: “2”,
“time”: “2023-10-27T05:54:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 381,
“bytesReceived”: 1457943,
“bytesSent”: 167696,
“completed”: 184,
“effectiveDuration”: 143175,
“effectiveDurationStandardOfDeviation”: 497.7296380096241,
“errors”: 0,
“fullDuration”: 144050,
“maxEffectiveDuration”: 2734,
“maxResponseTime”: 2024,
“minEffectiveDuration”: 195,
“minResponseTime”: 69,
“percentiles”: [
{
“percentile”: 95,
“value”: 1689
}
],
“started”: 188,
“totalHtmlPageResponseTime”: 143175,
“totalHtmlPageTTFB”: 141673,
“totalHtmlResponseCount”: 376,
“totalResponseCount”: 376,
“totalResponseTime”: 143175,
“tps”: 0.23115635968934595
},
“minute”: “3”,
“time”: “2023-10-27T05:55:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 752,
“bytesReceived”: 1720150,
“bytesSent”: 189104,
“completed”: 211,
“effectiveDuration”: 318858,
“effectiveDurationStandardOfDeviation”: 767.7155465257679,
“errors”: 0,
“fullDuration”: 319908,
“maxEffectiveDuration”: 4435,
“maxResponseTime”: 3110,
“minEffectiveDuration”: 329,
“minResponseTime”: 95,
“percentiles”: [
{
“percentile”: 95,
“value”: 2919
}
],
“started”: 212,
“totalHtmlPageResponseTime”: 318858,
“totalHtmlPageTTFB”: 316201,
“totalHtmlResponseCount”: 424,
“totalResponseCount”: 424,
“totalResponseTime”: 318858,
“tps”: 0.26507604290463044
},
“minute”: “4”,
“time”: “2023-10-27T05:56:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 1292,
“bytesReceived”: 2376976,
“bytesSent”: 247976,
“completed”: 274,
“effectiveDuration”: 718375,
“effectiveDurationStandardOfDeviation”: 999.1041076812824,
“errors”: 0,
“fullDuration”: 720123,
“maxEffectiveDuration”: 5217,
“maxResponseTime”: 3912,
“minEffectiveDuration”: 791,
“minResponseTime”: 193,
“percentiles”: [
{
“percentile”: 95,
“value”: 4510
}
],
“started”: 278,
“totalHtmlPageResponseTime”: 718375,
“totalHtmlPageTTFB”: 713430,
“totalHtmlResponseCount”: 556,
“totalResponseCount”: 556,
“totalResponseTime”: 718375,
“tps”: 0.34422197040696084
},
“minute”: “5”,
“time”: “2023-10-27T05:57:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 2416,
“bytesReceived”: 2206994,
“bytesSent”: 220324,
“completed”: 223,
“effectiveDuration”: 1193287,
“effectiveDurationStandardOfDeviation”: 1511.556778535574,
“errors”: 0,
“fullDuration”: 1195296,
“maxEffectiveDuration”: 9326,
“maxResponseTime”: 6552,
“minEffectiveDuration”: 1702,
“minResponseTime”: 471,
“percentiles”: [
{
“percentile”: 95,
“value”: 7449
}
],
“started”: 247,
“totalHtmlPageResponseTime”: 1193287,
“totalHtmlPageTTFB”: 1188854,
“totalHtmlResponseCount”: 494,
“totalResponseCount”: 494,
“totalResponseTime”: 1193287,
“tps”: 0.2801514576669791
},
“minute”: “6”,
“time”: “2023-10-27T05:58:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 3323,
“bytesReceived”: 2124745,
“bytesSent”: 201592,
“completed”: 227,
“effectiveDuration”: 1501899,
“effectiveDurationStandardOfDeviation”: 1970.0463080222792,
“errors”: 0,
“fullDuration”: 1503837,
“maxEffectiveDuration”: 11127,
“maxResponseTime”: 8371,
“minEffectiveDuration”: 2877,
“minResponseTime”: 832,
“percentiles”: [
{
“percentile”: 95,
“value”: 10080
}
],
“started”: 226,
“totalHtmlPageResponseTime”: 1501899,
“totalHtmlPageTTFB”: 1497693,
“totalHtmlResponseCount”: 452,
“totalResponseCount”: 452,
“totalResponseTime”: 1501899,
“tps”: 0.2851765959210953
},
“minute”: “7”,
“time”: “2023-10-27T05:59:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 4565,
“bytesReceived”: 2164627,
“bytesSent”: 198916,
“completed”: 217,
“effectiveDuration”: 2035935,
“effectiveDurationStandardOfDeviation”: 2237.274599213739,
“errors”: 0,
“fullDuration”: 2037254,
“maxEffectiveDuration”: 13507,
“maxResponseTime”: 9735,
“minEffectiveDuration”: 4358,
“minResponseTime”: 930,
“percentiles”: [
{
“percentile”: 95,
“value”: 12685
}
],
“started”: 223,
“totalHtmlPageResponseTime”: 2035935,
“totalHtmlPageTTFB”: 2032679,
“totalHtmlResponseCount”: 446,
“totalResponseCount”: 446,
“totalResponseTime”: 2035935,
“tps”: 0.27261375028580476
},
“minute”: “8”,
“time”: “2023-10-27T06:00:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 5758,
“bytesReceived”: 2007090,
“bytesSent”: 182860,
“completed”: 192,
“effectiveDuration”: 2360587,
“effectiveDurationStandardOfDeviation”: 3190.2229068079164,
“errors”: 0,
“fullDuration”: 2361768,
“maxEffectiveDuration”: 23723,
“maxResponseTime”: 18868,
“minEffectiveDuration”: 5250,
“minResponseTime”: 1319,
“percentiles”: [
{
“percentile”: 95,
“value”: 16160
}
],
“started”: 205,
“totalHtmlPageResponseTime”: 2360587,
“totalHtmlPageTTFB”: 2356667,
“totalHtmlResponseCount”: 410,
“totalResponseCount”: 410,
“totalResponseTime”: 2360587,
“tps”: 0.24120663619757837
},
“minute”: “9”,
“time”: “2023-10-27T06:01:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 9699,
“bytesReceived”: 1837280,
“bytesSent”: 158776,
“completed”: 167,
“effectiveDuration”: 3453000,
“effectiveDurationStandardOfDeviation”: 12102.87604922571,
“errors”: 0,
“fullDuration”: 3454114,
“maxEffectiveDuration”: 63221,
“maxResponseTime”: 58721,
“minEffectiveDuration”: 6835,
“minResponseTime”: 2318,
“percentiles”: [
{
“percentile”: 95,
“value”: 48400
}
],
“started”: 178,
“totalHtmlPageResponseTime”: 3453000,
“totalHtmlPageTTFB”: 3449641,
“totalHtmlResponseCount”: 356,
“totalResponseCount”: 356,
“totalResponseTime”: 3453000,
“tps”: 0.20979952210935204
},
“minute”: “10”,
“time”: “2023-10-27T06:02:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 14176,
“bytesReceived”: 1996596,
“bytesSent”: 161452,
“completed”: 182,
“effectiveDuration”: 5131799,
“effectiveDurationStandardOfDeviation”: 30812.69020884216,
“errors”: 0,
“fullDuration”: 5133099,
“maxEffectiveDuration”: 127418,
“maxResponseTime”: 119561,
“minEffectiveDuration”: 7290,
“minResponseTime”: 1243,
“percentiles”: [
{
“percentile”: 95,
“value”: 102499
}
],
“started”: 181,
“totalHtmlPageResponseTime”: 5131799,
“totalHtmlPageTTFB”: 5127610,
“totalHtmlResponseCount”: 362,
“totalResponseCount”: 362,
“totalResponseTime”: 5131799,
“tps”: 0.22864379056228784
},
“minute”: “11”,
“time”: “2023-10-27T06:03:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 7625,
“bytesReceived”: 1686432,
“bytesSent”: 132908,
“completed”: 153,
“effectiveDuration”: 2455368,
“effectiveDurationStandardOfDeviation”: 10302.414536004475,
“errors”: 8,
“fullDuration”: 5033202,
“maxEffectiveDuration”: 122431,
“maxResponseTime”: 117100,
“minEffectiveDuration”: 9319,
“minResponseTime”: 0,
“percentiles”: [
{
“percentile”: 95,
“value”: 19700
}
],
“started”: 173,
“totalHtmlPageResponseTime”: 2455368,
“totalHtmlPageTTFB”: 2451776,
“totalHtmlResponseCount”: 298,
“totalResponseCount”: 322,
“totalResponseTime”: 2455368,
“tps”: 0.19221153821994527
},
“minute”: “12”,
“time”: “2023-10-27T06:04:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 8153,
“bytesReceived”: 1635743,
“bytesSent”: 120420,
“completed”: 142,
“effectiveDuration”: 2454049,
“effectiveDurationStandardOfDeviation”: 7704.084008083924,
“errors”: 0,
“fullDuration”: 4130493,
“maxEffectiveDuration”: 23817,
“maxResponseTime”: 16655,
“minEffectiveDuration”: 10344,
“minResponseTime”: 0,
“percentiles”: [
{
“percentile”: 95,
“value”: 22628
}
],
“started”: 166,
“totalHtmlPageResponseTime”: 2454049,
“totalHtmlPageTTFB”: 2450160,
“totalHtmlResponseCount”: 270,
“totalResponseCount”: 301,
“totalResponseTime”: 2454049,
“tps”: 0.1783924080211257
},
“minute”: “13”,
“time”: “2023-10-27T06:05:21.119+00:00”
},
{
“metrics”: {
“averageResponseTime”: 3597,
“bytesReceived”: 250446,
“bytesSent”: 13748,
“completed”: 168,
“effectiveDuration”: 305751,
“effectiveDurationStandardOfDeviation”: 6789.665765682242,
“errors”: 0,
“fullDuration”: 646345,
“maxEffectiveDuration”: 20205,
“maxResponseTime”: 16533,
“minEffectiveDuration”: 6970,
“minResponseTime”: 0,
“percentiles”: [
{
“percentile”: 95,
“value”: 19999
}
],
“started”: 62,
“totalHtmlPageResponseTime”: 305751,
“totalHtmlPageTTFB”: 305295,
“totalHtmlResponseCount”: 30,
“totalResponseCount”: 85,
“totalResponseTime”: 305751,
“tps”: 0.2110558066728811
},
“minute”: “14”,
“time”: “2023-10-27T06:06:21.119+00:00”
}
]
}
]
}

you can try the extract fields transformation

@sowdenraymond could you be a bit more specific?

image