# Count unique

**URL:** <https://community.glideapps.com/t/count-unique/68928>\
**Category:** Ask for Help\
**Created:** [December 21, 2023, 4:26pm UTC](https://community.glideapps.com/t/count-unique/68928 "2023-12-21T16:26:16Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\
**Post date:** [December 21, 2023, 4:26pm UTC](https://community.glideapps.com/t/count-unique/68928/1 "2023-12-21T16:26:17Z")

</div>

Hello community! Hoping that you are feeling very well, I would like to know something: How can I get my Agency A column to count the times that each unique agency appears, that is:

ONFIRE appears 5 times, so I want you to count the number of times that agency appears

 ![Captura de pantalla 2023-12-21 132557](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/d/bd7ea2629f8c98f84600b492346b3b6e2c7ebd3c.png)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [December 21, 2023, 4:29pm UTC](https://community.glideapps.com/t/count-unique/68928/2 "2023-12-21T16:29:04Z")

</div>

Create a relation linking the agency to itself. Then do a Rollup counting the rows in the relation.

---

<div class="post-metadata">

**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\
**Post date:** [December 21, 2023, 4:37pm UTC](https://community.glideapps.com/t/count-unique/68928/3 "2023-12-21T16:37:36Z")

</div>

How would the relationship be made? I tried to do it, but I couldn’t do it, I share the screenshots of how I was doing it

 ![2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/4/c41e3a17285e16dded316a2872a1a2eca2c27024.png)  
 ![Captura de pantalla 2023-12-21 132557](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/5/350b7add4b03f5e3ce1922699f442680b2466506.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 21, 2023, 4:41pm UTC](https://community.glideapps.com/t/count-unique/68928/4 "2023-12-21T16:41:56Z")

</div>

Your first attempt is correct, but you need to check the “Match multiple” box.