Log in as admin Create three new users Lionel Smith Lionel Jones Lionel Smith Navigate to Reports > Report builder > Custom reports in site administration Create a new report from the Users report source Ensure Include default setup is unchecked In the report editor, add the Users > Full name column Open Conditions Add User > First name condition for Is equal to: Lionel (for convenience) Set Full name column aggregation to Comma separated values Confirm report row shows the following: Lionel Jones, Lionel Smith, Lionel Smith Set Full name column aggregation to Comma separated distinct values Confirm report row shows the following: Lionel Jones, Lionel Smith Set Full name column aggregation to Count Confirm report row shows the following: 3 Set Full name column aggregation to Count distinct Confirm report row shows the following: 2