Timesheet reporting

3 replies
19 views
Translate All

Team:

I am looking to create a report of logged hours by resources for a group of projects to determine our work effort.

I am having no luck. any suggestions? Thank you

Lyndsy-Denk

Adobe Champion and Community Advisor

Hi, @BRIANDA1. Can you tell us more about what you’ve already tried? When you say “by resources,” do you mean by resource pool? By job role?

As for the group of projects, if they’re not already organized into a portfolio or program, I recommend they be organized that way to make the report filtering easier. Otherwise you’ll need some other shortcut for filtering, perhaps by a custom form.

Translate

B

BRIANDA1Author

Level 2

Thanks for responding. I actually need time sheets for particular resources (by name), that work on projects in a campaign. I have tried project reports and timesheet reports, but I cannot seem to get to the heart of what I am looking for.

We have a business partner that keeps asking for more and more and I am trying to show the amount of time our creative teams spend on their projects.

Translate

Lyndsy-Denk

Adobe Champion and Community Advisor

I think the report type you want is Hours, not Timesheet. A timesheet report looks at the actual timesheet as an object whereas an hours report will look at the data within timesheets.

If that doesn’t hit the mark, tell us what the heart of your questions is and we can probably go deeper.

In general, when getting to know how to build reports, I like to start with what others have done. There are some canned reports you can find, copy, and then adapt. These can be found in the Reports area when you select All Reports in the left menu There are a couple filters I recommend you build to help focus:

Entered By » Username IS BLANK shows you all reports that are system-generated.
Report » Type = HOUR shows just Hour reports. (How did I find that code? The API Explorer.)

Translate

Sign up

Login with SSO

Login to the community

Login with SSO