Overview: Query Builder for Teamwork
如何
如何访问Comport的查询生成器
导航Metrics > Query Builder访问Comport的查询构建器。点击绿色+创造习惯Metric button and select your connected Teamwork Account from theD.ata Source下拉列表。
-
查询生成器is available on the Professional and Performer plans. Request a trial of Query Builder by followingthese steps。
How to use the Query Builder for Teamwork
Teamwork的查询构建器是唯一的,因为它允许您使用查询构建器进行时间跟踪或用于任务的查询构建器。您的选择应依赖于您要构建的自定义指标。
IN THIS SECTION
查询构建器时间跟踪
Pro Tip:在度量标准和维度之间添加“by”,以确定适当的自定义度量名称。从上面的度量标准和维度示例,我们可以通过项目名称“按项目名称”创建自定义度量标准“时间”。
此数据可以在线图表或条形图中使用以显示过去的性能。它还用于计算当前日期范围性能的百分比增长或损失VS比较日期范围性能。如果未选择与参数的比较,则无法为自定义度量显示比较百分比。
If the data synced from the Metric and Dimension fields meet the Filter specifications, the data is retained and included in the Custom Metric value. If the data synced from the Metric and Dimension fields don't meet the Filter specifications, the data is excluded from the Custom Metric value.
Pro Tip:如果您不知道用于使用案例的哪个过滤器,请使用Dimension + Data Preview进行故障排除,并更有深入了解每个字段的Teamwork帐户返回的数据。了解更多here。
查询构建器的任务
Pro Tip:在度量标准和维度之间添加“by”,以确定适当的自定义度量名称。从上面的度量标准和维度示例,我们可以创建自定义度量标准“由公司名称的任务数”,“按项目名称估计时间”或“按状态的任务数”。
If "Due Date" is selected, the截止日期选项字段将被揭示。在这里,您可以选择自定义度量标准中包含的截止日期。
如果您选择“完成日期”作为D.ate Filter, 这D.ate Range字段将被揭示。在这里,你可以n select up to aa Date Range that will be available for the Custom Metric. The Date Range selected is the only periods of time that data is synced for this Custom Metric. Any Tasks completed during the specified Date Range(s) will be included in the Custom Metric.
将此自定义度量标准添加到DataBoard时,将突出和显示的数据仍将引用构建自定义度量时选择的日期范围,但唯一的日期范围选项将为“所有时间”。这是因为在团队合作中,您可以选择广泛的截止日期,或者您可能没有截止日期。
If the data synced from the Metric and Dimension fields meet the Filter specifications, the data is retained and included in the Custom Metric value. If the data synced from the Metric and Dimension fields don't meet the Filter specifications, the data is excluded from the Custom Metric value.
Pro Tip:如果您不知道使用哪个额外的过滤器为您的用例提供,请使用Dimension + Data Preview进行故障排除,并更有深入了解每个字段的Teamwork帐户返回的数据。了解更多here。
How to create a Custom Teamwork Metric [Example]
在此示例中,我们将创建自定义度量标准,以报告客户#1的不完整任务,并在当前周设置为期日期。我们不希望在此自定义度量标准中包含任何已完成的任务。
如何将自定义团队公制添加到Databoard
Learn how to add a Custom Metric to a Databoardhere。
一种dditional Information
- When you add this Custom Metric built using the Query Builder for Tasks to a Databoard, the data synced and displayed will still reference the Date Range you selected when building the Custom Metric but the only Date Range option will be "All Time." This is because within Teamwork you can select a wide range of Due Dates, or you could have no Due Date set.