Help with Dashboards
*New to the creator
Im trying to display weekly productivity numbers in the dashboard per region.
My Form fields:
#hours (billable hours)
Available hours ( number of available hours per employee per week)
Productivity (formula field) #hours/available hours *100 round 2
Total Productivity ( sum of all productivities / by number of employees
Problem: I can not figure out how to display the total productivity.
Example:
Annette_A (employee) | 7 billable hours | 28 (available hours) | Project X = 25%
Annette_A (employee) | 7 billable hours | 28 (available hours) | Project Z = 25%
Joe_A (employee) | 15 billable hours | 30 (available hours) | Project Y =50%
Total productivity = 50% per week ending 6/26/22
I appreciate any help you can provide.