-
Error with sum
I’m trying aggregate the consumption values which are of type long int, by the meter id which I’ve stored as int too. But I’m getting an empty table when I run the command in the screenshot. Any idea on how I can fix this?
You are awesome!
Thank you!
-
2 Replies
-
Hi, i think it is because of the value column which is a keyword in q.. I just renamed v in uppercase(V) and it is working. After aggregation i think you can rename it again with value using xcol.
-
Hi navdithya,
Your query is selecting the value (.:) function by mid. You need to apply sum on a column by mid to get an aggregation e.g.
show t:select sum column by mid from readings
Kind regards,
David
Log in to reply.