It is much easier with backend & jsonata query.
$map($.result.data, function($data){
$map($data.ddaT_DVAL, function($ddaT_DVAL,$ddaT_DVAL_index){
{
"date": $.result.timeStampDays[$ddaT_DVAL_index],
"pvid": $string($data.pvid),
"shortName": $data.shortName,
"ddaT_DVAL": $ddaT_DVAL
}
})
}).*^(date)
https://play.grafana.org/goto/nb98v4VNg?orgId=1
In order to make this proper timeseries, set the format to timeseries in query
