Hi,
I’ve got a SharePoint calendar of events on our company’s intranet site and we want to be able to report on how many people attended each session and how many sessions each person has attended.
To support this, I create attendance list (with a lookup field to event name). However, I’m using excel to produce the reports and because I’m using a person or group field for attendee name, the field is exported as a number rather than a name.
So, I have two questions:
1) How can I produce the report using names rather than numbers?
2) How can I join the two tables to show the details about the session (particularly date and time) of the session?
Any help would be greatly appreciated. We’re using SharePoint Online, Nintex Forms & Workflow for 365 and I have access to Power BI, but it’s not widely used.
Thanks,
Katherine
