Creating a Report that shows total time spent on Projects in a given time frame

I need to pull a quarterly report for total time spent by project (not user, not task) that reflects time logged in that period, filtered by a LOB custom field. 

I currently have a report that generates this for all projects created in a quarter's time frame using custom time frame (and as a backup I have a Quarter custom field). This, however, does not show time spent during the quarter for projects that were created outside of that time frame. So, projects that were initiated at the end of the previous quarter where the bulk of the time spent is in the current quarter do not show up. 

It must be by project, not user.

Anyone able to help a guy out? 😅 TIA!

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
3 comments

Steve, have you tried this setup?

Vladimir Bugay Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover

Vladimir Bugay Wrike Team member Become a Wrike expert with Wrike Discover

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Vladimir Bugay yes, I got there myself, thanks! Works ok for what i need. Thanks.

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Steve Mruskovic: That's great! Please let us know if you have any additional questions. Thank you!

Basudha Sakshyarika Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover

Basudha Sakshyarika Wrike Team member Become a Wrike expert with Wrike Discover

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Creating a Report that shows total time spent on Projects in a given time frame
[this list is visible for admins and agents only]

Top
Didn’t find what you were looking for? Write new post