# Kibana Bar Char Visualization for Unique URL call **URL:** \ **Category:** Kibana\ **Created:** [April 22, 2020, 4:37pm UTC](https://discuss.elastic.co/t/kibana-bar-char-visualization-for-unique-url-call/229316 "2020-04-22T16:37:38Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Cesar\_Rojas-Munoz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cesar_rojas-munoz/32/66894_2.png) [@Cesar\_Rojas-Munoz](https://discuss.elastic.co/u/Cesar_Rojas-Munoz)\ **Post date:** [April 22, 2020, 4:37pm UTC](https://discuss.elastic.co/t/kibana-bar-char-visualization-for-unique-url-call/229316/1 "2020-04-22T16:37:38Z")
Hi, I would like to create a horizontal bar visualization in Kibana with API endpoints (methods) use. Most of those endpoints are parameterized and I would like to count unique endpoints. For example, I have the next endpoints: GET [http://xyz.com/user/1/profile](http://xyz.com/user/1/profile) GET [http://xyz.com/user/2/profile](http://xyz.com/user/2/profile) GET [http://xyz.com/user/3/profile](http://xyz.com/user/3/profile) GET [http://xyz.com/profile/1](http://xyz.com/profile/1) GET [http://xyz.com/profile/2](http://xyz.com/profile/2) So, the results should be a horizontal bar ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/7/b7a7b88fcdeaba4000e436dcb3e5fee8f4258a40.png) The problem I am facing now is that I am getting one bar for each entry. Any ideas about how to create a single bar for the unique entries. Thanks ---
**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\ **Post date:** [April 22, 2020, 6:18pm UTC](https://discuss.elastic.co/t/kibana-bar-char-visualization-for-unique-url-call/229316/2 "2020-04-22T18:18:10Z")
When you say "one bar for each unique entry", are you referring to: a) One bar for each unique endpoint, with the aggregated count? b) One bar for each request, which is not aggregated? If you are referring to a), then you need to increase the size of the Terms aggregation you're using. If you are referring to b), then that is only supported using the Vega visualization type. ---
**Author:** ![Cesar\_Rojas-Munoz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cesar_rojas-munoz/32/66894_2.png) [@Cesar\_Rojas-Munoz](https://discuss.elastic.co/u/Cesar_Rojas-Munoz)\ **Post date:** [April 22, 2020, 7:26pm UTC](https://discuss.elastic.co/t/kibana-bar-char-visualization-for-unique-url-call/229316/3 "2020-04-22T19:26:10Z")
Thanks, Wylie for the answer. I think what I am looking if for the point (a) One bar for each unique endpoint, with the aggregated count. When you say "then you need to increase the size of the Terms aggregation you're using." it means that I need to include one term entry for each value? Keep in mind that I could have 1000s of values. Is there a general way to define filtering with value 'GET [http://xyz.com/user/{{value}](http://xyz.com/user/%7B%7Bvalue%7D)}/profile' and use it for the bar chart? ---
**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\ **Post date:** [April 22, 2020, 7:35pm UTC](https://discuss.elastic.co/t/kibana-bar-char-visualization-for-unique-url-call/229316/4 "2020-04-22T19:35:18Z")
You are past the limits of Elasticsearch and Kibana if you want to show thousands of unique strings in a visualization. The Terms aggregation which you are using is limited by the `search.max_buckets` Elasticsearch setting, and none of our visualizations support the `composite` aggregation which can be paginated over the limit. The only option that exists if you want to show thousands of unique values is: 1. Use the Transformation API to create pre-aggregated documents [https://www.elastic.co/guide/en/elasticsearch/reference/current/transforms.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/transforms.html) 2. Create a Kibana index pattern for the pre-aggregated documents 3. Create a Kibana saved search in Discover, which is only available as a data table (no bar chart) ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [May 20, 2020, 7:35pm UTC](https://discuss.elastic.co/t/kibana-bar-char-visualization-for-unique-url-call/229316/5 "2020-05-20T19:35:26Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.