有关工作区分析的常见问题Frequently Asked Questions for Workplace Analytics

有关工作区分析的最常见的常见问题和解答分为以下几部分:The most commonly asked questions and answers about Workplace Analytics are grouped into the following sections:

产品信息Product information

工作区分析安装程序Workplace Analytics setup

使用工作区分析Use Workplace Analytics

产品信息Product information

产品角色Product roles

问题 1.Q1. 工作区分析是否认为是用于人力资源规划的工具?Is Workplace Analytics considered a tool for human-resource planning?

A1.A1. 否。No. 工作区分析是一种协作分析工具,可用于分析行为和网络模式。Workplace Analytics is a collaboration analysis tool that can be used to analyze behavior and network patterns.

问题 2.Q2. MyAnalytics 和 Workplace Analytics 有何不同?How do MyAnalytics and Workplace Analytics differ?

A2.A2. MyAnalytics 在单个用户的邮箱中运行,并且只能由该用户看到。MyAnalytics runs within an individual user's mailbox and can be seen only by that user. 工作区分析是组织用于运行自上而下分析的工具,它只会计算汇总和匿名指标。Workplace Analytics is a tool that is used by organizations for running top-down analysis and it computes only aggregated and anonymized metrics.

隐私与合规性Privacy and compliance

问题 1.Q1. 工作区分析收集了多少数据?How much data does Workplace Analytics collect?

A1.A1. 工作区分析最初收集并处理13个月的数据。Workplace Analytics initially collects and processes 13 months' worth of data. 通过每周刷新,工作区分析将继续增加此历史记录,直到收集27个月的数据。Through weekly refreshes, Workplace Analytics continues to increase this history until 27 months’ worth of data is collected. 由于安全原因,客户可以为请求提供文件,以提供低于此默认值的工作区分析;在这种情况下,可收集的最小金额为一个月。Customers can file a request, for security reasons, to provide Workplace Analytics with less than this default amount; in that case, the minimum amount that can be collected is one month.

问题 2.Q2. 工作区分析是否支持一个单独的数据环境,以遵守合规性和法规要求,如政府所需的要求。Does Workplace Analytics support a separate data environment that adheres to compliance and regulatory requirements such as those required by the government?

A2.A2. 工作区分析在 Microsoft 为政府机构维护的数据云环境中不可用。Workplace Analytics is not available in data cloud environments that Microsoft maintains for government agencies.

语言支持Language support

问题 1.Q1. 是否可以上载包含非英语单词或字母的组织数据文件?Can I upload an organizational data file that has non-English words or letters?

A1.A1. 是。Yes. 组织数据文件可以包含非英文单词或字母。The organizational data file can have non-English words or letters. 请注意以下事项:Note the following:

  • 文件名和单个行可以包含非英文单词或字母。File names and individual rows can have non-English words or letters.
  • 必须将每个列标题映射到具有英语名称的属性。Each column header must be mapped to an attribute with an English name.
问题 2.Q2. 我能否使用包含非英语单词或字母的筛选器和/或会议主题行构造查询?Can I construct a query with filters and/or meeting subject lines that contain non-English words or letters?

A2.A2. 是。Yes. 您可以在查询中使用筛选器,其中包括以下内容:You can use filters in queries that include the following:

  • 包含非英语单词或字符的组织数据中的属性或值。Attributes or values from your organizational data that include non-English words or characters.
  • 会议主题行 (其中可包含非英文单词或字符) 特定筛选条件。Meeting subject lines (which can include non-English words or characters) as specific filter criteria.

有关详细信息,请参阅在查询中自定义基础指标For more information, see Customize a base metric in a query.

工作区分析安装程序Workplace Analytics setup

安装和配置Setup and configuration

问题 1.Q1. 启用工作区分析的基本步骤是什么?What are the basic steps to enable Workplace Analytics?

A1.A1. 以下是为组织启用工作区分析所需的主要任务:These are main tasks required to enable Workplace Analytics for your organization:

  • 分配许可证Assign licenses
  • 分配角色Assign roles
  • 配置设置Configure settings
  • 上传组织数据Upload organizational data

