# Canvas dropdown filter not showing all the values for the chosen column
**URL:** https://discuss.elastic.co/t/canvas-dropdown-filter-not-showing-all-the-values-for-the-chosen-column/283464
**Category:** Kibana
**Tags:** canvas
**Created:** [September 6, 2021, 3:46pm UTC](https://discuss.elastic.co/t/canvas-dropdown-filter-not-showing-all-the-values-for-the-chosen-column/283464 "2021-09-06T15:46:26Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@hNiven](https://discuss.elastic.co/u/hNiven)
#### Post date: [September 6, 2021, 3:46pm UTC](https://discuss.elastic.co/t/canvas-dropdown-filter-not-showing-all-the-values-for-the-chosen-column/283464/1 "2021-09-06T15:46:26Z")
Hi,
I am using the dropdown filter on my canvas board right now and I have managed to get it working however depending on the time range i set it will not pick up all the values for the column i have filtered for. We are also processing a lot of data so I have 2 queries:
1. I believe the filter not working is due canvas having a limitation with the number of records it can process in a query, is this correct?
2. If (1) is true is there a way to write the query to only select unique values for the given column being filtered for?
---
### Author:  [@monfera](https://discuss.elastic.co/u/monfera)
#### Post date: [September 10, 2021, 8:12am UTC](https://discuss.elastic.co/t/canvas-dropdown-filter-not-showing-all-the-values-for-the-chosen-column/283464/2 "2021-09-10T08:12:53Z")
Hello Hamish, have you got a minimal query example of what you have tried? It's not clear what query language you use, and within that, what you have tried. For example, SQL has GROUP BY which allows grouping by unique values of a column (whether you filter on it or not).
There's indeed a record limit count both in Canvas (that you can specify with a [higher value](https://discuss.elastic.co/t/canvas-increase-result-count/178116)) and at the Elasticsearch level (which requires changes to the `elasticsearc.yaml` configuration)
---
### Author:  [@hNiven](https://discuss.elastic.co/u/hNiven)
#### Post date: [September 13, 2021, 10:39am UTC](https://discuss.elastic.co/t/canvas-dropdown-filter-not-showing-all-the-values-for-the-chosen-column/283464/3 "2021-09-13T10:39:23Z")
Hi @monfera ,
I am using essql and had not tried Group BY yet. This was my original query:
```auto
filters
| essql query={string "SELECT function From \"index\" "}
| dropdownControl valueColumn="function" filterColumn="function.keyword"
| render
```
I tried using GROUP BY function and that seems to have done the trick:
```auto
filters
| essql query={string "SELECT function From \"index\"
group by function"}
| dropdownControl valueColumn="function" filterColumn="function.keyword"
| render
```
Thanks for the help
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 11, 2021, 10:40am UTC](https://discuss.elastic.co/t/canvas-dropdown-filter-not-showing-all-the-values-for-the-chosen-column/283464/4 "2021-10-11T10:40:00Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.