# Top N Visual Builder Count Not Working
**URL:** https://discuss.elastic.co/t/top-n-visual-builder-count-not-working/122357
**Category:** Kibana
**Created:** [March 3, 2018, 7:33am UTC](https://discuss.elastic.co/t/top-n-visual-builder-count-not-working/122357 "2018-03-03T07:33:09Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@wwalker](https://discuss.elastic.co/u/wwalker)
#### Post date: [March 3, 2018, 7:33am UTC](https://discuss.elastic.co/t/top-n-visual-builder-count-not-working/122357/1 "2018-03-03T07:33:09Z")
I've had various issues with the Top N displaying properly for the Visual Builder. On versions previous to 6.2.2, it would count the total instances but not always sort them in descending order. Currently, this is what I have going on:
The term being grouped is geoip.country\_name.keyword. As you can see, it's showing zero across the board but if I build it via a table, as shown below, there are definitely values that can be counted. What am I doing wrong here?
---
### Author:  [@tsullivan](https://discuss.elastic.co/u/tsullivan)
#### Post date: [March 4, 2018, 12:33am UTC](https://discuss.elastic.co/t/top-n-visual-builder-count-not-working/122357/2 "2018-03-04T00:33:25Z")
The way that Time Series Visual Builder works is different than a Data Table Visualization, because in TSVB, everything starts with a histogram that uses a time interval from a timestamp field.
It's easier to understand if you start from the "Time Series" chart. I made a chart with server logs and put it into a chart.
My mouse cursor is all the way to the left, and the legend is showing top terms for that last time bucket.
Without changing any of the panel options, I change to "Top N"
The terms here are just a "blown up" view of the terms shown in the last time bucket of the Time Series chart.
If you're getting only zeroes for the Top N chart, take a look at what the data looks like in the Time Series view. The time range could be expanded in a way that makes the last time bucket have zero counts for terms that exist in earlier time buckets.
---
### Author:  [@wwalker](https://discuss.elastic.co/u/wwalker)
#### Post date: [March 4, 2018, 1:13am UTC](https://discuss.elastic.co/t/top-n-visual-builder-count-not-working/122357/3 "2018-03-04T01:13:40Z")
Doing as you said, here's what it looks like:
If I then switch to Top N, I get all zeros. If I refine the time frame to a small slice that has no zeros, then I get values in Top N. So I guess what I am trying to accomplish is a Top 10 of countries that appear in a given time. I like the vertical bar graph the TSVB provides, does one of the other visualizations more appropriately fit my needs/desires?
---
### Author:  [@tsullivan](https://discuss.elastic.co/u/tsullivan)
#### Post date: [March 4, 2018, 1:17am UTC](https://discuss.elastic.co/t/top-n-visual-builder-count-not-working/122357/4 "2018-03-04T01:17:09Z")
Yes, you can choose "Horizontal Bar Chart" when choosing your type of new visualization:
---
### Author:  [@wwalker](https://discuss.elastic.co/u/wwalker)
#### Post date: [March 4, 2018, 1:18am UTC](https://discuss.elastic.co/t/top-n-visual-builder-count-not-working/122357/5 "2018-03-04T01:18:04Z")
Ya, I asked the question before going and looking for myself, lol. I am currently playing with it, thanks for the help @tsullivan
---
### Author:  [@wwalker](https://discuss.elastic.co/u/wwalker)
#### Post date: [March 4, 2018, 1:40am UTC](https://discuss.elastic.co/t/top-n-visual-builder-count-not-working/122357/6 "2018-03-04T01:40:10Z")
OK, one more question. With the TSVB, I could link the each Top N entry. I don't see the ability to do that with the Horizontal Bar visualization. Is there a way or different visualization that will give me that functionality as well?
---
### Author:  [@tsullivan](https://discuss.elastic.co/u/tsullivan)
#### Post date: [March 4, 2018, 2:02am UTC](https://discuss.elastic.co/t/top-n-visual-builder-count-not-working/122357/7 "2018-03-04T02:02:51Z")
Sorry, that does not work for the "core" visualization types when the value to format is in the legend of a chart.
You can add a field formatter to an index pattern to have Kibana format the field how you want whenever it is displayed, but when it gets formatted in a legend, there is no clickable link:
The best I could get is something that looks like this:
---
### Author:  [@wwalker](https://discuss.elastic.co/u/wwalker)
#### Post date: [March 4, 2018, 2:15am UTC](https://discuss.elastic.co/t/top-n-visual-builder-count-not-working/122357/8 "2018-03-04T02:15:44Z")
Sounds good, thanks again @tsullivan.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 1, 2018, 2:15am UTC](https://discuss.elastic.co/t/top-n-visual-builder-count-not-working/122357/9 "2018-04-01T02:15:46Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.