# How can I increase number of values of visualize

**URL:** <https://discuss.elastic.co/t/how-can-i-increase-number-of-values-of-visualize/319289>\
**Category:** Kibana\
**Created:** [November 18, 2022, 11:00am UTC](https://discuss.elastic.co/t/how-can-i-increase-number-of-values-of-visualize/319289 "2022-11-18T11:00:23Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![yts85205107](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yts85205107/32/109328_2.png) [@yts85205107](https://discuss.elastic.co/u/yts85205107)\
**Post date:** [November 18, 2022, 11:00am UTC](https://discuss.elastic.co/t/how-can-i-increase-number-of-values-of-visualize/319289/1 "2022-11-18T11:00:23Z")

</div>

Hi,  
I want to increase number of values of visualize, but I can't found the setting to increase.  
now, the number of values is 1000, I want to increase to 3000, how can I increase?

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/d/8d69cf1ed6997522c8ecaf6fc34f9079efc69ef8.png)

Thanks.

---

<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:** [November 18, 2022, 11:22am UTC](https://discuss.elastic.co/t/how-can-i-increase-number-of-values-of-visualize/319289/2 "2022-11-18T11:22:38Z")

</div>

Hi @yts85205107

that is not possible at the moment, as the limit is set to 1000.  
May I ask why would you need so many distinct values?  
Just to clarify that control indicates the number of distinct `username.keyword` values stored, so 1000 _distinct_ usernames, not simply the first 1000 documents.

To visualize 3000 distinct values, even if the chart assigns 1 px for each it would still require more than 3000 pixels ( 1px each + some margin), which is way more than a regular screen resolution, and impossible to read.  
Are you looking for something in particular with such large number of values?

---

<div class="post-metadata">

**Author:** ![yts85205107](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yts85205107/32/109328_2.png) [@yts85205107](https://discuss.elastic.co/u/yts85205107)\
**Post date:** [November 19, 2022, 10:54pm UTC](https://discuss.elastic.co/t/how-can-i-increase-number-of-values-of-visualize/319289/3 "2022-11-19T22:54:02Z")

</div>

Hi,  
because we need to search more username and download csv to check user behavior.  
for example we have a new function and we want to know how many users use last 2 weeks.

---

<div class="post-metadata">

**Author:** ![leandrojmp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leandrojmp/32/107231_2.png) [@leandrojmp](https://discuss.elastic.co/u/leandrojmp)\
**Post date:** [November 20, 2022, 12:02am UTC](https://discuss.elastic.co/t/how-can-i-increase-number-of-values-of-visualize/319289/4 "2022-11-20T00:02:19Z")

</div>

> [@yts85205107](#):
>
> for example we have a new function and we want to know how many users use last 2 weeks.

You can get this by building a table visualization showing the number of unique `username.keyword` and filtering by the field that has you function name.

Also, if you want to create a visualization to export to CSV you may skip the visualization part and use one of the Elasticsearch clients in your preferred language to query elasticsearch and gives you the result.

In Kibana the number of values is limited to 1000.

---

<div class="post-metadata">

**Author:** ![yts85205107](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yts85205107/32/109328_2.png) [@yts85205107](https://discuss.elastic.co/u/yts85205107)\
**Post date:** [November 20, 2022, 6:49am UTC](https://discuss.elastic.co/t/how-can-i-increase-number-of-values-of-visualize/319289/5 "2022-11-20T06:49:08Z")

</div>

ok, thank you.

I will use query elasticsearch to collect information.

---

<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:** [December 18, 2022, 6:49am UTC](https://discuss.elastic.co/t/how-can-i-increase-number-of-values-of-visualize/319289/6 "2022-12-18T06:49:33Z")

</div>

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