# "Cut to the chase" data visualization?

**URL:** https://discuss.elastic.co/t/cut-to-the-chase-data-visualization/138402
**Category:** Kibana
**Created:** [July 3, 2018, 1:34pm UTC](https://discuss.elastic.co/t/cut-to-the-chase-data-visualization/138402 "2018-07-03T13:34:20Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![brandondash](https://avatars.discourse-cdn.com/v4/letter/b/76d3ee/32.png) [@brandondash](https://discuss.elastic.co/u/brandondash)
#### Post date: [July 3, 2018, 1:34pm UTC](https://discuss.elastic.co/t/cut-to-the-chase-data-visualization/138402/1 "2018-07-03T13:34:20Z")

</div>

Hi there!

So, I have a script on a chrontab that pre-processes quite a bit of data to come up with a single metric for my product. I log the scripts results with a time stamp. Something like this:

2018.07.01 23456  
2018.07.02 23567  
2018.07.03 32756  
2018.07.04 33554

I feed these into Logstash and tag them so I can and search for them in Kibana. It all works great!

What I am stuck on is getting the latest value into a "One Big Number" visualization. I want it to look like Metric, but obviously Metric isn't built for this sort of thing. The closest I have been able to do is to make a data table backed by my saved search, then add two term aggregations for the two fields shown above, then limit the page display to a single field.

Here is what I have so far:  
 ![unnamed](https://us1.discourse-cdn.com/elastic/original/3X/0/8/087e7abdde96610289dd724e7ba6a15647568945.png)

Based on my reading it looks like I can change the query itself to only return a single result so that handles the multiple page issue, but beyond that I am stuck. This is what I want (hope) to be able to have it look like:

![target](https://us1.discourse-cdn.com/elastic/original/3X/b/7/b7abc65ff3f7c75ab527c033895c716da4d24c13.png)

Help!

---

<div class="post-metadata">

### Author: ![spalger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spalger/32/14092_2.png) [@spalger](https://discuss.elastic.co/u/spalger)
#### Post date: [July 3, 2018, 6:35pm UTC](https://discuss.elastic.co/t/cut-to-the-chase-data-visualization/138402/2 "2018-07-03T18:35:01Z")

</div>

While the name might be a little misleading, you should actually use the metric visualization for this. Try out a "Top Hits" metric, which will sort the matched documents and grab the top value just like you're doing in the table, but show it in one big number:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/0/f0fb60c4b24cf49993ac78f0003879f7910a4bb3.png)

---

<div class="post-metadata">

### Author: ![spalger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spalger/32/14092_2.png) [@spalger](https://discuss.elastic.co/u/spalger)
#### Post date: [July 3, 2018, 6:36pm UTC](https://discuss.elastic.co/t/cut-to-the-chase-data-visualization/138402/3 "2018-07-03T18:36:37Z")

</div>

You can also include additional metric aggregations if you want to show multiple stats like you do in the table:

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

---

<div class="post-metadata">

### Author: ![brandondash](https://avatars.discourse-cdn.com/v4/letter/b/76d3ee/32.png) [@brandondash](https://discuss.elastic.co/u/brandondash)
#### Post date: [July 3, 2018, 7:00pm UTC](https://discuss.elastic.co/t/cut-to-the-chase-data-visualization/138402/4 "2018-07-03T19:00:53Z")

</div>

This would be perfect! Can you explain how to unlock "Top Hits" for the Metric visualization? There is no mention of it [in the documentation](https://www.elastic.co/guide/en/kibana/current/metric-chart.html) and as you can see I don't have it as an option:

![no-top-hits](https://us1.discourse-cdn.com/elastic/original/3X/5/a/5adb8a4baaffa9eb2847745b4539e48c4da2af0f.png)

---

<div class="post-metadata">

### Author: ![spalger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spalger/32/14092_2.png) [@spalger](https://discuss.elastic.co/u/spalger)
#### Post date: [July 3, 2018, 8:21pm UTC](https://discuss.elastic.co/t/cut-to-the-chase-data-visualization/138402/5 "2018-07-03T20:21:37Z")

</div>

Hmm, looks like it was added by [https://github.com/elastic/kibana/pull/7302](https://github.com/elastic/kibana/pull/7302) in 5.3. What version of the stack are you using?

Not sure why it isn't listed in the docs... Created [https://github.com/elastic/kibana/issues/20427](https://github.com/elastic/kibana/issues/20427) to track that.

---

<div class="post-metadata">

### Author: ![brandondash](https://avatars.discourse-cdn.com/v4/letter/b/76d3ee/32.png) [@brandondash](https://discuss.elastic.co/u/brandondash)
#### Post date: [July 3, 2018, 8:23pm UTC](https://discuss.elastic.co/t/cut-to-the-chase-data-visualization/138402/6 "2018-07-03T20:23:17Z")

</div>

Looks like I just missed it. I'm using 5.2.1

Guess it's time for an upgrade.

---

<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: [July 31, 2018, 8:23pm UTC](https://discuss.elastic.co/t/cut-to-the-chase-data-visualization/138402/7 "2018-07-31T20:23:17Z")

</div>

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