Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

Reporting on the Number of Distinct Items Worked on by Quarter

Avatar

Level 4
Hi all, I'm trying to create a report of the number of distinct issues that have been worked on by quarter for a particular team. I have tried an hours report, but the record count there doesn't cut it because there can be multiple hour entries on one issue within the same quarter. Thanks in advance, James James Bender Jackson/JTS
1 Reply

Avatar

Level 4
You can try a work-item report. You can also convert a COUNT aggregate in your hours report to DCNT (Distinct Count). Easiest way to do this is on a number column like a reference number for the issue/task/project. -- Melinda Layten, Senior Consultant Work Management Improvement CapabilitySource Phone: (484) 505-6855 site: www.capabilitysource.com email: melinda.layten@capabilitysource.com Helpful? Buy me a coffee: https://www.patreon.com/mlayten - we simplify your work so you can run your business -