Forum Discussion
Meetings by duration and number of attendees card - how to reproduce
Hi VI_Migration!
Have you tried running a Person Query, where the base metric is "Meetings" and applied the filters as per below? Also not sure if this was a typo but the greater than/less than signs in your post appear incorrect 🙂
I do believe that the main callout is based on meeting time (ie. % of meeting hours), and the second visual is based on meeting counts (ie. % of meetings) - and both appear to be based on a Person Query. The other thing you could do is interrogate the data by clicking on the "See your insights" button on the card, and then clicking on "Explore in Power BI" as per screenshot below. This might assist with assessing the calculations.
As you have referred to, the meeting query focuses on the metrics from a meeting perspective, and a person query focuses on the person's perspective. So it makes sense for the meeting counts to be vastly different when comparing the meeting query to the person query. The glossary probably explains it a little better - https://docs.microsoft.com/en-us/viva/insights/use/metric-definitions#peer-comparison-metrics.
With regards to internal vs. external on the Meeting Query, you could create a filter on your query as per below, and this will show external organizers. You could then set the value to True, to assess the difference between internal and external.
For the greater than and less than, I was referring to the direction of the < but this is not important in this context so please forget I mentioned it hahahaha!
Hi VI_Migration ! Thanks for the thorough explanation. I wrote out the metric filters using code syntax for speed, so <= represents ≤ 🙂
To clarify, when I ran a Meeting Query grouped by Organization, I got a total count 455K meetings year to date. I downloaded the PBI template you shared and got ~3.3M meetings year to date, but from the Person perspective.
I'm assuming a lot of those meetings are the same meetings that have multiple attendees, but in addition, when we run Meeting queries, are those only meetings whose organizers are internal? Or does that include meetings organized externally?
Thanks so much for all your help.
As you have referred to, the meeting query focuses on the metrics from a meeting perspective, and a person query focuses on the person's perspective. So it makes sense for the meeting counts to be vastly different when comparing the meeting query to the person query. The glossary probably explains it a little better - https://docs.microsoft.com/en-us/viva/insights/use/metric-definitions#peer-comparison-metrics.
With regards to internal vs. external on the Meeting Query, you could create a filter on your query as per below, and this will show external organizers. You could then set the value to True, to assess the difference between internal and external.
For the greater than and less than, I was referring to the direction of the < but this is not important in this context so please forget I mentioned it hahahaha!
Perfect, that all makes sense, and I did confirm the numbers matched when I ran a person query with Meeting base metric 🙂
Really appreciate it VI_Migration !