Expand my Community achievements bar.

Quiet Time on Project

Avatar

Level 10
We can report on time when hours have been logged on a projects. Is there any way to report on quiet period within a project? To show weeks when now work (no hours logged) has been carried on a project? Thanks, Dags Dagmara Garwell BAKKAVOR LTD
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

5 Replies

Avatar

Level 10
Hi Dags, To illustrate "quiet time", I'd suggest you create an Hours Matrix Report, Grouped by Projects on each row, and the Weeks on each Column: low numbers (or blanks) = "quiet". You could also: add prompts chart it (e.g. as stacked area might be interesting) drop it (e.g. as a chart) onto a dashboard, then add that dashboard as a custom tab (e.g. called "Weekly Pace") under Projects, so that when the tab is clicked, it would then automatically restrict to show only the Weekly Pace for that current Project Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

Avatar

Level 10
Hi Doug, How would i actually do it? I've started creating the Hour report but i'm not sure how to show days without any hours logged on a project or what calculation should i use... Any help on that please? :) Dagmara Garwell BAKKAVOR LTD

Avatar

Level 10

0690z000007ZiM3AAK.pngYou bet, Dags: The Trick, and The Quiet Time is attached. Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

Avatar

Level 10
Oh that's brilliant, thanks Doug! Didn't know that tricky option exist on matrix report :) I guess there is no way to shows only quite time on charts ? That might be pushing my luck to far heheh.. Dagmara Garwell BAKKAVOR LTD

Avatar

Level 10
Thanks Dags! Fortunately, Luck Pushing is one of my specialties: if you squint at my photo closely, what I'm holding are the TWO four leaf clovers I found on a hike with the kids, minutes apart. The moral, I told them, is to always keep looking. And they did. So yes, although the charts don't currently honor the "show missing weeks" setting, you too have a few options to look at: raise it as a bug and ask Workfront to correct it (which would then behave as Excel does) use our "http://store.atappstore.com/product/magic-reports/">Magic Report solution to create a report for you that shows the gaps graphically create a dummy Project and record one hour against it in every week, then include it in your filter so that those weeks always appear Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads