# Sum of Averages of individual in lens visualization
**URL:** https://discuss.elastic.co/t/sum-of-averages-of-individual-in-lens-visualization/287574
**Category:** Kibana
**Created:** [October 25, 2021, 12:14pm UTC](https://discuss.elastic.co/t/sum-of-averages-of-individual-in-lens-visualization/287574 "2021-10-25T12:14:22Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@Prasanth\_V](https://discuss.elastic.co/u/Prasanth_V)
#### Post date: [October 25, 2021, 12:14pm UTC](https://discuss.elastic.co/t/sum-of-averages-of-individual-in-lens-visualization/287574/1 "2021-10-25T12:14:22Z")
Dear Team,
Is it possible to calculate sum of averages of each individual(nodes) apache workers in single lens visualization?
Kindly suggest us
---
### Author:  [@lukas](https://discuss.elastic.co/u/lukas)
#### Post date: [October 27, 2021, 4:31pm UTC](https://discuss.elastic.co/t/sum-of-averages-of-individual-in-lens-visualization/287574/2 "2021-10-27T16:31:26Z")
Do you mind pasting an example of some of the documents you have, as well as a rough example of what you're trying to accomplish? Thank you!
---
### Author:  [@Prasanth\_V](https://discuss.elastic.co/u/Prasanth_V)
#### Post date: [November 2, 2021, 5:54am UTC](https://discuss.elastic.co/t/sum-of-averages-of-individual-in-lens-visualization/287574/3 "2021-11-02T05:54:05Z")
Hi lukas,
I've created 4 individual dashboards for calculating averages of apache workers and idle.
Then, I've created a new visualization for sum of all averages of each nodes, but it seems to mismatch the values(sum of all averages = add of averages of all nodes) .
kindly, suggest.
---
### Author:  [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)
#### Post date: [November 2, 2021, 9:17am UTC](https://discuss.elastic.co/t/sum-of-averages-of-individual-in-lens-visualization/287574/4 "2021-11-02T09:17:38Z")
Hi @Prasanth_V
is it possible to see the Lens formulas used in those 4 charts?
---
### Author:  [@Prasanth\_V](https://discuss.elastic.co/u/Prasanth_V)
#### Post date: [November 2, 2021, 9:46am UTC](https://discuss.elastic.co/t/sum-of-averages-of-individual-in-lens-visualization/287574/5 "2021-11-02T09:46:15Z")
Hi @Marco_Liberati
I've used aggregation method for 4 charts, PFB snaps
---
### Author:  [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)
#### Post date: [November 2, 2021, 10:38am UTC](https://discuss.elastic.co/t/sum-of-averages-of-individual-in-lens-visualization/287574/6 "2021-11-02T10:38:47Z")
You want also to create a single Lens visualization containing all 4 nodes metrics together and I saw you've made a first attempt to it:
> Then, I've created a new visualization for sum of all averages of each nodes, but it seems to mismatch the values(sum of all averages = add of averages of all nodes) .
Can you share what you've tried in this attempt?
I think the missing part here, for me, is to understand how is data organized: is each node have a distinct index pattern, or there's a field indicating the node id?
---
### Author:  [@Prasanth\_V](https://discuss.elastic.co/u/Prasanth_V)
#### Post date: [November 3, 2021, 1:48am UTC](https://discuss.elastic.co/t/sum-of-averages-of-individual-in-lens-visualization/287574/7 "2021-11-03T01:48:17Z")
For each visualization I've added a filter like Host Name
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [November 3, 2021, 2:30am UTC](https://discuss.elastic.co/t/sum-of-averages-of-individual-in-lens-visualization/287574/8 "2021-11-03T02:30:42Z")
Hi @Prasanth_V
You need to do a Series Agg of type Sum and Lens doesn't support that yet... Coming soon.
We just discussed this here with an example of how to do in TSVB
> [@How to get the total of memory and cpu usage of my cluster](https://discuss.elastic.co/t/how-to-get-the-total-of-memory-and-cpu-usage-of-my-cluster/288170):
>
> Hi team, I am working on Kibana Dashboard trying to get a particular metric. for example, I have 3 kubernetes nodes and I am trying to create a dashboard with the Total of memory and CPU consumption, I am trying with lens, TVSB, and the classic Aggregation Based, I am not able to get the proper value of the Total Consumption, for example I have the 3 nodes there, with the memory capacity, But I can't find the way to sum the 3 nodes to get the total capacity, is it possible to do? Reg…
---
### Author:  [@Prasanth\_V](https://discuss.elastic.co/u/Prasanth_V)
#### Post date: [November 3, 2021, 5:39am UTC](https://discuss.elastic.co/t/sum-of-averages-of-individual-in-lens-visualization/287574/9 "2021-11-03T05:39:47Z")
Thanks @stephenb, its working fine with series agg
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 1, 2021, 5:40am UTC](https://discuss.elastic.co/t/sum-of-averages-of-individual-in-lens-visualization/287574/10 "2021-12-01T05:40:40Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.