Reporting - How can I find out which Events have the highest and lowest attendance?

*** Please note, this article refers to Reporting and Analytics with Power BI. View the FAQ for more details. ***

In this article, we'll show how to find out which Events have the highest and lowest attendance. LMS administrators can use this information to evaluate overall engagement and participation, for example to: 

• Identify and address reasons for low attendance
• Track attendance as a key performance indicator
• Tailor offerings to attract more participants

To answer this question, we'll use the Event management and analysis report. 

Steps to find the Events with the highest or lowest attendance

1. Open the Event management and analysis report
2. Select the Event start date filter:
3. Select is before from the 'Show items when the value' drop-down menu
4. Enter today's date (or another date if preferred)
5. Select Apply filter:
6. Select All Events:
7. A table listing All Events with a date in the past will be listed. Scroll to the right, and select the #attendees column title. The column will be sorted to show the Event with the highest number of attendees:
8. Select the #attendees column title again. The sort order will be reversed. The Event with the fewest attendees will now be listed at the top:

Note that the summary dashboard also contains a metric for 'Empty events'. Select this option to see a list of all Events where there were no bookings at all:

Export, save, and share the results

Now you have the results, what next? 

• Save and share a report view
• Organise report views into groups
• Export a table visual straight to Excel

To print the screen straight to PDF, select CNTRL+P. Alternatively, use a snipping tool to grab a specific area. 

Discover more about the Fixed reports

Want to get the most out of Fixed Reports? Our step-by-step guides cover the top queries on compliance and Event management, helping you use Fixed Reports effectively while learning key techniques along the way.

When you're ready to explore further, view Key techniques for using the Fixed reports in which Gary walks through real-world use cases.

Need quick answers? Check out FAQ, Reporting and Analytics with Power BI, packed with over 100 common questions and links to in-depth resources. You can also join our regular Ask Me Anything: Reporting live events - come along and ask your question directly to our panel of experts. 

Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.