# Charts for Reports (costs and hours worked)
**URL:** https://community.glideapps.com/t/charts-for-reports-costs-and-hours-worked/13335
**Category:** Ask for Help
**Created:** [July 31, 2020, 2:12am UTC](https://community.glideapps.com/t/charts-for-reports-costs-and-hours-worked/13335 "2020-07-31T02:12:48Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@Alexdz](https://community.glideapps.com/u/Alexdz)
#### Post date: [July 31, 2020, 2:12am UTC](https://community.glideapps.com/t/charts-for-reports-costs-and-hours-worked/13335/1 "2020-07-31T02:12:48Z")
I am working on a report, where a company has different projects and they can input every day the amount of hours each worker has worked on the project. Each worker has a value of costs per hour, so the total costs per day are automatically calculated.
I would like to show a chart where the total amount of hours worked (and costs) are shown per project. I can’t get it set up correctly. The charts feature seems to pull in the values of the whole sheet, even if you place it on a single item screen - and dynamically filtering based on the project, which is opened by the user, doesn’t seem to work either.
It’s late here, so maybe I just hit a mind block or is there really no workaround for this?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [July 31, 2020, 3:22am UTC](https://community.glideapps.com/t/charts-for-reports-costs-and-hours-worked/13335/2 "2020-07-31T03:22:25Z")
I believe you can point a chart to a relation, so if you have your relation set up correctly, it will be filtered data.