topic How sum row cell based on type? in Dashboards & Visualizations

How sum row cell based on type?

aahmad — Thu, 12 May 2022 15:58:35 GMT

Hey,

I am trying to sum values based on type. I have a column of numbers and multivalues. I want to sum all the multivalues together and display the sum of all multivalues. How can I achieve this? Please refer to the diagram below:

As you can see there are two column. One column displays the numbers and the other column displays the type of each cell. I want to get the sum of cell that have a multivalue type.

Re: How sum row cell based on type?

ITWhisperer — Thu, 12 May 2022 16:14:13 GMT

Not clear whether you wanted the grand total for all numbers and the grand total for all multivalues or just the total for each event

| streamstats count as row | stats sum(number) as total values(type) as type values(number) as number by row | eventstats sum(number) as grandtotal by type

Re: How sum row cell based on type?

aahmad — Thu, 12 May 2022 17:12:16 GMT

Sorry for not clarifying. I want the total of each event. Forexample cell A has values, {2,5,6,7}. I want the total of the values in that cell. So the answer would be 20. Does that make sense?

Re: How sum row cell based on type?

ITWhisperer — Thu, 12 May 2022 17:29:44 GMT

| streamstats count as row | stats sum(number) as total values(type) as type values(number) as number by row