了解并解释查询输出Understand and interpret query output

在工作区分析中运行查询后,查询中的结果页面将在列表中显示为 .csv (逗号分隔值) 包含查询输出的文件。After you run a query in Workplace Analytics, the Results page in Queries will appear in the list with a download link as .csv (comma-separated values) file with the query output.

.csv 文件下载

您还可以选择 " 复制链接 " 按钮获取 OData 源的链接,以将查询结果直接加载到 Power BI 或其他数据分析工具(如 Excel)。You can also select the Copy link button to get a link for an OData feed to directly load query results into Power BI or another data analysis tool, such as Excel. 有关更多详细信息,请参阅 使用 POWER BI 和其他数据分析工具中的工作区分析数据For more details, see Use Workplace Analytics data in Power BI and other data analysis tools.

人员查询输出Person query output

人员查询输出可以包含多种不同的指标,其中包括以下几种:Person query output can include a number of different metrics, including the following:

  • 人员 ID-在该数据行中表示的人员的已取消标识的 ID 号。Person ID - De-identified ID number for the person represented in that data row.
  • Date-聚合输出 (的开始日期例如,对于6月3日到6月10日的一周,开始日期是第三个。Date - The start date of the aggregated output (for example, for the week of June 3rd to June 10th, the start date would be the 3rd. 对于某个月,将是数据所涵盖月份的第一天)。For a month, it'll be the first day of the month your data encompasses).
  • Person 属性-有关通过最新的组织 (HR) 数据上传的人员提供的属性。Person attributes - Attributes about the person supplied through the latest organizational (HR) data upload.
  • 指标-查询中包括的任何其他指标。Metrics - Any other metrics that you include in the query. 有关详细信息,请参阅 人员查询指标See Person query metrics for more details.

为日历中的预定时间调整的持续时间小时数Duration hours adjusted for time booked in the calendar

如果在工作计划的过程中以及在工作计划之外添加个人的电子邮件和会议时间,则不要预计这些总和等于工作小时数总和和工作时间。If you add up a person's email and meeting hours during and outside of their work schedule, do not expect these sums to equal the sums for working hours and after hours. 工作区分析以不同的方式计算这些指标组。Workplace Analytics calculates these groups of metrics differently.

对于工作时间和时间总计,工作区分析使用 "在人员日历上预订的时间",而不是 "在会议中的时间"。For working hours and after-hours totals, Workplace Analytics uses "time booked on a person's calendar" instead of “time in meetings.” 在会议中 (时间的会议总小时数的计算) 调整双倍记帐会议的持续时间,在这种会议中,某人同时安排了两个会议,或者在日历上发生重叠的时间。Calculations for total meeting hours (time in meetings) adjusts the duration time to account for double-booked meetings, where a person has two meetings scheduled at the same time or for times that overlap on the calendar.

工作区分析使用启发式逻辑对某人可能参加的会议进行排序,并相应地分配时间。Workplace Analytics uses a heuristic logic to order which meetings a person likely attended and assigns time accordingly. 此逻辑不会指定开始日期和结束日期的 "分块" 时间,而是将时间指定为单个数字。This logic doesn't specify a “chunk” of time with start and end dates, but assigns time as a single number. 这可能会导致会议小时数和工作时间变长,尤其是在人的日程安排中,在工作时间和工作时间范围内的双重预定会议和会议。This can cause a variation in meeting hours and after hours, in particular for double booked meetings and meetings that span between working hours and after hours on a person's schedule.

例如,如果某人的某一天结束于下午5点,并且该人从4:30 到 5:30 PM 参加了计划的会议,该会议的持续时间为与另一个会议的双重小时数 (持续时间为0.5 小时) 计算使用 "日历中的预定时间",这会将0.5 小时添加到工作时间、0.5 小时的工作时间,并将0.5 小时添加到总会议时间中,这会导致在比较总计时产生差异。For example, if a person's work day ends at 5 PM and that person attends a scheduled meeting from 4:30 to 5:30 PM that is double booked with another meeting by a half hour (duration hours adjusted = 0.5hr), the calculation uses “time booked in the calendar,” which adds 0.5 hour to working hours, 0.5 hour as after-hours work, and adds 0.5 hour to total meeting hours, which would cause a discrepancy when comparing the totals.

用户到组的查询输出Person-to-group query output

您可以使用人员对组查询来帮助您了解如何将已确定的个人投资于内部或外部协作的时间。You can use person-to-group queries to help you understand how de-identified individuals invest their time for either internal or external collaboration.

查询输出列出了这些未确定的 时间投资者 (许可员工) 者:The query output lists these de-identified Time investors (licensed employees) by:

a) 其 PersonIdsa) Their PersonIds

