# How to Create Kibana Visualization to show only highest 3 sum of values over a time period?

**URL:** https://discuss.elastic.co/t/how-to-create-kibana-visualization-to-show-only-highest-3-sum-of-values-over-a-time-period/310000
**Category:** Kibana
**Created:** [July 19, 2022, 9:59am UTC](https://discuss.elastic.co/t/how-to-create-kibana-visualization-to-show-only-highest-3-sum-of-values-over-a-time-period/310000 "2022-07-19T09:59:49Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![rachana\_uday](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rachana_uday/32/86611_2.png) [@rachana\_uday](https://discuss.elastic.co/u/rachana_uday)
#### Post date: [July 19, 2022, 9:59am UTC](https://discuss.elastic.co/t/how-to-create-kibana-visualization-to-show-only-highest-3-sum-of-values-over-a-time-period/310000/1 "2022-07-19T09:59:49Z")

</div>

Hey Guys,

I have a task to create a kibana Visualization [preferably a data table] that shows the maximum 3 values of the sum of values over a time period.

Basically I want the visualization to obtain below:

1. calculate the sum of bytes per day
2. find the highest 3 of all the sum values over the time period
3. kibana visualization to show the highest 3 sum values over the time.
4. Finally last row showing the average of the 3 highest sum values

Something like below:  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/4/448cff74c969e07f64f9270bc7918e723d163f25.png)

can anyone pls help me achieve this??

Thanks in advance.

---

<div class="post-metadata">

### Author: ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)
#### Post date: [July 19, 2022, 12:42pm UTC](https://discuss.elastic.co/t/how-to-create-kibana-visualization-to-show-only-highest-3-sum-of-values-over-a-time-period/310000/2 "2022-07-19T12:42:12Z")

</div>

Hi @rachana_uday ,

I think you can achieve what you want using the Lens editor:

- Create a table with a Metric set as "Sum" of the selected field
  - at the bottom of the panel, select "Average" from the "Summary row" input (available since 7.14)

- Create a "Column" using "Top Values" and pick the field you want the 3 values from
  - within the panel, in the "Rank by" select the Sum metric

---

<div class="post-metadata">

### Author: ![rachana\_uday](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rachana_uday/32/86611_2.png) [@rachana\_uday](https://discuss.elastic.co/u/rachana_uday)
#### Post date: [August 3, 2022, 7:00am UTC](https://discuss.elastic.co/t/how-to-create-kibana-visualization-to-show-only-highest-3-sum-of-values-over-a-time-period/310000/3 "2022-08-03T07:00:42Z")

</div>

@Marco_Liberati On the kibana [7.10.0] we are using, I do not see a lens editor.  
Below are the visualizations available

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/5/95c663dd30453ca63cfc97ba7e92d76032fb576f.png)

Can you please suggest from using these graphs?

---

<div class="post-metadata">

### Author: ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)
#### Post date: [August 3, 2022, 9:12am UTC](https://discuss.elastic.co/t/how-to-create-kibana-visualization-to-show-only-highest-3-sum-of-values-over-a-time-period/310000/4 "2022-08-03T09:12:09Z")

</div>

You can achieve a similar result using the legacy Data Table editor in the picture.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 31, 2022, 9:12am UTC](https://discuss.elastic.co/t/how-to-create-kibana-visualization-to-show-only-highest-3-sum-of-values-over-a-time-period/310000/5 "2022-08-31T09:12:25Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.