Infinity plugin: Parse nested array of JSON and create time series out of this
{
"component_test":[
{
"swversion": "2.67.0",
"passed": [
{
"testcasename": "test_TestTargetFirst",
"testcaseexecutiontime": "4.006"
},
{
"testcasename": "test_TestTargetSecond",
"testcaseexecutiontime": "2.002"
},
{
"testcasename": "test_CapiDbus_diagAsClient",
"testcaseexecutiontime": "3.241"
}
]
},
{
"swversion": "2.68.0",
"passed": [
{
"testcasename": "test_TestTargetFirst",
"testcaseexecutiontime": "9.005"
},
{
"testcasename": "test_TestTargetSecond",
"testcaseexecutiontime": "8.001"
},
{
"testcasename": "test_CapiDbus_diagAsClient",
"testcaseexecutiontime": "7.273"
}
]
}
]
}
I tried with inifinity data source with UQL type
parse-json | mv-expand “passed_testcases”=“passed” | project “swversion”, “key”=“passed_testcases.testcasename”, “value”=“passed_testcases.testcaseexecutiontime”
Able to display contents but what I want is to display the time series chart like on x-axis “swversion” on y-axis “testcaseexecutiotime” on series testcase name. but here it displayed different. Even in suggestions not able view time series. And when I select timeseries getting “Data is missing in time field”. Can anyone help here.