Hi - I’m trying to create a report that lumps together project/task logged hours vs all other time. Our project and task time is under the preset hour type of general so I can’t use that to build the report. I basically want to see a pie chart with 1 color lumping project/task time together and the other color references all other logged hours (general, sick, corp meetings, etc). Any ideas?
Hi Rebecca, my first thought was to have a calculated field in an hr custom form to basically categorize your hours (project/task = A, all other types = B) and group by that field in a chart but then remembered there isn’t a custom form type for Hour object (feel free to upvote an idea for that here). My next thought is to just use project ID as a way to distinguish time from a project (task or project) vs. all other time, but not sure how to cleanly put that in 1 report bc if you group by Project ID for example, you won’t even be able to you, you’d have a million project IDs. So you may just need 2 reports side by side in a dashboard: 1 for project/task time where you have a filter for Project ID is not blank and maybe group by quarter or whatever appropriate (clean) grouping and any other appropriate filters like entry date. Then the other for Project ID is blank with the same clean grouping/other filters for easy comparison. This is assuming your sick time and everything else is only entered in timesheets and not in a WF project.
Curious of other ideas here...
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.