Metric filters

To customize the results from Workplace Analytics queries, you use metrics (see metric definitions).

After you select a metric for a query, you can narrow the focus of that metric by applying filters. You can also rename the metric to indicate the new focus that you gave when you applied filters; its new name will appear in the query results. See Apply a metric filter.

Call filters

Filter Description
Day of week The day of the week during which the call was placed
Duration (in hours) The amount of time, in hours, that the call lasted
Included multitasking Filters the call counts to only count activity during which the person sent one or more emails or instant messages, excluding instant messages sent within the related Teams meeting chat room during the meeting or call.
Is organizer True means that this person initiated the call;
False means that this person did not initiate the call.
IsScheduledCall True means that this call is scheduled on someone's Outlook calendar;
False means that this call is not scheduled on any person's Outlook calendar.
Time of day started                           The time of day that the call began
TotalParticipants The number of participants in the call

Email filters

Filter Description
Day of week Day of the week on which the email was sent
IsSender True means that this person sent the email;
False means that this person did not send the email.
Is sent during meeting Counts emails that a person sends during a meeting
Is sent during unscheduled call Counts emails sent during an unscheduled Teams call.
Time of day Time of day on which the email was sent
Number of recipients Number of the recipients on which the email was sent
Subject The Subject line of the email

Instant messages (IM) filters

Filter Description
Day of week The day of the week on which the IM was sent.
InteractionType The type of chat in which the IM appears, namely in a one-on-one chat or in a group chat.
IsAfterHours True means that the IM was sent during the recipient's after-hours period;
False means that it was not sent during that period.
IsSender True means that this person sent the IM;
False means that this person did not send the IM.
Is sent during meeting Counts Teams IMs that a person sends during a meeting.
Is sent during unscheduled call Counts Teams IMs sent during an unscheduled Teams call.
Time of day                 Time at which the IM was sent.
TotalParticipants Number of people who participated in the IM thread, including the sender of the initial IM.

Meeting filters

Filter Description
Duration (in hours)                                                                                                                                                     Duration of the meeting.
Included multitasking Filters the count of meetings to only count activity during which the person sent one or more emails or instant messages, excluding instant messages sent within the related Teams meeting chat room during the meeting or call.
Is recurring True means that this meeting is set to recur;
False means that this meeting is not set to recur.
IsCancelled True means that this meeting has been cancelled;
False means that this meeting has not been canceled.
Subject Subject line of the meeting invitation.
Total accepted Number of invitees who have accepted the meeting invitation.
Total attendees Total attendees can be configured at the report level by using an attendee-exclusion rule. When you select an attendee-exclusion rule, you redefine meeting attendance to include or exclude the cases of “tentative” and “no response.” Therefore, based on the attendee-exclusion rule that you have selected, Total attendees can mean one of the following:
  • Total attendees = Total accepted
  • Total attendees = Total accepted + Total no response
  • Total attendees = Total accepted + Total tentatively accepted
  • Total attendees = Total accepted + Total no response + Total tentatively accepted
Total declined Number of invitees who have declined the meeting invitation.
Total double booked Number of invitees who have accepted this meeting invitation and the invitation of another meeting that is scheduled to overlap with this one.
Total emails sent during meeting Number of emails sent by all participants during the meeting.
Total no responses Number of invitees who did not respond to the meeting invitation.
Day of week Day of the week for which the meeting is scheduled.
Is organizer The person who invited others to the meeting.
Time of day started Time of day that the meeting was scheduled (in Outlook) to start.

Participant filters

Filters of the following types can be used in various query types to filter participants in collaboration activities – that is, in emails, IMs, calls, or meetings.

Individual participant filters

Filter                                          Description
Is Manager Present A Boolean that indicates that the participant is the direct manager of the measured user.
Is Direct Report Present Indicates that the participant is the direct report of the measured user.

Groups of participant filters

Organizational-data attributes and CRM attributes can also be used as participant filters.

Filter Description
Organizational attributes (required) Organizational attributes that are required are always available for use as participant filters.
Organizational attributes (optional) Also available for use as participant filters are optional organizational attributes (reserved optional attributes and custom attributes) that have been uploaded in an organizational data upload.
CRM attributes (required) CRM attributes that are required are available for use as participant filters in query types that permit both organizational and CRM data analysis (person, person-to-group, and group-to-group queries).
CRM attributes (optional) Optional CRM attributes (reserved optional attributes and custom attributes) are available for use as participant filters in query types that permit both organizational and CRM data analysis (person, person-to-group, and group-to-group queries).

Teams channel metric filters

Filters for channel messages

These filters can be used to customize the following Teams channel metrics:

  • Channel message hours
  • After hours channel message hours
  • Working hours channel message hours
  • Channel messages sent
  • Channel visits
  • Channel reactions
Filter Description
Channel member count If the selected Channel member count > "X", return a metric for posts or replies that were sent or read on channels with a number of channel members > "X".
Channel name If the selected Channel name = "X", return a metric for posts or replies that were sent or read on channel "X".
Day of week If the selected Day of week = "Monday" (or any other day), returns a metric for posts or replies that were sent or read on Monday using the time zone of the person.
Device If the selected Device = Mobile/ Desktop/Web, return metric for posts/replies made from Mobile/ Desktop/Web.
Interaction type
  • If Interaction type = “Post sent”, returns metric for only sent post messages.
  • If Interaction type = "Reply sent", returns metric for only sent reply messages.
  • If Interaction type = “Channel visit”, returns metric for only Channel Visits.
Team name If the selected Team name = "X", return metric for posts/replies that are sent/read on Team "X".
Time of day The time of day the activity occurred using the time zone of the person.
Total participants If the selected Participant count > "X", return metric with total number participants >"X".

Filters for channel activity

These filters can be used to customize the following Teams channel metrics:

  • Teams with active engagement
  • Channels with active engagement
Filter Description
Channel member count If the selected Channel member count > "X", return an active Teams or channel metric for channels with the number of channel members > "X".
Channel name If the selected Channel name = "X", return an active Teams or channel metric with the channel name "X".
Interaction type
  • If the Interaction type = “Post sent”, return a metric only for active Teams or channels in which person sent post messages.
  • If the Interaction type = “Reply sent”, returns a metric only for active Teams or channels in which reply messages were sent.
  • If the Interaction type = "Channel visit", returns a metric only for active Teams or channels in which the person had Channel visits.
  • If the Interaction type = “Reaction”, returns a metric only for active Teams or channels in which the person sent reactions.
Team name If the selected team name = "X", return an active Teams or channel metric with the Team name "X".

Apply a metric filter

In this example procedure, you apply a filter to a metric in a person query. Specifically, you restrict the Email sent metric to include only email that was sent during a particular time of day. Then, for the population of employees that you specify, the query results will show the number of emails that were sent during the time of day that you selected.

  1. In Workplace Analytics, select Analyze > Queries > Person.

  2. Under Select metrics, select Emails sent:

    Select emails sent.

  3. Select edit (the pencil icon):

    Select pencil to edit.

  4. Under Emails sent where, select Add filter and then select Email:

    Select email.

  5. Next to Email's, select Time of day:

    Select time of day.

  6. In the adjacent fields, select "<" (before) and specify 7:00 PM.

    Sent before 7:00 PM.

  7. You have now filtered your base metric. You can optionally change the display name of this new filtered metric. In the field under Display Name, change Emails sent to Emails sent before 7 PM and then click outside the field to save the new name:

    Edit the metric name.

    After you run the query, the edited metric name will appear as a header in the query results:

    Edited metric name.