Y is the value of the number in the array
The concrete use-case (if it helps) is the display the battery percentage of multiple devices, over time, on a single chart
So 1 line, on the chart, per device
so just trying to simplify the data as much as possible, it looks like this? And youd want 2 lines, 1 per ID. with time as the X and value as the Y ?
1752756296000,1,3
1752757296000,1,8
1752758296000,1,3
1752756296000,2,2
1752757296000,2,7
1752758296000,2,1```Yup (ideally allowing for n lines)
I think instead of group by, youd want partition by value
(Also today I learned my brain is a terrible random number generator 
)
That’s looking much better! You legend, thank you!
I’m getting lines on the chart but for some reason they don’t appear to be coloured (likely not grouped) by the ID field. I’ll try doing some playing around to see what’s different as it looks like the data format, in the test you provided, is the same as my query. Therefore I’m likely doing something silly.
(Also today I learned my brain is a terrible random number generator
Far more random than I can produce; I usually end up with all 12s
Fixed it!
I stupidly had a frame selected. Removing that selection shows all data in the expected format!
Thank you! 
My descendants will tell stories of the great Kristina Durivage!
Hahaha wow! Thank you!
