Hi folks, I'm hoping someone might be able to help 🙂
I have an MS Teams meeting attendance report that shows each attendee, as well as their join and leaving timestamps. I'd like to put a report together that shows the total attendance number for the meeting on a minute-by-minute basis, perhaps in a line graph. I'm presuming I'd need a DAX query for that.
Here's some sample data:
| Full Name | UTC Event Timestamp | Action |
| Peter Peterson | 3/1/2023 1:02 | Joined |
| Peter Peterson | 3/1/2023 1:49 | Joined |
| Peter Peterson | 3/1/2023 1:42 | Left |
| Peter Peterson | 3/1/2023 1:55 | Left |
| Aaron Aaronson | 3/1/2023 0:59 | Joined |
| Aaron Aaronson | 3/1/2023 2:02 | Left |
| Adam Adamson | 3/1/2023 1:02 | Joined |
| Adam Adamson | 3/1/2023 2:03 | Left |
| Adrienne Adrienneson | 3/1/2023 0:57 | Joined |
| Adrienne Adrienneson | 3/1/2023 1:01 | Joined |
| Adrienne Adrienneson | 3/1/2023 1:01 | Left |
| Adrienne Adrienneson | 3/1/2023 2:03 | Left |
| Agnes Agnesson | 3/1/2023 1:03 | Joined |
| Agnes Agnesson | 3/1/2023 2:03 | Left |
Any help would really be appreciated 🙂
