{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/2902e7077063426eb6c21c023f87b0c8\" frameborder=\"0\" width=\"1908\" height=\"1431\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1431,"width":1908,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1431,"thumbnail_width":1908,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/2902e7077063426eb6c21c023f87b0c8-86e48856c477180b.gif","duration":193.7,"title":"Creating Point-in-Time Headcount Queries","description":"Hi there, I am Adriana, and in this video I show you how to create a query on point in time headcount. You can use it to see how many employees you had on a specific day for turnover reports, payroll management, operational planning, recruiting, and more. I walk you through building a Leavers query by setting the start date to less than and the final date of employment to greater than, including an example for the 1st of May. I also show how to pull employees for all of 2023 by adjusting filters to 1 January 2024 and 31 December 2023. I ask you to use the digital assistant if you need help, and to watch your results after you click save."}