Description - Similar to the Count, Sum, Ave, etc functions available on columns in reports and charts, add the DCNT (unique count) function for several objects.
Why is this feature important to you -There are several scenarios we have and that I have seen across the community where we need UNIQUE count values. Examples:
1) Count of unique projects that an assignee has. Pull all open/active assignments then show the count of active (unique) projects for each assignee. It's great to have a count of open assignments per assignee, but management wants to know how many projects each assignee is currently assigned (and no, project users doesn't work because we only want to see the project counted when the person has an active/open task or issue)
2) Show UNIQUE assignees on a project report
How would you like the feature to work - Similar to the COUNT function but DCNT. We need the UNIQUE counts to show on the groupings, the summary tab, and available in charts.
Current Behaviour - DCNT works only in groupings BUT not an option on the drop-down like COUNT, must force in text mode. And even when you have text mode, you can't see the unique count on the summary tab or use it in a chart.
