@yosiasz
good call, just came back and read your message again and it clicked. aliased my series column as metric and timestamp as time
and, importantly, changed the query A format to time series (it was table) and got the results I was looking for
thanks!