# New to Glide! Trying to count the number of items in a stage

**URL:** <https://community.glideapps.com/t/new-to-glide-trying-to-count-the-number-of-items-in-a-stage/47534>\
**Category:** Ask for Help\
**Created:** [August 23, 2022, 7:26am UTC](https://community.glideapps.com/t/new-to-glide-trying-to-count-the-number-of-items-in-a-stage/47534 "2022-08-23T07:26:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rowena\_Pereda](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rowena_pereda/32/36846_2.png) [@Rowena\_Pereda](https://community.glideapps.com/u/Rowena_Pereda)\
**Post date:** [August 23, 2022, 7:26am UTC](https://community.glideapps.com/t/new-to-glide-trying-to-count-the-number-of-items-in-a-stage/47534/1 "2022-08-23T07:26:54Z")

</div>

Hey guys,

I’m new to glide and I’ve come across a bit of a hurdle.

I have a column that shows what stage each customer is on the process. Stages are :

- New
- Working
- Handover

I would like to create a big number text to show the number of leads that are under each of the above category. I’m checking tutorials but I couldn’t make it work.

Help would be greatly appreciated 🙂

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [August 23, 2022, 7:38am UTC](https://community.glideapps.com/t/new-to-glide-trying-to-count-the-number-of-items-in-a-stage/47534/2 "2022-08-23T07:38:44Z")

</div>

2 steps:

- In the column where you have the stages, create a match multiple relation onto itself. This creates sub-tables of your table based on the data in that column.
- Apply a rollup on that relation column you just built. You are counting the number of rows of each of your sub-tables.

---

<div class="post-metadata">

**Author:** ![Rowena\_Pereda](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rowena_pereda/32/36846_2.png) [@Rowena\_Pereda](https://community.glideapps.com/u/Rowena_Pereda)\
**Post date:** [August 23, 2022, 8:17am UTC](https://community.glideapps.com/t/new-to-glide-trying-to-count-the-number-of-items-in-a-stage/47534/3 "2022-08-23T08:17:00Z")

</div>

Thank you so much for your help. I was able to create relation and rollup. How do I show each in a big number card? Maybe there’s a tutorial I can watch so I dont bother you too much?

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [August 23, 2022, 9:49am UTC](https://community.glideapps.com/t/new-to-glide-trying-to-count-the-number-of-items-in-a-stage/47534/4 "2022-08-23T09:49:55Z")

</div>

Let me correct myself.

It depends on how you have your data structured, but here is one way I would do it.

1. Create 2 tables: clients, stages. “Clients” is where you are gathering your data on your clients (name, stage). “Stages” is a short list of the stage you will be displaying as a dashboard.

Clients table: Name, Stage

 ![Screenshot 2022-08-23 at 11.34.27](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/c/7c0f57e7ba46e391aac6999389326e1487d2f87c.jpeg)

Stages table: Name

 ![Screenshot 2022-08-23 at 11.38.27](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/f/af835a1f4cff5f0d43b13f7fa5944eddc73363a4.jpeg)

1. In your “Stages” table, relate the “Name” column to the “Stages” column in the “Clients” table, multiple match.

2. Do a rollup count on this relation column.

3. In the builder (I am assuming you are building in Pages), create a new page, source it to “Stages” table, and display the roll-up count using a collection, probably with a card layout.

 ![Screenshot 2022-08-23 at 11.42.24](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/e/5edaf677dc68db1ca8e7eaa47239c648d44e357e.jpeg)

Now, whenever a new client is added with one of the stages available, the count will increment. And whenever you add a stage to your “Stages” table, an element in your collection will be added. If you add a client with a stage that does not exist in your “Stages” table, then this stage (and therefore client within the counter) will be ignored. This is why when adding a client if you are using a form, I would use a choice component pointing to the “Stages” table.