Forum Discussion
How to Validate After-hour Meeting Hours
MicrosoftHi 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.
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