b) 在 " 协作 者" 部分中定义的一个或多个组b) One or more groups as defined in the Collaborators section

c) 投资者在指定组中花费的时间量c) The amount of time the time investor spends with the specified groups

在查询的 "人员" 端,PersonIds 将映射到组一侧的 "合作者" 组。On the "person" side of the query, PersonIds map to groups of "collaborators" on the group side. 对于组到组的查询,"时间投资者" 组将映射到 "协作者" 组。For group-to-group queries, the "time investor" groups map to the groups of "collaborators."

在用户组查询中,查询输出包括列标题,在与协作者组中的人员合作的时间段的时间段内,时间投资者组中的人员的每个唯一配对的列标题都包含单行。In person-to-group queries, the query output includes column headers with single rows for each unique pairing of a person in the time investor group with any collaborator in the collaborator group during the time periods that the person collaborated with that group.

例如,PersonId 的 P1 合作与组 G1 在指定月份的第一周和第三周。For example, PersonId of P1 collaborated with group G1 in weeks one and three of the specified month. 对于按 " 时间 " 一节中的 "周" 分组的人员到组查询 (您希望如何对与 "投资 人" 的人员进行合作的人员进行分组) 。For a person-to-group query that's grouped by "week" in the Time investors section (How do you want to group the people who collaborated with the time investors?). 然后,将在周1和3中为 (P1、G1) 创建行。Then rows will be created for (P1, G1) in weeks one and three only.

包含时间投资者的列的表

Note

为人员分配随机生成的 PersonIds 以维护取消标识。People are assigned randomly-generated PersonIds to maintain de-identification. 无法在查询输出中标识任何人。No individuals can be identified from the query output.

人员对组查询的查询输出由常规标题列 (类别) 和指标标题列组成。The query output for person-to-group queries consists of general header columns (categories) and metrics header columns. 输出还显示根据组织不同而变化的其他组织属性列。The output also displays additional organizational attribute columns that vary based on the organization.

特性列Attribute columns

下表列出了在输出文件中找到的 "用户到组" 标头列。The following table lists the person-to-group header columns found in the output file.

标头列Header column 说明Description
PersonIdPersonId 为每个时间投资者随机生成的 PersonId 值。A randomly-generated PersonId value for each time investor. 当公司管理员最初上载员工组织信息时,将在行中使用员工姓名,但这些名称会在工作区分析处理输出时被取消标识。When the company administrator initially uploads employee organization information, employee names are used in rows, but these names become de-identified when Workplace Analytics processes the output.
IsInternalIsInternal 对于所有内部公司员工,此值为 true,对于公司外部的所有人员,此值将等于 false。This value is true for all internal company employees and equates to false for all people external to the company.
FunctionType*FunctionType* 表示员工在公司内执行的功能,例如,"制造"、"HR" 或 "财务"。Represents the function that employees perform within the company, for example, Manufacturing, HR, or Finance.
组织*Organization* 表示某人所属的组织的名称。Represents the name of the organization to which a person belongs. 有关与其他变量组织相关的列的信息,请参阅 组织关系属性列For information on other variable organization-related columns, see Organizational attribute columns.
合作者 (协作者组-按属性) Collaborators (collaborator group-by attribute) 代表按组的各种协作者。Represents the various collaborators by group. 例如,如果选择 "域" 作为 Group by 属性,则这些值将是投资者共同协作的所有电子邮件域。For example, if you select "Domain" as the Group by attribute, the values will be all the email domains with which time investors have collaborated. 此标头列的名称将根据为查询的 "协作者" 部分选择的 " 分组依据 " 属性而变化。The name of this header column changes depending on the Group by attribute selected for the collaborators part of the query. 因此,如果按域对协作者进行分组,则会将列名称作为 Collaborators_Domain 进行连接。So if you group collaborators by domain, the column name will be concatenated as Collaborators_Domain. 如果您选择了 "FunctionType Group by" 属性,则这些值将是投资人合作的各种公司组织,如销售、人力资源或财务。If you selected the FunctionType Group by attribute, the values will be all the various company organizations with which the time investors have collaborated, such as Sales, HR, or Finance. 同样,列名称将作为 Collaborators_FunctionType 进行连接。Similarly, the column name will be concatenated as Collaborators_FunctionType.
DateDate 是一周的第一天 (星期日的第一天) 或一个月的第一天,具体取决于最初选择的 "分组依据" 属性的日期选项。Is either the first day of the week (Sunday) or first day of the month, depending on which date option you originally selected as the group by attribute.

