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件のコメント
Avatar
Vladimir Bugay

Steve, have you tried this setup?

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

@... 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 Wrike Discover で Wrike のエキスパートになろう

Basudha Sakshyarika Wrike Team member Wrike Discover で Wrike のエキスパートになろう

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]

トップ

今後のライブセッション

お探しのものが見つかりませんか? 新しい投稿を作成する