Power BI Connector metrics

Important

This article is for the legacy Workplace Analytics app and does not reflect functionality available on the updated Viva Insights platform. Access current documentation for Viva Insights advanced insights here: advanced insights documentation.

The following base metrics are imported from Viva Insights into Power BI through the Power BI Connector. These base metrics are imported when you only enter a Partition Identifier and not any Query Names or Query Identifiers. For details, see Connect through the Power BI Connector. Customized or calculated metrics that are not available in Viva Insights as base metrics, show as Not applicable in the Viva Insights metric column.

Power BI Connector metric Viva Insights metric Definition Data type
AfterHoursCollaboration After hours collaboration Number of hours the person spent in meetings and on email outside of working hours. Hour
AfterHoursCollaborationCalls After hours in calls Number of hours a person spent in scheduled and unscheduled calls through Teams, outside of working hours. For calls that started during working hours, this number only includes the part of the call that occurred outside of that person’s work schedule (as set in Outlook). Hour
AfterHoursCollaborationEmails After hours email hours Number of hours the person spent sending email outside of working hours. Hour
AfterHoursCollaborationInstantMessages After hours instant messages Number of hours a person spent in instant messages through Teams, outside of working hours. Hour
AfterHoursCollaborationMeetings After hours meeting hours Number of hours the person spent in meetings outside of working hours. Hour
AfterHoursMailsSentCount Not applicable Number of emails the person sent outside of working hours. Count
CallsCount Total calls Total number of calls a person joined through Teams, including scheduled and unscheduled calls during and outside of working hours (as set in Outlook). Count
CollaborationHours Collaboration hours Number of hours the person spent in meetings and on email with at least one other person. Collaboration hours include both internal and external hours. Hour
CollaborationHoursAdhocCalls Not applicable The number of hours the person spent in unscheduled calls through Teams with at least one other person, during and outside of working hours. Hour
CollaborationHours Collaboration hours Number of hours the person spent in meetings and on email with at least one other person. Collaboration hours include both internal and external hours. Hour
CollaborationHoursAdhocCalls Not applicable The number of hours the person spent in unscheduled calls through Teams with at least one other person, during and outside of working hours. Hour
CollaborationHoursCalls Call hours The number of hours the person spent in scheduled and unscheduled calls through Teams with at least one other person, during and outside of working hours. Hour
CollaborationHoursEmails Email hours Number of hours the person spent sending and receiving emails. Hour
CollaborationHoursExternal Collaboration hours external Number of hours the person spent in meetings and on email with at least one person outside the company (as defined by the participant’s email domains). Hour
CollaborationHoursInstantMessages Instant message hours Number of hours a person spent in instant messages (IMs) through Teams with at least one other person, during and outside of working hours. Hour
CollaborationHoursInternalOutsideOrg Not applicable Number of hours the person spent in meetings and on email with internal employees only (as defined by the participant’s email domains) outside their Organization. Calculation uses Organization attribute. Hour
CollaborationHoursMeetings Meeting hours Number of hours the person spent in meetings with at least one other person. Hour
CollaborationHoursScheduledCalls Not applicable The number of hours the person spent in scheduled calls through Teams with at least one other person, during and outside of working hours. Hour
ConflictingMeetingHours Conflicting meeting hours Number of meeting hours where the person had overlapping meetings in their calendar. The count includes the entire duration of all overlapping meetings, not just the amount of time that overlaps. (This number includes all non-declined meeting times, which includes accepted, tentative, or no responses to meeting invitations.) Hour
Date Required HR attribute Same as MetricDateMonth. Date
DecisionMakingMeetingCount Not applicable Number of meetings that the person attended where attendee count less than nine and the duration is less than or equal to one hour. Count
DirectManagerMeetingHours Meeting hours with manager Number of meeting hours where attendees included at least the person and their manager. Hour
External Not applicable Number of hours the person spent in meetings and on email with at least one person outside the company (as defined by the participant’s email domain). Hour
ExternalCollaborationCost Calculated by Viva Insights Cost of external collaboration which is calculated as CollaborationHoursExternal multiplied by average Hourly Rate. USD
ExternalNetworkBreadth Networking outside company The number of distinct external domains outside the company a person has had at least two meaningful interactions in the last four weeks. Count
ExternalNetworkSize External network size The number of people external to the company with whom the person had at least two meaningful interactions in the last four weeks. Count
FragmentedTime Calculated by Viva Insights A person's time after you subtract their meeting hours and their focus hours. Hour
HourlyRate Required HR attribute or calculated by Viva Insights The employee’s salary represented as an hourly rate in US dollars. If not available in Viva Insights, calculations use $75 USD as the average hourly rate. String
InferredTeamSize Calculated by Viva Insights Team size of the person not including themselves. If Individual Contributors equal zero, calculations use the count of both direct and indirect reports for the team size. String
InstantMessagesCountSent Instant messages sent Total number of instant messages (IMs) sent by a person through Teams, during and outside of working hours. Count
InternalNetworkBreadth Networking outside organization The number of distinct organizational units within the company that the person had at least two meaningful interactions in the last four weeks. Calculation uses Organization attribute. Count
InternalNetworkSize Internal network size The number of people within the company with whom the person had at least two meaningful interactions in the last four weeks. Count
InternalOnly Not applicable Number of hours the person spent in meetings and on email with internal employees only (as defined by the participant’s email domains). Hour
IsActive IsActive True if the employee sent at least one email or one instant message during the specified time period. Logic
LargeNotLongMeetingCount Not applicable Number of meetings that the person attended with greater than or equal to nine attendees and the duration is less than or equal to one hour. Count
LevelDesignation Required HR attribute The employee’s level is specific to your organization and can represent an employee’s experience or management level, or seniority within the organization. This data is needed to correctly calculate metrics for redundancy and insularity. String
LongAndLargeMeetingCount Not applicable Number of meetings that the person attended with greater than or equal to nine attendees and a duration of greater than one hour. Count
LongNotLargeMeetingCount Not applicable Number of meetings that the person attended with less than nine attendees and a duration of greater than one hour. Count
LongOrLargeMeetingHours Not applicable Number of hours the person spent in meetings with more than nine attendees and a duration of greater than one hour. Hour
LowQualityMeetingHours Low-quality meeting hours Number of meeting hours in which an attendee multitasked, attended a conflicting meeting, or attended a meeting that exhibits redundancy (organizational). Hour
LowQualityMeetingsCost Calculated by Viva Insights Cost of low-quality meetings that’s calculated as LowQualityMeetingHours multiplied by Hourly Rate. USD
MailHoursLoadOrganizedAfterHours Not applicable Number of email hours the person created for internal recipients by sending emails outside of working hours. Hour
MailsSentCount Emails sent Number of emails the person sent. Count
ManagerId Required HR attribute De-identified ID number for the manager of the person represented in the metric. You can only calculate aggregations, such as counts, of this field. Attempting to return a list of all ManagerIds will result in an error. String
MeetingHours30To60Min Not applicable Number of hours the person spent in meetings with at least one other person and a duration of between 30 to 60 minutes. Hour
MeetingHoursLessThan30Min Not applicable Number of hours the person spent in meetings less with a duration of 30 minutes with at least one other person. Hour
MeetingHoursLessThan8Attendees Not applicable Number of hours the person spent in meetings with less than eight attendees. Hour
MeetingHoursLessThanOneHour Not applicable Number of hours the person spent in meetings with a duration of less than or equal to one hour with at least one other person. Hour
MeetingHoursOver4Hours Not applicable Number of hours the person spent in meetings with a duration equal to or more than four hours with at least one other person. Hour
MeetingHoursOverOneHour Not applicable Number of hours the person spent in meetings with a duration of more than one hour with at least one other person. Hour
Meetings19PlusAttendees Not applicable Number of hours the person spent in meetings with 19 or more attendees. Hour
Meetings2Attendees Not applicable Number of hours the person spent in meetings with one other person. Hour
Meetings3To4Attendees Not applicable Number of hours the person spent in meetings with between three and four attendees. Hour
Meetings5To8Attendees Not applicable Number of hours the person spent in meetings with between five and eight attendees. Hour
Meetings9To18Attendees Not applicable Number of hours the person spent in meetings with between 9 and 18 attendees. Hour
MeetingsCount Meetings Number of meetings the person attended. Count
MeetingsHours1To2Hours Not applicable Number of hours the person spent in meetings that were between one to two hours in length with at least one other person. Hour
MeetingsHours2To4Hours Not applicable Number of hours the person spent in meetings that were two to three hours in length with at least one other person. Hour
MeetingsHoursLoadOrganizedAfterHours Not applicable Number of meeting hours the person created for internal attendees by organizing meetings outside of working hours. Hour
MeetingsLoadOrganizedAfterHours Not applicable Number of internal meetings organized by the person outside of working hours. Count
MetricDate Calculated by Viva Insights The week start date for the first day of the week that data is being aggregated for. For example, Sunday. Date
MetricDateMonth Calculated by Viva Insights The metric date for the first day of the month that data is being aggregated for. For example, March 1st. Date
MultitaskingMeetingHours Multitasking meeting hours Number of meeting hours where the person sent two or more emails during a meeting, or two or more emails during a meeting that was less than one hour. Hour
NonConflictingMeetingHours Not applicable Total number of meeting hours minus the number of ConflictingMeetingHours. Hour
NonDirectManagerMeetingHours Not applicable Total number of meeting hours minus the number of DirectManagerMeetingHours metric. Hour
NonLowQualityMeetingHours Not applicable Total number of meeting hours minus the number of LowQualityMeetingHours. Hour
NonMultitaskingMeetingHours Not applicable Total number of meeting hours minus the number of MultitaskingMeetingHours. Hour
NonOneOnOneMeetingHours Not applicable Total number of meeting hours minus the number of OneOnOneMeetingHours metric. Hour
NonRecurringMeetingCount Not applicable Total number of meetings the person attended minus the number of recurring meetings. Count
NonRecurringMeetingHours Not applicable Number of hours the person spent in non-recurring meetings with at least one other person. Hour
NonRedundantMeetingHours Not applicable Total number of meeting hours minus the number of RedundantMeetingHours metric. Hour
NonSkipLevelMeetingHours Not applicable Total number of meeting hours minus the number of SkipLevelMeetingHours metric. Hour
OneOnOneInstantMessagesCountSent Not applicable Total number of instant messages (IMs) sent by a person to exactly one recipient through Teams, during and outside of working hours. Count
OneOnOneMailsCountSent Not applicable Number of emails the person sent to exactly one recipient. Count
OneOnOneMeetingHours Meeting hours with manager 1:1 Number of meeting hours involving only the person and their manager. Hour
OpenOneHourBlocks Open one-hour block Number of one-hour blocks in the person’s calendar without meetings during the workday. Count
OpenTwoHourBlocks Open tow-hour blocks Number of two-hour blocks in the person’s calendar without meetings during the workday. Count
Organization Required HR attribute The internal organization that the employee belongs to. An employee’s organization will be specific to your individual needs and could be identified by the leader of the organization, or by another naming convention. String
OrganizerGeneratedMailLoadHours Generated workload email hours Number of email hours the person created for internal recipients by sending emails. Hour
OrganizerGeneratedMeetingLoadCount Generated workload meetings organized Number of internal meetings organized by the person. Count
OrganizerGeneratedMeetingLoadHours Generated workload meeting hours Number of meeting hours the person created for internal attendees by organizing meetings. Hour
Person_DirectReports Required HR attribute Number of direct reports, which is a non-zero value for managers. String
Person_IsManager Required HR attribute True indicates that the person is a manager. String
Person_RoleType Required HR attribute Indicates one of three possible values, which are IC, Manager, or Manager+. String
PersonId PersonId De-identified ID number for the person represented in the metric. You can only calculate aggregations, such as counts, of this field. Attempting to return a list of all PersonIds will result in an error. String
PopulationType Required HR attribute Currently all the person metric data that’s imported is for measured employees only. String
RecurringMeetingHours Not applicable Number of hours the person spent in recurring meetings with at least one other person. Hour
RedundantMeetingHours Redundant meeting hours (organizational) Number of meeting hours a person spent with attendees from three or more distinct levels within that person’s organization. Used in calculating Low quality meeting hours. Hour
SkipLevelMeetingHours Meetings hours with skip level Number of meeting hours that the person attends where their manager's manager also attends the meeting. Hour
TimeZone Required HR attribute Time zone in which the employee performs work. String
TotalFocusHours Total focus hours Total number of hours with two or more one-hour blocks of time where the person had no meetings. Hour
Utilization Workweek span The time between the person's first sent email, meeting attended, or Teams call or chat, and the last email, meeting, call, or chat for each day of the work week. The total number of hours are based on the person’s work week that is set in Outlook, which the user can change at any time. If a work week is not defined in Outlook (or if Viva Insights is unable to access a user's Outlook settings), the totals are based on the default of Monday through Friday, with a minimum of four hours and a maximum of 16 hours each day. If reported for the week, the metric is a sum of the daily values for the week. Hour
WorkingHoursCollaboration Working hours collaboration hours Number of hours the person spent in meetings and sending emails during working hours. Hour
WorkingHoursCollaborationCalls Working hours in calls Total number of hours a person spent time in scheduled and unscheduled calls with Teams, during working hours. Hour
WorkingHoursCollaborationEmails Working hours email hours Number of hours the person spent sending email during working hours. Hour
WorkingHoursCollaborationInstantMessages Working hours instant messages Total number of hours a person spent time in instant messages through Teams, during working hours. Hour
WorkingHoursCollaborationMeetings Meeting hours during working hours Number of hours the person spent in meetings, during working hours, with at least one other person. Hour