How to Validate After-hour Meeting Hours

Hi, Hope you are doing well! I found some overwhelming after-hour meeting hours examples. Can I ask if the method I used to validate the data here is correct? Or if there is anything else I can u...

luhogner

Microsoft

Feb 11, 2022

Hi VI_Migration, can you share an example of the validation you are trying to do? As I understand it, you are comparing the Ways of working assessment query, which is a Person query, with a Person to group query. In a Person query, you can analyze data from the point of view of each individual. In a Person to group query, you can understand how an individual invests their time with others in the organization. Person to group queries use time allocation. Here is an overview of time allocation.

Here is an example of how you can compare data in both types of queries.

Person query

PersonId	Date	Meeting_hours	Organization
PersonA	1/30/2022	12	Finance

Person to group query, assuming you chose to group collaborators by Region

PersonId	Organization	Collaborators_Region	Date	Meeting_hours
PersonA	Finance	North America	1/30/2022	8
PersonA	Finance	EMEA	1/30/2022	3
PersonA	Finance	Asia	1/30/2022	1

If you take the output of the Person to group query and you sum meeting hours for each PersonId and Date, you will get the same numbers as you get in the Person query. In our example above, PersonA spent a total of 12 hours in meetings the week of January 30th, 2022. Out of those 12 hours, 8 were spent with folks in North America, 3 with folks in EMEA, and 1 with folks in Asia.

VI_Migration

Silver Contributor

Feb 12, 2022

Hi luhogner ,

Thanks for your reply!

Yes, I did follow the steps you mentioned above to validate the data.

I used the Person query to identify the user with overwhelming after-hour meeting hours on a specific week. Then I filter the user for that specific the week and sum up the meeting hours in Person to Group Query to compare with the number I got from the Person query. In my testing cases, they have pretty big discrepancies and maybe I missed some steps in the validation process. I am happy to set up a brief call to provide more details if needed.

Below is an example of how I compare data in both types of queries.

Person query

PersonId	Date	Meeting_hours	Organization
PersonA	1/30/2022	62	Finance

Person to group query, I group by the Date

PersonId	Organization	Date	Meeting_hours
PersonA	Finance	1/26/2022	2
PersonA	Finance	1/24/2022	1
PersonA	Finance	1/28/2022	1

Thanks!

Sandy

Forum Discussion

How to Validate After-hour Meeting Hours