Forum Discussion

MSWilko's avatar
MSWilko
Former Employee
Dec 09, 2022

Teams Live Event Attendee Report - Track Attendee Duration

Hi, 

Part of my role at work is to host live training webinars using Microsoft Teams - Live Event and Webinars. Using the attendee report that is produced by Microsoft Teams, I would like to be able to:

1. Understand how long an attendee has joined the webinar for.
2. Understand how many people are in the webinar at any point  (example at the 2 minute mark there were 20 people in the webinar, at the 15 minute mark there were 50 people in the webinar, at the 30 minute mark there were 40 people, etc.

The attendee report provides the Time Stamp, and the Action that took place at that time stamp (Joined/Left).

If someone has an idea of the functions in excel that would be ideal to use to extract this information would be great. Thank you.

excel

9 Replies

Sort By
  • mtarler's avatar
    mtarler
    Silver Contributor
    Dec 09, 2022

    It would be helpful to have a sample sheet so we can see how the actual data is presented and ideally include an example of what you are trying to get out. But assuming the data is:
    TimeStamp | UserID | Action
    Assuming all users are in same columns of data as indicated above and that the log is complete and will have logon and exit for every user then to know:
    how long an attendee joined:
    =Sumifs( [TimeStamp], [UserId], user, [Action], "Exited"] - Sumifs( [TimeStamp], [UserId], user, [Action], "Joined"]
    NOTE: this will add times together if the SAME UserID logged off and back on multiple times

    how many people are in the webinar at any given time should be something like:
    =Countifs( [TimeStamp], "<"&time, [Action], "Joined"] - Countifs( [TimeStamp], "<"&time, [Action], "Exited"]

    • MSWilko's avatar
      MSWilko
      Former Employee
      Dec 12, 2022
      Hi mtarler, I have uploaded a sample document! 🙂 In the meantime, will try the above. Thank you for your comment!
      • mtarler's avatar
        mtarler
        Silver Contributor
        Dec 12, 2022

        MSWilko  see attached.  The concept I used was the same but:

        a) made the original data table formatted as a table to use table references

        b) added a new Date Time column because the original one is text instead of a Date Value

        c) used MAP and LAMBDA to automatically calculate the full array instead of fill down

         

        hope this helps

         

Resources