# Visualization with Top Hit Aggregation

**URL:** https://discuss.elastic.co/t/visualization-with-top-hit-aggregation/201123
**Category:** Kibana
**Created:** [September 26, 2019, 12:59am UTC](https://discuss.elastic.co/t/visualization-with-top-hit-aggregation/201123 "2019-09-26T00:59:09Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![jjums](https://avatars.discourse-cdn.com/v4/letter/j/c37758/32.png) [@jjums](https://discuss.elastic.co/u/jjums)
#### Post date: [September 26, 2019, 12:59am UTC](https://discuss.elastic.co/t/visualization-with-top-hit-aggregation/201123/1 "2019-09-26T00:59:09Z")

</div>

Hello,  
I'm a beginner with Kibana. Now, I tried to make dashboard with hourly data.  
My problem is visualization.

For example, every hour, 100 data comes in.  
I want to sum up only the top five values. The problem is that the (current) time can be easily obtained as a top hit, while setting the Time Picker to Today will show the sum of the top five values of the entire day.

I want to show the cumulative sum of the top five values out of the 100 that come in every hour up to the current time.

From the first image, I can have the value in total.

 ![question1](https://us1.discourse-cdn.com/elastic/original/3X/9/7/97a7f483e985295daa2e4f4af1fe3d12e7eb3049.jpeg)

I want to show the value in metric visualization because I want to add my dashboard.  
Even if not in metric visualization will be fine, I just want to show total value in my dashboard.

 ![question2](https://us1.discourse-cdn.com/elastic/original/3X/1/6/169de27aac7e0915679a28963a007e934510a9f2.jpeg)

How can I solve this problem?  
I'm not a native English speaker, so if you can't understand please let me know.  
I will do my best to explain again.

Thank you so much!

---

<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: [October 24, 2019, 12:59am UTC](https://discuss.elastic.co/t/visualization-with-top-hit-aggregation/201123/2 "2019-10-24T00:59:09Z")

</div>

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