I have the following JSON from an infinity data source, would like to use a UQL parser (or any other available parser in Grafana) to obtain 4 time series. Any suggestions? Thank you in advance.
infinity’s json response:
{“result”:[
{“cat”:“A” ,“type”:“apple”, “time”:“2024-08-09T12:00:00Z”, “matricA”:63639, “matricB”:409},
{“cat”:“A”, “type”:“apple”, “time”:“2024-08-09T00:00:00Z”, “matricA”:58906, “matricB”:329},
{“cat”:“A”, “type”:“apple”, “time”:“2024-08-09T12:00:00Z”, “matricA”:40629, “matricB”:446},
{“cat”:“B”, “type”:“banana”, “time”:“2024-08-09T12:00:00Z”, “matricA”:32097, “matricB”:396},
{“cat”:“B”, “type”:“banana”, “time”:“2024-08-09T00:00:00Z”,“matricA”: 12394, “matricB”:278},
{“cat”:“B”, “type”:“banana”, “time”:“2024-08-09T12:00:00Z”, “matricA”:9209, “matricB”:420}
]
}
wanted 4 series:
series 1: cat A ,type apple, metric A
series 2: cat A ,type apple, metric B
series 3: cat B, type banana, metric A
series 4: cat B, type banana, metric B
Default parser and Convert field type transformation:
1 Like