# Monthly overview of daily inputs

**URL:** <https://community.glideapps.com/t/monthly-overview-of-daily-inputs/16242>\
**Category:** Ask for Help\
**Created:** [September 23, 2020, 12:38pm UTC](https://community.glideapps.com/t/monthly-overview-of-daily-inputs/16242 "2020-09-23T12:38:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alexdz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexdz/32/10382_2.png) [@Alexdz](https://community.glideapps.com/u/Alexdz)\
**Post date:** [September 23, 2020, 12:38pm UTC](https://community.glideapps.com/t/monthly-overview-of-daily-inputs/16242/1 "2020-09-23T12:38:12Z")

</div>

Hello! I have an app, where a user types in each day how many hours a worker has worked for that day.

I would like to give a monthly overview of the amount of hours each worker has worked for every month. The hours will be multiplied by the hourly wage of the worker.

**For example:**

Daily inputs:  
1st September 2020: Worker A = 6 hours, Worker B = 8 hours, Worker C = 7 hours  
2nd September 2020: A = 7 hours, B = 8 hours, C = 9 hours  
…

Total of hours worked in September 2020:  
Worker A: 90 hours (to be paid: €1.800)  
Worker B: 96 hours (to be paid: €1880)  
Worker C: 102 hours (to be paid: €1960)

What could be an approach to get a monthly overview of the daily inputs?

---

<div class="post-metadata">

**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 24, 2020, 1:38am UTC](https://community.glideapps.com/t/monthly-overview-of-daily-inputs/16242/2 "2020-09-24T01:38:59Z")

</div>

If you don’t need immediate updates for the app (can live with a bit of lagging) then I think query is the best solution for this.

Something like.

```
=QUERY(Daily inputs!A:C,"SELECT A, B, SUM(C) GROUP BY A, B LABEL SUM(C) ''")
```