有关安装程序的完整信息,请参阅设置工作区分析For complete information about setup, see Set up Workplace Analytics.

问题 2.Q2. 如果我的许可填充在不同时区中运行或具有不同的工作时间,它是否会出现问题?Does it present a problem if my licensed population works in different time zones or has varying working hours?

A2.A2. 否。No. 工作区分析可以确定每个员工的时区值及其工作时间,而无需考虑它们的位置。Workplace Analytics can determine each employee's time-zone value and their working hours, regardless of their location. 若要做出此决定,工作区分析将执行默认时区中所述的步骤。To make this determination, Workplace Analytics carries out the steps that are described in Default time zone.

问题 3.Q3. 能否配置特定分析师可以访问和使用的用户数据?Can I configure the user data that particular analysts can access and use?

旁.A3. 您可以向分析师分配分析者 (受限访问) 角色,将其限制为浏览器仪表板。You can assign analysts the analyst (limited access) role, which limits them to the Explore dashboards. 有关更多详细信息,请参阅在工作区分析中分配工作区分析角色和用户角色。See Assign Workplace Analytics roles and User roles in Workplace Analytics for more details.

问题 4.Q4. 在配置工作区分析时,为什么是开始时间和结束时间如此重要?Why are Start time and End time so important when configuring Workplace Analytics?

A4.A4. "开始时间" 和 "结束时间" 值确定将对数据进行分析的工作时间。The Start time and End time values determine the working hours for which data will be analyzed. 它们还确定在几小时之后考虑的时间段。They also determine the time period that is considered after hours. 请参阅工作日和工作时间See Working days and hours.

问题 5.Q5. 是否有可分配的工作区分析分析员角色的最大数量?Is there a maximum number of Workplace Analytics analyst roles that can be assigned?

A5.A5. 否。No. 工作区分析未施加限制。No limit is imposed by Workplace Analytics.

问题 6.Q6. 在 "工作区分析_数据源_" 部分中的 "Office 365 数据" 页上,您可以看到 "度量员工数"。In the Workplace Analytics Data sources section, on the "Office 365 data" page, you can see the number of "Measured employees." 是许可的用户数还是许可和未授权的号码?Is this the number of licensed users or the number of both licensed and un-licensed?

A6.A6. 许可.Licensed. 具体来说,此数字指的是已授权的员工,它们也存在于协作 (Office 365) 数据中。Specifically, this number refers to licensed employees who are also present in the collaboration (Office 365) data. 有关详细信息,请参阅数据计数的来源For more information, see Origin of data counts.

问题 7.Q7. 未分配 Workplace Analytics 许可证的用户会发生什么情况?What happens with users who were not assigned a Workplace Analytics license? 它们是否被忽略?Are they ignored?

A7.A7. 不,它们不会被忽略。No, they are not ignored. 组织中未经授权进行分析的员工,但可以通过会议、电子邮件、未计划的呼叫或即时消息与您测量的员工进行协作 (内部协作者) 。Employees in your organization who are not licensed for analysis but might collaborate with your measured employees (internal collaborators) through meetings, email, unscheduled calls, or instant messages. 不会对这些员工进行度量,也不会处理其数据。These employees are not measured and their data is not processed. 有关详细信息,请参阅数据计数的来源For more information, see Origin of data counts.

组织数据Organizational data

问题 1.Q1. 将组织数据文件上传到工作区分析或此类文件的 invalidity 时,出现故障的常见原因是什么?What are common causes of a failure to upload an organizational data file into Workplace Analytics, or the invalidity of such a file?

A1.A1. 如果数据具有无效的值、缺少所需的数据,或者 unrequired 数据的有效性阈值设置得太高,则上载可能失败。这是在组织第一次上载后,上载中的自定义字段的情况。An upload can fail if the data has invalid values, if it is missing required data, or if the validity threshold for unrequired data is set too high; this is the case for custom fields in uploads after the organization's first upload. 有关详细信息,请参阅:For more information, see the following:

问题 2.Q2. 对于我的第一个组织数据上载,我是否应选择 "追加" 或 "替换"?For my first organizational data upload, should I choose "append" or "replace"?