* "组织" 和 "FunctionType" 列类似于,它们都反映了组织内的员工的职能。* The Organization and FunctionType columns are similar in that they both reflect the function of employees within an organization. 但是,每个值可能会有所不同,如以下示例所示:However, the values of each might differ, as in the following examples:

组织Organization FunctionTypeFunctionType
营销Marketing 品牌打造Branding
OperationsOperations 供应链Supply Chain
OperationsOperations 制造业Manufacturing

组织属性列Organizational attribute columns

除了在 "人员到人员" 查询的 .csv 文件输出中存在的标准列之外,输出通常包含一组表示员工的组织属性的标头列的变量集。In addition to the standard columns present in the .csv file output of person-to-person queries, the output typically contains a variable set of header columns that represent the organizational attributes of employees. 管理员在最初设置工作区分析时上载这些属性。Admins upload these attributes when Workplace Analytics is initially set up. 这些列列在查询输出中包含的每个人员的 "组织" 列的右侧。These columns are listed to the right of the Organization column for every person included in the query output. 各列的名称将因公司而异;但是,示例组织属性可能包含诸如 "开始日期"、"tenuremonths" 或 "quotaattainment" 等项目。The names of the columns will vary from company to company; however, sample organizational attributes might include items such as, StartDate, tenuremonths, or quotaattainment.

指标列Metric columns

"人员到组" 查询和 "组到组" 查询的 .csv 输出文件将包含一个或多个标头列,这些列基于创建查询时选择的标准或自定义的指标。The .csv output file for both person-to-group queries and group-to-group queries will include one or more header columns based on the standard or customized metrics selected when creating the query.

组到组查询的列的表

有关人员对组指标的详细信息,请参阅 Workplace Analytics 指标For details about person-to-group metrics, see Workplace Analytics metrics.

IsActive 属性The IsActive attribute

对于 " 员工时间 " 部分中的 "员工" 筛选器,您可以选择是仅活动、非活动还是所有员工作为查询的时间投资者。For the Employees filter in the Time investors section, you can select if you want Active only, Inactive only, or All employees as time investors for the query. "活动员工" 是指在查询的 (日期范围) 设置的总时间段内发送至少一封电子邮件或即时消息的人员。Active employees are those who sent at least one email or instant message during the aggregated time period (date range) set for the query. 此选项仅适用于个人和人员对组查询,该查询将成为 IsActive 属性列,其布尔值为 true 或 false,表示输出文件中的每一行。This option is only available for person and person-to-group queries, which will be the IsActive attribute column with a Boolean value of true or false for each row in the output file.

组查询的其他属性Additional attributes for group queries

除了标准属性值之外, 合作者 组还可以在查询输出中包括用于 "人员对组" 和 "组到组" 查询的以下属性值:In addition to the standard attribute values, the Collaborators group can also include the following attribute values in the query output for both person-to-group and group-to-group queries:

将 C 分组到组 TGroup C to Group T

其中, 组 C 代表协作者组, 组 T 代表时间-投资者组,汇总包括公司中所有其他组的时间内的投资组生成的时间。Where Group C represents a collaborator group and Group T represents the time-investor group, totals include time generated by the time-investor group for all other groups in the company. 这些总和不包括在会议中花费的时间与投资组的时间。These totals do not include the time-investor group's time spent in the meetings.

Group T 到 Group TGroup T to Group T

此指标包含在组到组查询的查询输出中,其中 组 T 表示时间-投资者组。This metric is included in the query output for group-to-group queries, where Group T represents the time-investor group. 根据查询中的属性,此组的指标计算会有所不同:The metric calculations vary for this group depending on the attribute in the query:

  • 对于 时间投资者启动的会议时间 ,总计包括在会议中按组 t 为其他组 t 许可证(内部员工)生成的时间。For Time investor initiated meeting hours - The totals include time generated in meetings by Group T for other Group T licensed, internal employees. 这些总和不包括组织者的时间,也不遵循时间分配逻辑。These totals don't include the organizers' time and don't follow time-allocation logic.

  • 对于 所有其他组指标(如会议时间或协作时间),总计包括组 t 的无 许可 员工在会议中显示的组 t 生成的时间。For all other group metrics, such as meeting hours or collaboration hours - The totals include time generated by Group T in meetings where unlicensed employees from Group T are present. 未经授权的员工可能是在组中不再工作的供应商或员工 (因此,未经授权) 但包含在组中,因为它们与组织 (HR) 数据中的 group by 属性相匹配。Unlicensed employees might be vendors or employees who no longer work in the group (hence unlicensed) but are included in the group because they match the group-by attribute in the organizational (HR) data.

