查询的自动刷新选项Auto-refresh option for queries

一次性查询向您显示快照One-time queries show you a snapshot

作为分析师,您可以在工作区分析中运行不同种类的查询,包括人员、会议、组到组和人员到组的查询,以获取工作区行为的快照。As an analyst, you can run different kinds of queries in Workplace Analytics, including person, meeting, group-to-group, and person-to-group queries to get a snapshot of workplace behavior.

您可以将查询作为您设置的一次性事件运行,再运行一次,然后获取结果。You can run a query as a one-time event where you set it up, run it one time, and get the results. 若要可视化此查询所发现的工作区模式,可以将结果加载到数据分析工具(如 Power BI 或 Excel)中。To visualize workplace patterns uncovered by this query, you can load the results into a data analysis tool, such as Power BI or Excel.

查询结果(尤其是在数据分析工具中查看时)可能会发现动态模式。Query results, especially when viewed in a data analysis tool, can uncover dynamic patterns. 这些模式随着时间的推移而演化,因为员工的工作场所行为随着时间的推移而演变。These patterns evolve over time because the workplace behavior of employees evolves over time. 若要在一段时间内分离一个不断发展的工作场所行为的实例,可以按常规计划多次使用适用的查询。To isolate one instance of evolving workplace behavior over time, you can use the applicable query multiple times, on a regular schedule. 为此,您可以使用 "工作区分析" 查询的自动刷新功能。To do this, you can use the auto-refresh feature for Workplace Analytics queries.

使用自动刷新选项创建查询Create a query with the auto-refresh option

Note

通常,一个组织最多可以有20个自动刷新查询。Generally, an organization can have a maximum of 20 auto-refresh queries. 有关详细信息,请参阅 最大自动刷新查询数For more information, see Maximum number of auto-refresh queries.

创建自动刷新查询To create an auto-refresh query

  1. 在 " 查询 " 页上,选择查询类型,如 "人员查询"。On the Queries page, select a query type, such as Person query.

  2. 命名查询并添加可选说明。Name the query and add an optional description.

  3. 选择时间范围,例如一个月或一年:Select a time range, such as one month or one year:

    Setting auto-refresh for a Workplace Analytics query

    Note

    "自动刷新" 仅适用于 "时间段" 列表中的预定义时间范围。Auto-refresh is available only for the predefined time ranges in the Time period list. 如果选择 " 自定义范围",则 "自动刷新" 选项不可用。If you select Custom range, the Auto-refresh option is unavailable.

  4. 选择 " 自动刷新"。Select Auto-refresh.

  5. 选择“运行”。Select Run.

停止自动刷新选项Stop the auto-refresh option

仅对已运行且对其进行了自动刷新的查询执行以下步骤。Follow these steps only for a query that has already run and for which auto-refresh is currently in effect.

  1. 在 "工作区分析" 中,打开 " 查询 > 结果 " 页。In Workplace Analytics, open the Queries > Results page.

  2. 在查询的行中,选择省略号。In the row of the query, select the ellipsis.

  3. 在 "选项" 菜单中,选择 " 关闭自动刷新":In the option menu, select Turn off auto-refresh:

    关闭自动刷新

启动/重新启动自动刷新选项Start/re-start the auto-refresh option

仅对已运行且当前未生效的查询执行以下步骤。Follow these steps only for a query that has already run and for which auto-refresh is not currently in effect.

  1. 在 "工作区分析" 中,打开 " 查询 > 结果 " 页。In Workplace Analytics, open the Queries > Results page.

  2. 在查询的行中,选择省略号。In the row of the query, select the ellipsis.

  3. 在 "选项" 菜单中,选择 " 打开自动刷新"In the option menu, select Turn on auto-refresh:

    启用自动刷新

或者,您可以在 "工作区分析" 主页上的 " 通知" 面板 中续订自动刷新查询。Alternatively, you can renew an auto-refresh query in the notifications panel on the Workplace Analytics Home page.

自动刷新详细信息Auto-refresh details

