Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
You can create an hours report that is filtered for your time period and grouped by user.
You then need to add the Project Reference Number as a column and summarize the column by count.
This will equal the number of entries, so not what you want.
Edit the column and switch to text mode. Change CNT to DCNT
This is Distinct Count and will give you what you want. It doesn't always work correctly on the overall totals, but each sub-total will be right.
The whole text mode will look like this:
aggregator.displayformat=int aggregator.function=DCNT aggregator.namekey=view.relatedcolumn aggregator.namekeyargkey.0=project aggregator.namekeyargkey.1=referenceNumber aggregator.valuefield=project:referenceNumber aggregator.valueformat=intAsInt displayname= linkedname=project namekey=view.relatedcolumn namekeyargkey.0=project namekeyargkey.1=referenceNumber querysort=project:referenceNumber textmode=true valuefield=project:referenceNumber valueformat=int
Melinda Layten
mlayten@gmail.com
Independent Workfront Consultant
Views
Replies
Total Likes
Views
Replies
Total Likes