# How to filter on distinct count column in the values fields

**URL:** <https://community.amazonquick.com/t/how-to-filter-on-distinct-count-column-in-the-values-fields/2447>\
**Category:** Q&A\
**Tags:** filters, quick-sight\
**Created:** [March 18, 2022, 3:27pm UTC](https://community.amazonquick.com/t/how-to-filter-on-distinct-count-column-in-the-values-fields/2447 "2022-03-18T15:27:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jjc](https://avatars.discourse-cdn.com/v4/letter/j/a9adbd/32.png) [@jjc](https://community.amazonquick.com/u/jjc)\
**Post date:** [March 18, 2022, 3:27pm UTC](https://community.amazonquick.com/t/how-to-filter-on-distinct-count-column-in-the-values-fields/2447/1 "2022-03-18T15:27:35Z")

</div>

I have a table of count distinct. I want to filter this column of distinct count to anything more than 1. How should I do it?

---

<div class="post-metadata">

**Author:** ![darcoli](https://avatars.discourse-cdn.com/v4/letter/d/bb73d2/32.png) [@darcoli](https://community.amazonquick.com/u/darcoli)\
**Post date:** [March 20, 2022, 9:08pm UTC](https://community.amazonquick.com/t/how-to-filter-on-distinct-count-column-in-the-values-fields/2447/2 "2022-03-20T21:08:21Z")

</div>

If this column is not numeric, then need to create a new calculated field

```auto
distinct_count({column)

```

Then you should be able to add the filter on this field for values greater than 1

---

<div class="post-metadata">

**Author:** ![lillie](https://avatars.discourse-cdn.com/v4/letter/l/e19adc/32.png) [@lillie](https://community.amazonquick.com/u/lillie)\
**Post date:** [March 21, 2022, 5:02pm UTC](https://community.amazonquick.com/t/how-to-filter-on-distinct-count-column-in-the-values-fields/2447/3 "2022-03-21T17:02:31Z")

</div>

If it is numeric you can use the field well to change the way the field is aggregated. See here:

 ![Screen Shot 2022-03-21 at 10.01.40 AM](https://d1wl4jav5dp96l.cloudfront.net/original/2X/3/317c4a8a3ae331ddd048ae5fb30e64ae9302f6fa.png)