I managed to get a working query: | spath input=Properties.Data path=Items{} output=Items | mvexpand Items | rename Items as _raw | spath path=Props{} output=ThePs | mvexpand ThePs | kv | spath input=ThePs path=PN output=PN | spath input=ThePs path=PV output=PV | table _time, CN, CV, PN, PV | timechart span=5m sum(PV) by CV where sum in top10
... View more