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 commenti

Steve, have you tried this setup?

Vladimir Bugay Community Team at Wrike Wrike Product Manager Conosci le straordinarie funzionalità di Wrike e le best practices

Vladimir Bugay Wrike Team member Conosci le straordinarie funzionalità di Wrike e le best practices

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 Conosci le straordinarie funzionalità di Wrike e le best practices

Basudha Sakshyarika Wrike Team member Conosci le straordinarie funzionalità di Wrike e le best practices

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]

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