topic Re: Sum rows by column in Knowledge Management

How to search sum rows by column?

politrons — Wed, 02 Nov 2022 12:15:08 GMT

Having this initial query I obtain a list of results order by Consumer, and pod

messages_number container_name="pol-sms-amh-throttler" | stats avg(messages_number) as consumer_node by Consumer, pod

Then I append a second stats where I want to sum all the values of pods by Consumer

messages_number container_name="pol-sms-amh-throttler" | stats avg(messages_number) as consumer_node by Consumer, pod | stats sum(consumer_node) as AvgConsumption by Consumer limit=0

Is this query correct and accurate about what I'm want to achieve?

Also I don't know how can I see the AvgConsumptions in a visualization

Re: Sum rows by column

ITWhisperer — Wed, 02 Nov 2022 09:18:36 GMT

What you have will give you a number although I am not sure what significance it has - have you considered just doing it this way?

messages_number container_name="pol-sms-amh-throttler" | stats avg(messages_number) as AvgConsumption by Consumer limit=0

Re: Sum rows by column

politrons — Wed, 02 Nov 2022 09:49:26 GMT

you're not doing the same thing.

If we have 3 pods that are producing messages_number 3,4,2. What I want to know is that all of them are producing 9.

But with your query it will produce just 4

Re: Sum rows by column

ITWhisperer — Wed, 02 Nov 2022 09:52:23 GMT

If you just want to sum them, try this

messages_number container_name="pol-sms-amh-throttler" | stats sum(messages_number) as TotalConsumption by Consumer limit=0