@yesoreyeram - Awaiting your response please. Tried till here
parse-json
|jsonata “result[0].data[*].{‘host’: dimensionMap.‘dt.entity.host’,‘dimensions’:dimensions[0],‘timeseries’:$map(timestamps,function($ts,$i) { {‘timestamp’:$fromMillis($ts),‘CPUUsage’:values[$i]}})}”
|project “timeseries”, “dimensions”
|mv-expand “timeseries”
|project “timeseries” , “dimensions”
|project “timeseries.timestamp”,“dimensions”,“timeseries.CPUUsage”
Still I’m not able to plot as timeseries as I could not create multiple columns (for CPUUsage field). What am I missing here?