# Como realizo uma contagem de dados específicos?

**URL:** <https://community.glideapps.com/t/como-realizo-uma-contagem-de-dados-especificos/72086>\
**Category:** Ask for Help\
**Created:** [March 27, 2024, 1:00pm UTC](https://community.glideapps.com/t/como-realizo-uma-contagem-de-dados-especificos/72086 "2024-03-27T13:00:57Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![julana](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/julana/32/60756_2.png) [@julana](https://community.glideapps.com/u/julana)\
**Post date:** [March 27, 2024, 1:00pm UTC](https://community.glideapps.com/t/como-realizo-uma-contagem-de-dados-especificos/72086/1 "2024-03-27T13:00:57Z")

</div>

Bom dia. Tenho uma tabela, que antigamente era um kanban (por limitações do glide, tive alterar inclusive) e possui 4 tipos de status:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/d/ed79b4da25d823c7148a3b7200d1120ffbb5aa1c.png)

Preciso realizar um cálculo da quantidade de itens em cada status, e não encontrei uma forma através do rollup (já que não permitem filtrar, apenas informar a coluna)

Alguma sugestão?

---

<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:** [March 27, 2024, 1:09pm UTC](https://community.glideapps.com/t/como-realizo-uma-contagem-de-dados-especificos/72086/2 "2024-03-27T13:09:22Z")

</div>

You can create a relation that links the status column to itself. Then do a Rollup through the relation.

---

<div class="post-metadata">

**Author:** ![julana](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/julana/32/60756_2.png) [@julana](https://community.glideapps.com/u/julana)\
**Post date:** [March 27, 2024, 1:11pm UTC](https://community.glideapps.com/t/como-realizo-uma-contagem-de-dados-especificos/72086/3 "2024-03-27T13:11:00Z")

</div>

Certo, e como vai ser feito a contagem de itens no determinado status?  
Ex.: Não iniciado possui 10 itens  
Em andamento possui 15 itens

---

<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:** [March 27, 2024, 1:25pm UTC](https://community.glideapps.com/t/como-realizo-uma-contagem-de-dados-especificos/72086/4 "2024-03-27T13:25:07Z")

</div>

If the relation has 10 matching items then the Rollup count will be 10. If the relation has 15 matching items, then the Rollup count will be 15.

---

<div class="post-metadata">

**Author:** ![julana](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/julana/32/60756_2.png) [@julana](https://community.glideapps.com/u/julana)\
**Post date:** [March 27, 2024, 2:10pm UTC](https://community.glideapps.com/t/como-realizo-uma-contagem-de-dados-especificos/72086/5 "2024-03-27T14:10:57Z")

</div>

Ainda não entendi, Jeff

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/0/f052a567f6a6db603fd1041cbb48850b26b467b3.png)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 27, 2024, 3:10pm UTC](https://community.glideapps.com/t/como-realizo-uma-contagem-de-dados-especificos/72086/6 "2024-03-27T15:10:50Z")

</div>

Have you created the relation like Jeff suggested? Once you have that relation, you should be able to rollup on top of that relation.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/e/5e2cc50ed096c33f8ebe509d762fe468eb8ffccb.png)

Also, please be aware of these limitations when working with Glide Big Tables and enable the feature in Preview Mode as needed.

---

<div class="post-metadata">

**Author:** ![julana](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/julana/32/60756_2.png) [@julana](https://community.glideapps.com/u/julana)\
**Post date:** [March 27, 2024, 5:46pm UTC](https://community.glideapps.com/t/como-realizo-uma-contagem-de-dados-especificos/72086/7 "2024-03-27T17:46:04Z")

</div>

Sim, como mostrei no print. A tabela apresentada não é uma big table.  
Encontrei outra forma de fazer, obrigada.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 28, 2024, 1:09am UTC](https://community.glideapps.com/t/como-realizo-uma-contagem-de-dados-especificos/72086/8 "2024-03-28T01:09:39Z")

</div>

I see in your screenshot that the lookup column has “Query”, Is the table you’re looking up against a Big Table?

Can you show us again what you have now in another screenshot, and what’s the ideal outcome in the data view?