组内的协作者Collaborators within group

此属性在组到组查询的查询输出中也可用。This attribute is also available in the query output for group-to-group queries. 根据查询中的属性,此组的指标计算会有所不同:Metric calculations vary for this group depending on the attribute in the query:

  • 对于 时间投资者启动的会议时间 而言,总计包括由通过时间-投资者组组织的会议生成的时间,由其他内部组的其他授权员工参加。For Time investor initiated meeting hours - The totals include time generated in meetings organized by the time-investors group that are attended by other licensed employees from other internal groups. 这些总和不包括在会议中花费的时间-投资者组。These totals don't include the time-investor group's time spent in the meetings.

  • 对于 所有其他组指标(如会议时间或协作时间),生成 许可 员工的时间投资者是不存在任何其他组的唯一参与者的总计。For all other group metrics, such as meeting hours or collaboration hours - The totals generated where the time investors who are licensed employees are the only attendees with no other groups present. 这些总和包括会议组织者在会议中花费的时间。These totals include the meeting organizer's time spent in the meetings.

内部协作者Internal collaborators

此属性仅适用于 时间投资者启动的会议时间 指标。This attribute is only available for the Time investor initiated meeting hours metric. 如果未设置 焦点 筛选器,则此组包括没有组织数据值或具有不同的 group by 属性值的已授权的内部员工。If no Focus filter is set, this group includes licensed, internal employees who have no organizational data value or have a different value for the Group by attribute. 这是由使用此组组织会议的时间投资者创建的会议总小时数。This is the total number of meeting hours created by the time investors who organized meetings with this group.

其他协作者Other collaborators

如果查询使用 Group by 属性,则与在图形问题 C 中定义的筛选器选项匹配的协作者和未定义 Group by 属性的协作者将被分组在一起,作为 其他协作者。If a query uses the Group by attribute, both the collaborators who match the filter option defined in question C of the graphic and who do not have the group-by attribute defined, are grouped together as Other collaborators. 此指标不适用于 时间投资者启动的会议时间This metric is not applicable for Time investor initiated meeting hours.

例如,如果您运行查询来找出与某个人合作的组织,并通过筛选器 FunctionType = HR 传递这些组织。For example, if you run a query to find out which organizations a person collaborated with, and passed them through the filter FunctionType = HR. 与筛选器匹配的那些组包含在组中。Those who match the filter are included in the group. 然后,如果按城市(如旧金山和波士顿)对协作者进行分组,则查询将对在旧金山组中与 HR 进行交互的所有协作者进行分组,与波士顿类似。Then, if you group the collaborators by city, such as San Francisco and Boston, the query will then group all collaborators who had interactions with HR in San Francisco in the San Francisco group, and similarly for Boston. 查询输出将包含每个人 (或组的组到组查询的条目) ,显示每个城市中的 HR 与 HR 进行协作所花的时间。The query output will include entries for each person (or group for a group-to-group query) that show how much time each person spent collaborating with HR in each city.

在某些情况下,有些人可能没有定义的组织属性(如 city),因为它们是移动的,在公司拥有办事处的城市中不起作用。In some instances, some people might not have the organizational attribute defined, such as city, because they are mobile and don't work in a city where the company has offices. 这些员工将被归为 其他协作者。These employees will be grouped as Other collaborators.

未分类内部Unclassified Internal

