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?

Ok, I will get to work on it for you :slight_smile: How many students do you have currently, and what is the max capacity of students?

Can you provide a student list, just their names?

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. |Studen…

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 Tru…

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.

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.

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 :slight_smile:

Ok, you now have charts in the monthly reporting section of the app, if you use the link it should update automatically.

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 ca…

Rollups for count

Ask for Help

Aj2666 May 3, 2020, 7:35pm 9

Thank you. Much appreciated.

Random sort

Topic		Replies	Views
Display the Count of items matched in a 'Relation' list Ask for Help	29	5034	January 17, 2024
🧮 Rollup - Count... with lots more options now (or I had just never used this) Ask for Help	2	281	November 12, 2021
Ask about rollup Ask for Help	7	151	February 16, 2024
Roll up a look up Report a Bug	4	462	July 24, 2020
🍥 Rollups! General	14	2328	March 4, 2020

Rollups for count

Related topics