I would like to get some dashboards setup for our PMs and one of the things that consistently get's requested is to see a breakdown by work day (M-F) of how much time was reported. This way, if they see on Monday that zero time was reported they can go back and update any specific project plan of work that they did that day. The screenshot attached is similar to something I would like to have.
We are trying to make it easier for them to update their time sheets incase they missed something and forgot to report time on work that they did.
Please sign in to leave a comment.
Create a Report on Timesheet and include Reported by or any other data you wish to include. Filter by Reported by and Reported Date specify Last Week so that it is a rolling time frame. That should get you the report you want.
Thanks for the reply.
To clarify though, I was curious more about how to display the information. I was able to build the report pretty easy but wanted to find a way where I could visualize it via a graph. I can see that you can group dates by quarter, months, and weeks but I was look for grouping by day since the report is filtered to only show 1 weeks worth of data. Also, can you still show a 'zero' value for a day if no time was reported? Similar to how I have it setup in the attached picture.
Garrett,
This can be done through Highlights, not really graphs as this only uses fields to show data. If you want show grouping by day, this can be done in the Table and show 0 where available.