在 " 协作 者" 部分中,如果合作者不符合下图的问题 C 中定义的筛选器以及 ( 公司内部的("IsInternal = true ) "),则将在 " Unclassified_Internal " 类别中将它们组合在一起。In the Their collaborators section, the collaborators who don't match the filter defined in question C of the following graphic and who are also internal to the company ("IsInternal = true") will be grouped together in the Unclassified_Internal category. 为此类别添加了所有此类协作者的指标。Metrics for all such collaborators are added up for this category.

例如,如果对与 "FunctionType = HR" 匹配的所有协作者运行查询,则不符合该筛选条件的人员(如来自销售或市场营销的内部员工)将包含在 " Unclassified_Internal " 类别中。For example, if you run a query for all collaborators who match "FunctionType = HR," those who don't match that filter, such as internal employees from Sales or Marketing, will be included in the Unclassified_Internal category.

未分类外部Unclassified External

与下图的问题 C 中定义的筛选器选项匹配的协作者和公司外部的成员 ( "IsInternal = false" ) 将在 Unclassified_External中组合在一起。The collaborators who match the filter option defined in question C of the following graphic and who are external to the company ("IsInternal = false") will be grouped together in Unclassified_External. 为此类别添加了所有此类协作者的指标。Metrics for all such collaborators are added up for this category. 此指标不适用于 时间投资者启动的会议时间This metric is not applicable for Time investor initiated meeting hours.

查询问题

组到组查询输出Group-to-group query output

您可以使用组到组查询来帮助了解组或团队如何在公司的内部组织中以及公司外部的组来投资他们的时间。You can use group-to-group queries to help understand how groups or teams invest their time across internal organizations in the company and with groups outside the company. 输出将列出由所选的组织属性定义的组对,并显示第一个组分配给第二个组的时间。The output will list pairs of groups, defined by the selected organizational attribute, and will show how much time the first group has allocated to the second group.

组到组查询的查询输出包含多个列标题,其中包含一个具有协作者组的时间投资者组的每个唯一配对的列标题,在时间投资者组中的任何人花费在协作者组中的时间段内。The query output for a group-to-group query includes a number of column headers with a single row for each unique pairing of a time investor group with a collaborator group, for the time periods that any person in the time investor group spent with a collaborator group. 例如,如果运行包含 " 分组依据 " 选项的查询,并且 group G1 中的某个人员在特定月份的第一和第三个星期内使用组 G2 中的某个人花费 时间,则 在输出文件的第一周和第三周中,行将仅存在于组 G1 和 G2 中。For example, if you run a query with the Group by option of week and a person in group G1 spent time with a person in group G2 in the first and third week of a specific month, then rows will only exist for groups G1 and G2 in weeks one and three of the output file.

组到组时间投资者-协作者

组到组查询的查询输出,如人员到组查询,还包括以下常规属性和指标列标题。The query output for group-to-group queries, like person-to-group queries, also includes the following general attribute and metric column headings.

常规属性列General attribute columns

常规属性列General attribute column 说明Description
TimeInvestors (时间-按属性) 的投资组TimeInvestors (time-investor group-by attribute) 此名称取决于在查询的时间内选择的 " 分组依据 " 属性。The name of this depends on the Group by attribute selected in the time investors part of the query. 例如,在上表中,协作者按 FunctionType 进行分组,因此列名称将作为 TimeInvestors_FunctionType 进行连接。For example, in the previous table, collaborators are grouped by FunctionType, so the column name is concatenated as TimeInvestors_FunctionType.
合作者 (协作者组-按属性) Collaborators (collaborator group-by attribute) 此名称取决于在查询的 "协作者" 部分中选择的 " 分组依据 " 属性。The name of this depends on the Group by attribute selected in the collaborators part of the query. 在上表中,协作者按域进行分组,因此列名称将作为 Collaborators_domain 进行连接。In the previous table, collaborators are grouped by domain, so the column name is concatenated as Collaborators_domain.
DateDate 是一周的第一天 (星期日) 或一个月的第一天,具体取决于最初选择的 " 按 Group by " 属性的日期选项。Is either the first day of the week (Sunday) or the first day of the month, depending on the date option you originally selected as the Group by attribute.

指标列Metric columns

指标列Metric column 说明Description
电子邮件小时数Email hours 在时间投资者和协作者组之间发送和阅读电子邮件所用的小时数。The number of hours spent sending and reading emails between the time investor and collaborator groups.
会议小时数Meeting hours 时间投资者组花费了与协作者组的会议的会议小时数。The number of meeting hours the time investor group has spent meeting with the collaborator group.
会议Meetings 至少有一个与会者来自 "时间投资者" 和 "协作者" 组的不同会议数。The number of distinct meetings with at least one attendee from the time investor and collaborator groups.
会议与会者计数Meeting attendee count 来自 "时间投资者" 和 "协作者" 组的所有会议的与会者总数The total number of attendees in all meetings from the time investor and collaborator groups
会议邀请计数Meetings invitee count 来自时间投资者和协作者的所有会议中的被邀请者总数。The total number of invitees in all meetings from the time investor and collaborator.
协作时间Collaboration hours 在时间投资者和协作者组之间花费的会议小时数和电子邮件时间总和。The sum of meeting hours and email hours spent between the time investor and collaborator groups.

有关组查询指标的完整列表及更多详细信息,请参阅 Workplace Analytics 指标For a complete list of and more details about group query metrics, see Workplace Analytics metrics.