A2.A2. 对于第一次上载,您将不会有上述任何一种选择。For your first upload, you will not have either of these choices. 有关您的第一个上载的更多详细信息,请参阅上传组织数据 (first 上传) For more details about your first upload, see Upload organizational data (first upload). 有关何时追加或替换的详细信息,请参阅上传组织数据 (后续上传) For more information about when to append or replace, see Upload organizational data (subsequent uploads).

问题 3.Q3. 对于必填字段,工作区分析需要多少百分比来满足有效性阈值?For the required fields, what percentage does Workplace Analytics require for the validity threshold?

旁.A3. 工作区分析要求 PersonId 和 EffectiveDate 字段满足有效阈值的100%,这是因为每行数据必须为组织中的每个人提供一个 PersonId。Workplace Analytics requires that the PersonId and EffectiveDate fields meet 100% of the validity threshold, because each of row of data must have a PersonId for each person in your organization. 其他必填字段 (如 ManagerID) 必须超过有效阈值的95%。The other required fields (such as ManagerID) must exceed 95% of the validity threshold. (请注意,有效性阈值的计算仅考虑两种类型的数据值:有效值和空值。(Note that the calculations of validity threshold consider only two kinds of data values: valid values and blank values. 这意味着,对于设置为95% 的有效性阈值,如果少于5% 的列中的值为空且其余值有效,则该列将通过验证。This means that, for a validity threshold that's set to 95%, the column will pass validation if fewer than 5% of the values in the column are blank and the rest are valid. 但是,如果即使一个单元格包含格式不正确的数据,整个文件上传将会失败。 ) 有关详细信息,请参阅fields 表中的列However, if even one cell contains malformed data, the entire file upload will fail.) For more information, see Columns in the fields tables.

问题 4.Q4. 如果由 PersonID 代表的员工 () 有多个经理 (谁将由 ManagerIDs) ,则会发生什么情况?What happens if an employee (who is represented by a PersonID) has more than one manager (who would be represented by ManagerIDs)?

A4.A4. 组织数据只允许标识一个单一的主管理器。Organizational data allows for the identification of only one single, primary manager. 在给定 EffectiveDate 上,此管理器由该 PersonID 的 ManagerID 表示。This manager is represented by the ManagerID for that PersonID on a given EffectiveDate. 但是,请注意,工作区分析管理员可以使用组织数据中的 "EffectiveDate" 字段,以指示雇员的主经理已从一个月更改为下一个月。However, note that the Workplace Analytics admin can use the EffectiveDate field in the organizational data to indicate that an employee’s primary manager has changed from one month to the next.

问题 5.Q5. 谁获取必须上载到工作区分析的组织数据?Who obtains the organizational data that must be uploaded to Workplace Analytics?

A5.A5. 通常情况下,HR 获取此数据,并将其提供给准备和将其上载到工作区分析的工作区分析管理员。Usually, HR obtains this data and provides it to the Workplace Analytics admin who prepares and uploads it to Workplace Analytics.

问题 6.Q6. 谁可以在将组织数据上载到工作区分析后访问它们?Who can access organizational data after it has been uploaded to Workplace Analytics?

A6.A6. 出于隐私原因,没有人可以下载上载的原始数据。For privacy reasons, no one can download the raw data that was uploaded. 工作区分析管理员可以查看有关 "数据源" 页上的组织数据的元数据,但不能看到属性值如何映射到各个用户。Workplace Analytics admins can view metadata about the organizational data on the Data sources page, but they cannot see how the attribute values map to individual people.

使用工作区分析Use Workplace Analytics

会议排除Meeting exclusions

问题 1.Q1. 隐私设置和会议排除规则的区别是什么?What is the difference between privacy settings and meeting-exclusion rules?

A1.A1. 管理员设置_隐私设置_,以更改工作区分析提取数据的方式,例如防止在任何工作区分析计算中包含数据。Admins make privacy settings to change the way Workplace Analytics extracts data, such as preventing data from ever being included in any Workplace Analytics calculation. 请注意,隐私设置更改适用于将来的数据提取,并且不 retroactive 过去的数据。Note that privacy settings changes apply to future data extractions and are not retroactive to past data. 有关详细信息,请参阅隐私设置工作区分析隐私和数据访问For more information, see Privacy settings and Workplace Analytics privacy and data access.

分析师在工作区分析查询中使用_会议排除规则_,以帮助确保查询结果能够准确表示组织内的相关会议规范。Analysts use meeting-exclusion rules in Workplace Analytics queries to help ensure that query results accurately represent relevant meeting norms within the organization. 对这些规则所做的更改将在数据中应用追溯。Changes to these rules apply retroactively in the data. 有关详细信息,请参阅在工作区分析中会议排除规则For more information, see Meeting exclusion rules in Workplace Analytics.

问题 2.Q2. 其他分析师是否可以使用我创建的会议排除规则集?Can other analysts use the meeting exclusion rule sets that I create?

A2.A2. 是。Yes. 组织中的任何人都可以使用组织中任何其他人已创建的会议排除规则。Anyone in your organization can use the meeting exclusion rules that anyone else in the organization has created. 有关会议排除规则的详细信息,请参阅应用会议排除规则For more information about meeting exclusion rules, see Application of meeting-exclusion rules.

数据验证、验证和使用Data validation, verification, and use

问题 1.Q1. 为什么我的测量填充小于分配有许可证的员工数?Why is my measured population less than the number of employees with assigned licenses?

A1.A1. 如果只选择了一部分进行数据分析,或者如果您的管理员排除了从上载到工作区分析的组织数据的一部分,则可能会发生这种情况。This can happen if you selected only a subset of your population for data analysis, or if your admin excluded a subset of the population from the organizational data that's uploaded into Workplace Analytics. 有关更多详细信息,请参阅在准备组织数据的数据中分配许可证要包含的谁,并查看数据计数的来源For more details, see Assign licenses and Who to include in the data in Prepare organizational data, and see Origin of data counts.

问题 2.Q2. 为什么对于内部和外部协作者来说,总计看起来太高呢?Why do the totals seem too high for internal and external collaborators?

A2.A2. 协作者总数包括已测量员工在所选时段内至少共同使用一次的内部 (或外部) 人员的数量。The collaborator totals include the number of internal (or external) people with whom the measured employees have collaborated at least one time during the selected period. 外部协作页面上的摘要标头中包含的总计不会因在页面设置中应用的筛选器而发生变化。The totals that are included in the Summary header on the External collaboration page do not change because of filters that have been applied in Page settings. 有关详细信息,请参阅External 协作For details, see External collaboration.

问题 3.Q3. 为什么电子邮件或会议趋势线不会为整个全时13个月的时间段( (或我设置) 的自定义时间段返回?Why doesn't the email or meeting trend line extend back for the entire historical 13-month period (or for the custom time period that I set)?

旁.A3. 业务策略可能会影响工作区分析处理的历史数据。Business policies can affect the historical data that is processed by Workplace Analytics. 查看历史数据时,如果您在电子邮件和/或会议活动中看到了稳定的拒绝或时间点拖放,则可能是由于电子邮件已存档。As you view historical data, if you see a steady decline or point-in-time drop in email and/or meeting activity, it might be due to email having been archived. 另一个原因可能是在提取数据之前删除的重复会议。Another cause can be recurring meetings that are deleted before the data is extracted. 但是,这只会影响初始基准数据,因为以后的删除操作不会影响之前收集的每周数据。However, this only impacts initial baseline data, because future deletions do not affect weekly data that was previously collected. 在 "" 页上,您可以选择电子邮件和/或会议活动稳定的时间段。On the Sources page, you can select a time period where the email and/or meeting activity is stable. 有关详细信息,请参阅Office 365 数据摘要For more information, see Office 365 data summary.

问题 4.Q4. 工作区分析如何处理发送到通讯组列表的会议和电子邮件的数据?How does Workplace Analytics process data for meetings and emails sent to distribution lists?

A4.A4. Workplace Analytics 将通讯组列表的电子邮件和会议数据作为单个实体或个人处理。Workplace Analytics processes email and meetings data for a distribution list as a single entity or person. 它不会展开通讯组列表并将会议和电子邮件时间分配给其成员。It does not expand the distribution list and assign meeting and email hours to its members. 若要获取更准确的数据,请通过添加分布列表成员的属性或任何对列表填充的最佳说明,来上载这些列表的组织数据属性。For more accurate data, upload the organizational data attributes for these lists by adding attributes of the distribution-list members or whatever best describes the list population. 有关详细步骤,请参阅上传组织数据See Upload organizational data for detailed steps.

问题 5.Q5. 从 Microsoft 团队中处理哪些协作信息?What collaboration information is processed from Microsoft Teams?

A5.A5. 团队提供有关协作活动的信息,即直接邮件 (聊天) 和呼叫。Teams provides information about collaboration activities, namely direct messages (chats) and calls. 它不提供有关团队频道的信息。It does not provide information about Teams channels.

问题 6.Q6. 当某人为组的共享邮箱或代表其他人发送邮件或会议邀请时,谁将获得发送信用?When a person sends a message or meeting invite for a group’s shared mailbox or on behalf of another person, who gets credit for sending it?

A6.A6. 这取决于邮箱的类型以及为 Exchange Online 邮箱设置的权限。It depends on the type of mailbox and which permissions are set for the Exchange Online mailbox. 有关详细信息,请参阅邮箱权限For details, see Mailbox permissions.

  • (Microsoft 365 组邮箱) 的共享邮箱通常有许多组成员共享对组邮箱的访问和权限。A shared mailbox (Microsoft 365 group mailbox) typically has a number of group members that share access and permissions for the group mailbox. 共享邮箱的一个示例是 LeadershipTeam@Contoso.comAn example of a shared mailbox is LeadershipTeam@Contoso.com. 有关详细信息,请参阅应在共享邮箱中使用的权限For details, see Which permissions you should use in shared mailboxes.

    • 代理发送权限-当共享邮箱中具有 "代理发送" 权限的组成员发送来自组邮箱的邮件或会议邀请时,Exchange 将向共享邮箱(而不是组中的任何单个人员)提供信用积分。Send As permission - When a group member with Send As permission for a shared mailbox sends a message or meeting invitation from the group mailbox, Exchange gives credit to the shared mailbox instead of any single person in the group. 工作区分析在其计算中不使用此操作。Workplace Analytics does not use this action in its calculations.
    • 代表发送权限–此权限对 Exchange 管理中心中的共享邮箱不可用。Send on Behalf permission – This permission is not available for shared mailboxes in Exchange Admin Center. 但是,如果使用 PowerShell (GrantSendonBehalf 参数设置) ,则发送邮件的人员将在工作区分析计算中获取该邮件的信用。However, if it is set with PowerShell (GrantSendonBehalf parameter), the person who sends the message gets credit for it in Workplace Analytics calculations.
  • 单个邮箱 (或与主邮箱所有者) 的链接邮箱可以链接或授予代理访问权限,也可以向其他人授予对主邮箱所有者发送邮件或会议邀请的以下权限之一。An individual mailbox (or a linked mailbox) with a primary mailbox owner can link or give delegate access and one of the following permissions to another person to send messages or meeting invites for the primary mailbox owner. 例如,具有代理访问权限的助理可以从其经理的邮箱发送邮件或会议邀请。For example, an assistant with delegate access can send a message or meeting invite from their manager's mailbox. 代理可以具有以下权限之一。A delegate can have one of the following permissions. 有关详细信息,请参阅向另一个用户授予邮箱权限For details, see Give mailbox permissions to another user.

    • "代理发送" 权限–邮箱的主要所有者获取发送邮件或邀请在工作区分析计算中的信用。Send As permission – The primary owner of the mailbox gets credit for sending the message or invite in Workplace Analytics calculations.
    • 代表发送权限-代表邮箱所有者发送邮件的人员获取工作区分析计算中的积分。Send on Behalf permission - The person who sends the message on behalf of the mailbox owner gets the credit in Workplace Analytics calculations.
    • "代理发送" 和 "代表发送" 权限–如果代理同时设置了这两个权限,则使用 "代理发送" 权限,并且该用户不会获得在 Exchange 中发送邮件或邀请,因此工作区分析会在计算中对邮箱所有者进行信用。Both Send As and Send on Behalf permissions – If the delegate person has both permissions set, the Send As permissions are used and that person does not get credit for sending the message or invite in Exchange and therefore Workplace Analytics credits the owner of the mailbox in calculations.

探索仪表板Explore dashboards

问题 1.Q1. 为什么我的 "已筛选员工" 数量少于 "已衡量员工",而没有应用筛选器?Why do I have fewer "filtered employees" than "measured employees" with no filters applied?

A1.A1. 员工数据可以根据为您使用的 "浏览" 或 "解决方案" 页选择的页面设置进行更改。Employee data can change based on the Page settings that are selected for the Explore or Solutions pages that you are using. 这些设置不一定被视为筛选器,但仍会导致总计发生变化。These settings are not necessarily considered filters but can still cause totals to vary. 有关详细信息,请参阅 "页面设置"。For details, see Page settings.

问题 2.Q2. Workplace Analytics 如何估计低质量会议的成本?How does Workplace Analytics estimate the cost of low-quality meetings? 可以自定义此估计吗?Can I customize this estimate?

A2.A2. 管理员可以在组织数据上载中包含可选的每小时速率数据,然后可以使用这些数据计算会议概述的低质量会议的总成本。Admins can include optional hourly-rate data in the organizational data upload, which they can then use to calculate the total cost of low-quality meetings for the Meetings overview. 如果提供了此组织数据,则会将成本计算为该人员的默认组织的每小时费率乘以低质量会议小时数。If this organizational data is provided, cost is calculated as the person's default hourly rate for the organization multiplied by the number of low-quality meeting hours. 如果没有为会议参与者分配小时工资率,将使用默认的小时费率 $75。If no hourly rate is assigned to a meeting participant, a default hourly rate of $75 is used. 在 "设置" 页上,管理员可以将 "小时工资率" 字段中的值从其默认值更改为另一个小时费率。On the Settings page, admins can change the value in the Hourly Rate field from its default value to another hourly rate.

问题 3.Q3. 为什么组的总会议小时数 (包括在工作时间和工作时间之后) 大于该周的组的总会议小时数?Why are a group's total meeting hours (included as part of working hours and after-hours work) larger than the group's total meeting hours for the week?

旁.A3. 出现这种情况的原因是,工作区分析计算会议时间的方式。This can occur because of the way Workplace Analytics calculates meeting hours. 会议总小时数包括已为与会者会议调整的工时数,而总工作小时数和后工作时间包括会议小时数 (未调整计划会议的) )。The meeting-hours total includes adjusted hours for attended meetings, while total working hours and after-hours work include the number of meeting hours (not adjusted) for scheduled meetings.

当会议重叠时,可能会发生这种差异。This discrepancy can occur when meetings overlap. 工作区分析不知道参加了哪些会议,因此会议时间总量将包括调整的小时数,这是会议实际花费的时间的估计值。Workplace Analytics doesn't know which meetings were attended, so the meeting hours total will include adjusted hours, which are an estimate of time actually spent in meetings. 例如,假设有五名员工的一组人预订了两个从4:30 到 5:30 PM 的会议,该组的工作日结束于 5:00 PM。For example, let's say a group of five employees is double booked for two meetings from 4:30 to 5:30 PM, and the group's workday ends at 5:00 PM. 对于此方案,工作区分析将会议时间调整为一小时,因为组无法同时参加两个会议。For this scenario, Workplace Analytics adjusts the meeting hours to one hour, since the group cannot attend two meetings at the same time. 但是,工作区分析不会对两个计划的会议进行调整,这将导致在总工作时间和五个小时的工作时间内添加五个小时。However, Workplace Analytics doesn't adjust for the two scheduled meetings, which results in it adding five hours to total working hours and five hours to after-hours work. 通过拒绝任何计划的会议未参加,该组可以避免这种差异。The group can avoid this discrepancy by declining any scheduled meetings that they do not attend.

问题 4.Q4. 计算焦点时所采用的工作日总长度是多少?What is the total workday length assumed for calculating focus hours?

A4.A4. 如果衡量的员工或内部协作者将其时区定义为组织数据的一部分,则工作区分析将使用各自的时区设置来处理工作时间、聚焦时间和其他与时间相关的指标。If measured employees or internal collaborators have their time zones defined as part of your organizational data, Workplace Analytics uses their individual time-zone settings for working hours, focus hours, and other time-related metrics. 但是,如果组织数据没有为员工定义时区,工作区分析将使用您的管理员在 Workplace Analytics 中为该员工设置的默认时区设置。However, if the organizational data does not define a time zone for an employee, Workplace Analytics uses the default time-zone setting that your admin sets in Workplace Analytics for that employee. 有关更多详细信息,请参阅时区设置焦点小时数和分段的小时数For more details, see Time zone setting and Focus hours and fragmented hours.

QueriesQueries

问题 1.Q1. 对于组到组查询,"组内的协作者" 和 "与时间组相同的组" 的结果有何不同?For a group-to-group query, what's the difference between the results for "Collaborators Within Group" and for "Same group as Time Investor?"

A1.A1. 如果查询的结果将同一组人员定义为 "投资者" 和 "合作者" 组的成员,并且这些用户也与任何定义的筛选器匹配,则会将协作者分组到组结果中的合作者下。If the result of a query defines the same set of people as members of both the time investors and collaborators groups, and these individuals also match any defined filters, then the collaborators are grouped together under the Collaborators Within Group results. 当仅当没有其他组参与会议或电子邮件时,仅当时间投资者组向自己自己分配时间时,就会应用相同的组时间。The Same group as Time Investor results apply when a time-investor group allocates time only to themselves if no other groups are participating in the meeting or email. 有关更多详细信息,请参阅组到组查询输出时间分配概述See Group-to-group query output and Overview of time allocation for more details.

问题 2.Q2. 如何在我的公司中分析特定时间范围的协作小时数,例如,下午8点到上午8点?How do I analyze collaboration hours at my company for a specific time frame, such as 8 PM to 8 AM?

A2.A2. 您可以使用 "协作时" 度量来筛选特定的时间范围,而不考虑它发生的时间。You can use the Collaboration hours metric to filter for a specific time frame, regardless of when it occurs. 请注意,使用协作小时筛选的查询结果将包含时间段(例如,上午8点到8点)的时间段,这将包括在此时间内合作的所有人员,而不管他们是否将此时间段设置为其日历上的工作时间或非工作时间。Note that query results that use the Collaboration hours to filter for a time period that includes after-hours time, such as 8 PM to 8 AM, will include all people who collaborated during this time regardless of if they have this time period set as their working or non-working hours on their calendar.

问题 3.Q3. 为什么在查询输出中,会议小时数和电子邮件时间的总和与工作时间和工作时间的总和不匹配?Why don't totals for meeting hours and email hours match up with totals for working hours and after hours in person query output?

旁.A3. 由于工作时间和后几小时的总计计算 "在日历上预定的时间",而不是 "会议时间"。Because totals for working hours and after hours calculate the "time booked on your 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 times that overlap on the calendar. 一种启发式逻辑,对某人可能参加的会议进行排序,并相应地分配时间。A heuristic logic orders which meetings a person likely attended and assigns time accordingly. 有关更多详细信息,请参阅人员查询输出For more details, see Person query output.

问题 4.Q4. 当我下载并查看查询时,Excel 中为什么无法读取或不能正常显示数据?When I download and view a query, why is the data unreadable or not shown correctly in Excel?

A4.A4. 您可能已按的那样打开 .csv 文件。You probably opened the .csv file as is. 为了使 Excel 能够正确显示数据,您需要将 .csv 文件导入到 Excel 中。For Excel to show the data correctly, you need to import the .csv file into Excel. 如果使用的是 Excel 2016,请按照下载和导入查询结果中的步骤操作。If you are using Excel 2016, follow the steps in Download and import query results. 对于其他版本的 Excel,请在 Excel 中打开 "帮助",然后搜索有关如何导入 .csv 文件的说明。For other versions of Excel, open Help in Excel and then search for the instructions on how to import a .csv file.