Quiet Time on Project

[DagmaraGa]

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

[Doug_Den_Hoed__AtAppStore]

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

[DagmaraGa]

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

[Doug_Den_Hoed__AtAppStore]

You 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

[DagmaraGa]

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

[Doug_Den_Hoed__AtAppStore]

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