0

I have attendance data for a virtual meeting. This includes the employee name, their direct manager, and their respective join/leave timestamps. Some employees coming and going multiple times (see rows 5 and 6)

enter image description here

I'd like to create a visualization showing attendance (as a percentage of total attendees) over the course of the meeting session, beginning to end.

To do this, I figured I'd create a table with the first column being a sequence of times starting from the min(join_time) and ending with the max(leave_time) broken down in 30 second intervals. Then add summary columns that count the total instances where that time falls in an employee's join/leave time like this...

enter image description here

I'm working in R within the tidyverse so if there's a dplyr, lubridate solution that'd be ideal.

Gregor Thomas
  • 136,190
  • 20
  • 167
  • 294
Shlammed
  • 21
  • 3
  • 2
    Please [do not post code or data in images](https://meta.stackoverflow.com/q/285551/2372064). Share your data in a [reproducible format](https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example) to make it easier to test and verify possible solutions. – MrFlick Feb 02 '23 at 17:59

0 Answers0