基本行为Basic behavior

  • 创建查询时,您将首次运行该查询。When you create the query, you run it for the first time. 在运行时,它将使用您定义的确切日期范围内的数据。As it runs, it uses data from the exact date range that you defined.

  • 查询会自动再次运行,每个时间段(如周或) 月) (一次。The query automatically runs again, once for every time period that you selected (such as week or month). 每次运行都与工作区分析刷新 Microsoft Exchange 中的邮件和日历数据的日期相符。Each run coincides with the date on which Workplace Analytics refreshes mail and calendar data from Microsoft Exchange.

  • 查询每次自动运行时,其日期范围将按所选时间段中的一个单位(如周或月) (前进。Each time the query runs automatically, its date range advances by one unit of the time period that you selected (such as week or month). 即,其开始日期和结束日期都将按相同的时间长度移到更晚的日期。That is,both its start date and its end date shift shift to a later date by the same amount of time.

自动刷新停止、重新启动和到期Auto-refresh stop, restart, and expiration

"查询 > 结果" 页上的 "是定期" 列显示是否为该行代表的查询打开了自动刷新:The Is Recurring column on the Queries > Results page shows whether auto-refresh is currently turned on for the query represented by that row:

关闭自动刷新状态

  • 当查询的自动刷新过期后,可以对其进行续订。After auto-refresh expires for a query, you can renew it. 请参阅 启动/重新启动自动刷新选项See Start/re-start the auto-refresh option.

  • 删除已启用自动刷新的查询将停止该查询将来的所有自动刷新的运行。Deleting a query for which auto-refresh is turned on stops all future auto-refresh runs of that query.

自动刷新查询的最大数量Maximum number of auto-refresh queries

通常,一个组织最多可以有20个自动刷新查询。Generally, an organization can have a maximum of 20 auto-refresh queries. 如果您的组织已达到此限制,并且您需要新的自动刷新查询,您可以选择以下选项:If your organization has already reached this limit and you need a new auto-refresh query, you have the following options:

  • 删除现有的自动刷新查询,或对查询 > 结果 页面) 中的查询 (启用自动刷新。Delete an existing auto-refresh query or turn auto-refresh off for a query (on the Queries > Results page). 然后,创建新的自动刷新查询。Then, create your new auto-refresh query.
  • 请联系 Workplace Analytics 以请求其他自动刷新查询。Contact Workplace Analytics to request additional auto-refresh queries. 若要执行此操作,请按照 " 获取支持" 下的 "Workplace Analytics 支持" 行中的说明进行操作。To do this, follow the instructions in the "Workplace Analytics Support" row under Get support.

系统关闭查询的自动刷新选项System turns off a query's auto-refresh option

以下两种情况可能会导致工作区分析关闭查询的自动刷新选项:Two circumstances can cause Workplace Analytics to turn off the auto-refresh option for a query:

这两种情况都是管理员和分析师做出响应的机会,如以下各节所述:Both of these circumstances present opportunities for admins and for analysts to respond, as described in the following sections:

组织数据缺少的列Columns missing from organizational data

管理员定期上传包含组织数据的文件。Admins regularly upload files that contain organizational data. 在其中一个上载步骤中,他们选择是将新的组织数据追加到现有数据,还是将现有的组织数据替换为新的数据。In one of the upload steps, they choose whether to append the new organizational data to the existing data, or to replace the existing organizational data with the new data.

如果管理员选择 "替换",则可以保留现有数据架构或使用新的数据架构。If the admin chooses "replace," they can retain the existing data schema or use a new one. 引入新的数据架构可能导致架构与原始架构不匹配。Introducing a new data schema can cause a schema mismatch with the original schema. 例如,当新架构缺少旧架构中存在的一个或多个列时,会发生这种情况。This happens, for example, when the new schema is missing one or more columns that were present in the old schema.

如果设置为自动刷新的查询使用新架构中缺少的列,则工作区分析会将此查询的自动刷新选项设置为 off。If a query that is set to auto-refresh uses a column that is missing in the new schema, Workplace Analytics turns the auto-refresh option for this query to off.

排除列或哈希列Excluded or hashed columns

在上载组织数据时,管理员可以通过影响数据列的包含和显示的方式设置报告选项。While uploading organizational data, admins can set report options in ways that affect the inclusion and display of data columns. 例如,他们可以将列设置为 "从报表中排除", (省略列) 或 "报告中的哈希" (,该属性屏蔽了无意义值) 的 true 值。For example, they can set a column to "Exclude from report" (which omits the column) or to "Hash in report" (which masks the true value with a meaningless value).

如果设置为自动刷新的查询使用已排除或哈希的列,则工作区分析会将此查询的自动刷新选项设置为 off。If a query set to auto-refresh uses a column that becomes excluded or hashed, Workplace Analytics turns the auto-refresh option for this query to off.

管理员选项Options for admins

如果出现以下任一架构不匹配情况,在完成映射字段后,"工作区分析" 将显示一条警告消息,该消息将显示 "您的上载可能会影响自动刷新查询的执行" 的特定问题。If either of these schema-mismatch situations arises, after you finish mapping fields, Workplace Analytics shows a warning message that reads "Your upload has certain issues that may affect execution of the auto refresh queries."

如果看到此消息,请转到 如果缺少或排除预期列 以了解详细信息。If you see this message, go to If expected columns are missing or excluded for more information.

分析人员的选项Options for analysts

如果出现上述任一架构不匹配情况,工作区分析会以各种方式通知您。If either of these schema-mismatch situations arises, Workplace Analytics notifies you in various ways. 然后,您可以更改受影响的自动刷新查询,以再次运行它们,或访问查询的最近完成的运行结果。You can then change the affected auto-refresh queries to run them again or access the results of the query's most recent completed run.

  • 在 " 结果 " 页上,它在 " 状态 " 列中为已停止的每个查询显示一个红色的 "已停止" 图标:On the Results page, it shows a red "stopped" icon in the Status column for each query that has been stopped:

    "已停止" 图标

    (显示的非自动刷新查询的黄色图标,由于架构更改,也无法运行。 ) (A yellow icon is shown for non-auto refresh queries that, as a result of the schema changes, also cannot run.)

    在每种情况下,您都可以将鼠标悬停在工具提示上方以查看详细信息。In each case, you can hover over the tooltip to see more information.

  • 在查询创作页面的 " 选择筛选器 " 和 " 组织数据 " 区域中,它将显示当前筛选器和不再存在的输出列:In the Select filters and Organizational data areas of a query-authoring page, it shows the current filters and the output columns that are no longer present:

    筛选器和缺少的列

    在许多情况下,您仍可以手动运行已关闭其自动刷新的查询,但如果列丢失,查询的结果将不会包含已删除的属性。In many cases, you can still manually run the queries for which auto-refresh has been turned off, but if columns are missing, the query's results will not contain the attributes that were removed.

使用自动刷新选项查看查询结果View query results with the auto-refresh option

在 "分析 > 查询 > 结果" 页上,在 "结果" 表中查找您的查询,其中包括以下内容:On the Analyze > Queries > Results page, find your query in the results table, which includes the following:

  • 结果 (每周 最新 运行的 .csv 文件) 。The results (a .csv file) of the latest weekly run. 您可以选择 " 下载 " 以下载这些结果的存档文件。You can select Download to download an archived file of these results.
  • 查询上次运行的日期。The date on which the query last ran.
  • 一个图标,用于将其指示为带有自动刷新选项的查询。An icon that indicates it as a query with the auto-refresh option.

Power BI 中的自动刷新查询结果Auto-refresh query results in Power BI

在 " 结果 " 页上,您可以复制指向查询结果的链接,然后在 Power BI 中使用它。On the Results page, you can copy a link to the query results and then use it in Power BI.

  1. 在查询的行的右侧,选择 " 复制链接":To the right of the query's row, select Copy link:

    复制查询的结果链接

  2. 选择 " 复制"。Select Copy. "获取结果链接" 对话框将显示 "已复制" 一词。The Get results link dialog box displays the word "Copied."

  3. 在 Power BI 中,在 "开始" 选项卡上,选择 " 获取数据",然后选择 " OData 源"。In Power BI, on the Home tab, select Get Data, and then select OData feed.

  4. 在 " OData 源 " 对话框中,将复制的链接粘贴到 "URL" 字段中:In the OData feed dialog box, paste the link that you copied into the URL field:

    Power BI 中的 OData 源

  5. 选择“确定”。Select OK.

  6. 输入你的客户端凭据,然后选择 " 连接"。Enter your client credentials, and then select Connect.

执行此操作后,Power BI 将在工作区分析中维护与此查询的连接。After you do this, Power BI maintains a connection to this query in Workplace Analytics. 在将来,若要可视化查询的当前结果,请在 Power BI 中打开 "工作区分析" 项目并选择 " 刷新"。In the future, to visualize the query's current results, open the Workplace Analytics project in Power BI and select Refresh.

查看、下载和导出查询结果View, download, and export query results