# Rollups for count **URL:** https://community.glideapps.com/t/rollups-for-count/8146 **Category:** Ask for Help **Created:** [April 30, 2020, 1:46am UTC](https://community.glideapps.com/t/rollups-for-count/8146 "2020-04-30T01:46:48Z") **Posts on this page:** 20 **Page:** 1
### Author: ![Aj2666](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aj2666/32/1822_2.png) [@Aj2666](https://community.glideapps.com/u/Aj2666) #### Post date: [April 30, 2020, 1:46am UTC](https://community.glideapps.com/t/rollups-for-count/8146/1 "2020-04-30T01:46:48Z")
Hi Gliders, I have a case where I need to count student Attendance (a simple True/false if attended) to show in a report the number of times the Student Did and Did not attend. I opted to use Rollups over query, but I did not seem to get right. Any suggestions on how to best go about it? ---
### Author: ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate) #### Post date: [April 30, 2020, 3:05am UTC](https://community.glideapps.com/t/rollups-for-count/8146/2 "2020-04-30T03:05:19Z")
I would be happy to set this up for you. Do you want the report to exist in the app or in google sheets? And what is the frequency of the reporting? ---
### Author: ![Aj2666](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aj2666/32/1822_2.png) [@Aj2666](https://community.glideapps.com/u/Aj2666) #### Post date: [April 30, 2020, 6:28am UTC](https://community.glideapps.com/t/rollups-for-count/8146/3 "2020-04-30T06:28:55Z")
Thank you @Drearystate . In Google sheets on a monthly basis. ---
### Author: ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate) #### Post date: [April 30, 2020, 4:22pm UTC](https://community.glideapps.com/t/rollups-for-count/8146/4 "2020-04-30T16:22:42Z")
Ok, I will get to work on it for you šŸ™‚ How many students do you have currently, and what is the max capacity of students? ---
### Author: ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate) #### Post date: [April 30, 2020, 5:19pm UTC](https://community.glideapps.com/t/rollups-for-count/8146/5 "2020-04-30T17:19:31Z")
Can you provide a student list, just their names? ---
### Author: ![Aj2666](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aj2666/32/1822_2.png) [@Aj2666](https://community.glideapps.com/u/Aj2666) #### Post date: [May 1, 2020, 10:59pm UTC](https://community.glideapps.com/t/rollups-for-count/8146/6 "2020-05-01T22:59:07Z")
Thanks for the help @Drearystate . The list is variant (dynamic) and not static as it changes per training course, period varies from 4 week to six weeks to 8 weeks. If you would kindly explain the logic would be nice. All-in-all, Please find below the structure in mind > Blockquote > |No. |Student Name|Attended| > |ā€”|ā€”|ā€”| > |1|Studen 1|Yes| > |2|Studen 2|No| > |3|Studen 3|Yes| > |4|Studen 4|Yes| > |5|Studen 5|Yes| > |6|Studen 6|Yes| > |7|Studen 7|Yes| > |8|Studen 8|No| > |9|Studen 9|No| > |10|Studen 10|No| ---
### Author: ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires) #### Post date: [May 2, 2020, 4:54am UTC](https://community.glideapps.com/t/rollups-for-count/8146/7 "2020-05-02T04:54:35Z")
Hey @Aj2666 Try this one: ā€¢ If youā€™ll count in the same tab, First of all, create a relation of **Studentā€™s Name to Studentā€™s Name** (Matching multiple); ā€¢ Next, you create a Rollup column selecting this last relation you did and choosing the **Attendance** column, afterwards you select to **Count only True** ; So that, the Rollup will count the Attendance by Studentā€™s Name šŸ˜ ---
### Author: ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate) #### Post date: [May 3, 2020, 7:28pm UTC](https://community.glideapps.com/t/rollups-for-count/8146/8 "2020-05-03T19:28:36Z")
Ok, I will have it finished up today, I am using the toggles so you can just toggle real quick down the list. The reporting will consist of yesterday, last week, and current month. If you need any adjustments after I get it to you let me know. ---
### Author: ![Aj2666](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aj2666/32/1822_2.png) [@Aj2666](https://community.glideapps.com/u/Aj2666) #### Post date: [May 3, 2020, 7:35pm UTC](https://community.glideapps.com/t/rollups-for-count/8146/9 "2020-05-03T19:35:16Z")
Thank you. Much appreciated. ---
### Author: ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate) #### Post date: [May 3, 2020, 7:40pm UTC](https://community.glideapps.com/t/rollups-for-count/8146/10 "2020-05-03T19:40:46Z")
I got our 1st draft ready for you. Since you didnā€™t give me names or a max total on students I went with 12 students and just put in stdent 1, student 2, etc. The reports are setup to come from the sheet tab titled reports. But they will be in the app as well here in a minute. ---
### Author: ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate) #### Post date: [May 3, 2020, 7:43pm UTC](https://community.glideapps.com/t/rollups-for-count/8146/11 "2020-05-03T19:43:59Z")
[https://l.glideapps.com/75a86](https://l.glideapps.com/75a86) I will be off and on today so if you need anything fixed let me know. If you need the reporting explained and the cell formulas explained, again just let me know šŸ™‚ ---
### Author: ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate) #### Post date: [May 3, 2020, 8:02pm UTC](https://community.glideapps.com/t/rollups-for-count/8146/12 "2020-05-03T20:02:55Z")
Ok, you now have charts in the monthly reporting section of the app, if you use the link it should update automatically. ---
### Author: ![lancscheese](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lancscheese/32/7259_2.png) [@lancscheese](https://community.glideapps.com/u/lancscheese) #### Post date: [May 17, 2020, 5:40am UTC](https://community.glideapps.com/t/rollups-for-count/8146/13 "2020-05-17T05:40:56Z")
Hi guys! super helpful reading through your advice here Iā€™ve got an issue where the the DONE button isnā€™t clickable when i try to count TRUE values. I have a similar case of wanting to show a graph of attended classes per student. Iā€™ve created a relationship in the ā€˜studentā€™ sheet to the ā€˜class calendarā€™ sheet. Each student has multiple items referenced in the ā€˜studentā€™ sheet now. Next, I want to count these itemsā€¦but I canā€™t work out how [https://share.getcloudapp.com/geuWKQQE](https://share.getcloudapp.com/geuWKQQE). Notice the done button is not clickable thanks in advance Hereā€™s a picture ---
### Author: ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate) #### Post date: [May 17, 2020, 9:29pm UTC](https://community.glideapps.com/t/rollups-for-count/8146/14 "2020-05-17T21:29:38Z")
Can you send a screenshot of the google sheet? Does it already have true values in thta column? ---
### 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: [May 18, 2020, 1:50am UTC](https://community.glideapps.com/t/rollups-for-count/8146/15 "2020-05-18T01:50:50Z")
Is your relation a single or multiple relation? ---
### Author: ![lancscheese](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lancscheese/32/7259_2.png) [@lancscheese](https://community.glideapps.com/u/lancscheese) #### Post date: [May 18, 2020, 8:50am UTC](https://community.glideapps.com/t/rollups-for-count/8146/16 "2020-05-18T08:50:47Z")
Itā€™s a multiple relation ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/ac0882555cbf7b3dd7c176771061746bb52387de.png) Here it shows 6 classes associated to the top record ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b7df81ef564b7aa01e0797a63f6acc82d88991a4.png) and the goal is to rollup the count of reserved classes for the selected student. This is the boolean ā€˜reservedā€™ column ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/2bf13b45c44f6c35ac2c17a6045852f53d690053.png) Thanks for helping out, really appreciate it ---
### 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: [May 19, 2020, 4:25am UTC](https://community.glideapps.com/t/rollups-for-count/8146/17 "2020-05-19T04:25:36Z")
Thatā€™s strange. I donā€™t know why you wouldnā€™t be able to add the rollup. Can you try to make a duplicate of your app and try it in the duplicate? Also would you make able to allow your app to be copied so we could take a look? Nothing is jumping out to me based on your screenshots. ---
### Author: ![lancscheese](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lancscheese/32/7259_2.png) [@lancscheese](https://community.glideapps.com/u/lancscheese) #### Post date: [May 19, 2020, 3:50pm UTC](https://community.glideapps.com/t/rollups-for-count/8146/18 "2020-05-19T15:50:52Z")
Iā€™ve tried duplicating. No luck. Iā€™ve allowed the app to be copied temporarily [https://8eng5.glideapp.io/](https://8eng5.glideapp.io/) ---
### 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: [May 19, 2020, 4:35pm UTC](https://community.glideapps.com/t/rollups-for-count/8146/19 "2020-05-19T16:35:16Z")
I have a copy if you want to stop sharing. ---
### 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: [May 19, 2020, 4:57pm UTC](https://community.glideapps.com/t/rollups-for-count/8146/20 "2020-05-19T16:57:16Z")
I think you definitely identified a bug. Possibly with the new ability to rename columns in combination with using a rollup against a renamed relation. Did you happen to rename the relation column after you created it? I was able to reproduce the problem. First I created an identical relation and then created a rollup column against that relation. Everything worked fine and I was able to get a count of the true reserved checkboxes. It wasnā€™t until I renamed the relation column that I could no longer create a rollup against that relation with the ā€˜Doneā€™ button being grayed out. Deleting and recreating the relation with the name already set would fix this issue. @Mark I think we definitely have a bug here. I have a copy of the app in this state if you need it. [Next page](https://community.glideapps.com/t/rollups-for-count/8146.md?page=2)