# Need Dashboard Help **URL:** \ **Category:** Ask for Help\ **Created:** [September 26, 2023, 11:46pm UTC](https://community.glideapps.com/t/need-dashboard-help/66552 "2023-09-26T23:46:06Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Jireh\_Lee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jireh_lee/32/52727_2.png) [@Jireh\_Lee](https://community.glideapps.com/u/Jireh_Lee)\ **Post date:** [September 26, 2023, 11:46pm UTC](https://community.glideapps.com/t/need-dashboard-help/66552/1 "2023-09-26T23:46:06Z")
I am looking to use Glide to display an attendance history for my students for this year. I currently have a table with each clock in details for each student as they tap in. E.g: Student ID / Timestamp / Class ID S232344 / 9/28/2023 / SCIENCE\_2 S232344 / 9/28/2023 / MATH\_1 . . I want to display a list showing a history of dates of class and the total attendance that day E.g: SCIENCE\_2 Date - Total Students Present 9/28/2023 - 15 9/24/2023 - 11 9/21/2023 - 13 Any ideas what I can do to have this presented on a page? ---
**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:** [September 27, 2023, 1:03am UTC](https://community.glideapps.com/t/need-dashboard-help/66552/2 "2023-09-27T01:03:52Z")
If row count isn’t a problem to you, maybe you can run a daily external automation to fetch all classes in your database, and add a row to a “Class x Date” table where you have each combination of class and date on its own row. You can also add a “schedule” for each class, say “Mon, Wed, Fri”, check if the current weekday is listed in each class’ schedule, and only adding when the schedule is on for that day. Alternatively, I think you can use a relation + lookup combo to fetch all unique dates that a student has logged a timestamp, for each class, then use a helper table to transpose that data on the fly when you view a class, and use rollups to count the students. I don’t know if this fits with your dashboard structure or not, since it is dynamic based on the class you’re viewing. ---
**Author:** ![Jireh\_Lee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jireh_lee/32/52727_2.png) [@Jireh\_Lee](https://community.glideapps.com/u/Jireh_Lee)\ **Post date:** [September 27, 2023, 1:36am UTC](https://community.glideapps.com/t/need-dashboard-help/66552/3 "2023-09-27T01:36:38Z")
Could you give me an example of the 2nd suggestion? I’m hoping to use lookup and roll up because I’m trying to keep all my data on Glide’s tables