cancel
Showing results for 
Search instead for 
Did you mean: 

Error with sum

nvadithya
New Contributor

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?

nvadithya_0-1659211969505.png

 

You are awesome!

Thank you!

2 REPLIES 2

Denakaran
New Contributor II

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. 

davidcrossey
Moderator Moderator
Moderator

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