Hello @grindfiner,
you want to sum all the fields, then dont pivot.
Just group() and sum().
I’m not sure why you’re using a pivot. You usually only reserve that if you want to do math across fields or tags at the same timestamp.
If you want to sum a specific column other than _value you can specify it
|> sum(column: "name")
But that would just give you the sum for one field after your pivot.
I hope that helps!
