# How do I have a column displaying total numbers? **URL:** \ **Category:** Ask for Help\ **Created:** [August 19, 2022, 9:13am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214 "2022-08-19T09:13:04Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![prizal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prizal/32/46421_2.png) [@prizal](https://community.glideapps.com/u/prizal)\ **Post date:** [August 19, 2022, 9:13am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/1 "2022-08-19T09:13:04Z")
I have a table of student attendance. I have a list of time and date tracking for each student. I am figuring out, from my list, how can I have the total number of attendance for each user. example as in the picture: how can I have a display mentioning how many days “Coba” has attended the sessions? Thank you in advance 🙂 ![capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/1/d10a59229d67aee2028eb461f7af5ecb9f340629.png) ---
**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:** [August 19, 2022, 9:33am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/2 "2022-08-19T09:33:38Z")
Your screen shot is a little confusing. It looks like you expect the answer to be 2, but I see 6 occurrences of Coba in that column. Can you explain the difference? (I’m guessing it has something to do with the previous column?) ---
**Author:** ![prizal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prizal/32/46421_2.png) [@prizal](https://community.glideapps.com/u/prizal)\ **Post date:** [August 19, 2022, 9:53am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/3 "2022-08-19T09:53:23Z")
yes, you got that right … it is just an example…I need a column showing the total of Coba…I’m sorry for my bad example given earlier ---
**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:** [August 19, 2022, 10:04am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/4 "2022-08-19T10:04:02Z")
Okay, so the easiest way is as follows: - Create a [multiple relation](https://www.glideapps.com/docs/reference/computed-columns/relations#multiple-relations) column that matches that Pelajar column to itself - Then create a [rollup](https://www.glideapps.com/docs/reference/computed-columns/rollup-column) column that takes a count through the relation column That will give you a count for each value in your Pelajar column. Ultimately, you might need more than that, it’s difficult to say. For example, if you have another table somewhere with a list of names, you might want to create the relation from there instead. ---
**Author:** ![prizal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prizal/32/46421_2.png) [@prizal](https://community.glideapps.com/u/prizal)\ **Post date:** [August 19, 2022, 10:33am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/5 "2022-08-19T10:33:16Z")
I’m trying to wrap my head around the idea but it doesn’t seem fit for now. Have been on it for hours. Thank you for pointing this out. ---
**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:** [August 19, 2022, 10:34am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/6 "2022-08-19T10:34:48Z")
Did you try what I suggested? ---
**Author:** ![prizal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prizal/32/46421_2.png) [@prizal](https://community.glideapps.com/u/prizal)\ **Post date:** [August 19, 2022, 10:41am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/7 "2022-08-19T10:41:40Z")
this is what I get from the relation column. I dont understand it, why with the question marks ![capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/7/175610cb086706688b77f2b8c43646a6142bb851.png) ---
**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:** [August 19, 2022, 10:44am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/8 "2022-08-19T10:44:46Z")
Don’t worry about the question marks, you can ignore them. What you need to do now is create a rollup column. It should “summarize the values of” that relation that you created, taking a count of the names. Actually, can you show me a screen shot of how your relation column is configured? ---
**Author:** ![prizal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prizal/32/46421_2.png) [@prizal](https://community.glideapps.com/u/prizal)\ **Post date:** [August 19, 2022, 10:49am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/9 "2022-08-19T10:49:14Z")
where do I create the rollup column ![capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/c/1c1f95c2a945c358bf1189740be4df8c6e1abb32.png) ? here is my relation config ---
**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:** [August 19, 2022, 10:50am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/10 "2022-08-19T10:50:10Z")
Okay, the relation looks fine. Create the rollup in the same table, right next to your relation column. ---
**Author:** ![prizal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prizal/32/46421_2.png) [@prizal](https://community.glideapps.com/u/prizal)\ **Post date:** [August 19, 2022, 10:55am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/11 "2022-08-19T10:55:05Z")
finally got it…thank you so much now I’m wondering if i will need to manually key in the names every time there’s a new pelajar to this table. ![capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/2/d2c7ac7d7fe8275a1f492004ee42a8121fb7067e.png) ---
**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:** [August 19, 2022, 11:00am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/12 "2022-08-19T11:00:10Z")
Pelajar translates to Student, yes? I think all you need is a separate table that has a list of all your Students, and then link that table to your Attendance table as I’ve shown you just now. And yes, whenever you have a new student, just add their name to the list. ---
**Author:** ![prizal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prizal/32/46421_2.png) [@prizal](https://community.glideapps.com/u/prizal)\ **Post date:** [August 19, 2022, 11:04am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/13 "2022-08-19T11:04:19Z")
Yes pelajar = student in malay language 🙂 Thank you once again… Have a nice day ---
**Author:** ![prizal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prizal/32/46421_2.png) [@prizal](https://community.glideapps.com/u/prizal)\ **Post date:** [August 19, 2022, 11:37am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/14 "2022-08-19T11:37:17Z")
![capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/a/6a865c2b512fe8eaf62684c295c97d2d2cf52ea4.png) I’m back …I only want to list on other tables with pelajar that has num 1 on it but not num 0. Is there a way? ---
**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:** [August 19, 2022, 11:39am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/15 "2022-08-19T11:39:20Z")
Just change your rollup column so that it summarises the values in that number column by taking a _sum_ (not a count). ---
**Author:** ![prizal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prizal/32/46421_2.png) [@prizal](https://community.glideapps.com/u/prizal)\ **Post date:** [August 19, 2022, 2:29pm UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/16 "2022-08-19T14:29:31Z")
![capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/5/f5e6c9e4cd1167ddfdcc4fad488fd82c216e6bea.png) I just noticed that actually my “pelajar” when it is recorded, it did not record at the same time as the time stamped. Which should be in the same row. Both rows are not supposed to be separate. Can’t find a way how to merge them together. In this sample its not the exact same info. ---
**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:** [August 19, 2022, 2:33pm UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/17 "2022-08-19T14:33:43Z")
I think I would need more information with this one. Can you describe how the data is added? ---
**Author:** ![prizal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prizal/32/46421_2.png) [@prizal](https://community.glideapps.com/u/prizal)\ **Post date:** [August 20, 2022, 12:15am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/18 "2022-08-20T00:15:16Z")
There’s a tab “senarai pelajar” which will display all the students \> clicking this will bring to students profile with two buttons \> pressing “mula mengaji” button will add a row to **timer** table in _pelajar_ column and will go to **timer** tab. In **timer** tab, there are 3 buttons **starttime** , **stoptime** , **reset**. which will act accordingly and add rows in **timer** table. The issue is: when in **senarai pelajar** tabs it adds the **pelajar** column to **timer** table (this is ok), but once in the \*_timer_ tab, when **starttime** button is pressed it will add a record to new row instead. The column with the earlier **pelajar** input will be the lower row without starttime recorded. How do I get both of them merged in the same row? Here are the snapshots. Sorry I cant post a lot of snaps since I’m new here. ![all](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/b/2bd929be6f2acfeaeba0ebe1327bbecec9d2f554.png) ---
**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:** [August 20, 2022, 7:30am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/19 "2022-08-20T07:30:45Z")
I can see from your screen shots that you appear to have two separate Add Row actions. This will definitely result in two rows being added. The solution might be as simple as changing your second action to “Set Column Values” instead of Add Row. That will work, as long as your screen is connected to the previously created row. Based on your screen shots and description, I can’t be sure if that’s the case - but I’d say give that a try to start with. ---
**Author:** ![prizal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prizal/32/46421_2.png) [@prizal](https://community.glideapps.com/u/prizal)\ **Post date:** [August 20, 2022, 10:47am UTC](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214/20 "2022-08-20T10:47:38Z")
![thisitem](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/1/b11f82296a052ae844acc46a0c5d04d4009f901f.png) I did set new column. The row has only **This item** for selection. It doesn’t work as wanted. Seems like it takes the action as new action and doesn’t pick from the last action [Next page](https://community.glideapps.com/t/how-do-i-have-a-column-displaying-total-numbers/47214.md?page=2)