常用公式

先决条件

访问 Insights 2021.10 以下版本中的公式

1. 用户需要设计者权限，并且需要导航到 Insights 门户。

   

2. 然后导航到现有仪表板或创建新仪表板。

   

3. 然后编辑微件或创建新的微件。

   

4. 然后，设计者必须选择值旁边的加号

   

5. Select the fx button to create a new formula

   

6. 在这里，您将看到“功能”选项卡

   

7. Commonly used functions are highlighted for comparison in the Comparison table.

访问 Insights 2023.4 中的公式

1. 用户需要设计者权限，并且可以导航到现有仪表板或从头开始创建仪表板。

   

2. 然后，用户必须编辑仪表板。

   

3. 然后选择“添加图块”，选择“可视化”。

   

   

4. 然后选择一个探索。

   

5. 使用“添加新度量”、“添加新维度”或“表格计算”选项创建新的自定义公式。

   

比较

常用公式	2021.10 版本之前的 Insights	Insights 2023.4
Sum - 将列表中的数字相加	在“函数”选项卡中，搜索 Sum 函数，然后选择该函数。	First select the Add button next to the custom fields. Select Table Calculation. Then type Sum and enter the necessary parameters. Choose a name for the table calculation and select Save. Check more details in the Looker user guide.
Round - 返回四舍五入后的数字	搜索 Round 函数，然后从选项卡中选择该函数。	First, select the Add button next to the custom fields. Select Table Calculation. Type Round and enter the necessary parameters. Choose a name for the table calculation and select Save. Check more details in the Looker user guide.
Now - 返回当前时间段	搜索 Now 函数，然后从“函数”选项卡中选择该函数。	First, select the Add button next to the custom fields. Select Table Calculation. Then type Now. Choose a name for the table calculation and select Save. Check more details in the Looker user guide.
Median - 计算中位数	Search for the Median function in the Functions tab. Then select the function to bring the median function into the formula editor.	First, select the Add button next to the custom fields. Select Table Calculation. Then type Median and enter the necessary parameters. Choose a name for the table calculation and select Save. Check more details in the Looker user guide.
最大	搜索 Max 函数并选中它以将其添加到公式编辑器。	First, select the Add button next to the custom fields. Select Table Calculation. Then type Max and enter the necessary parameters. Choose a name for the table calculation and select Save. Check more details in the Looker user guide.
If - 根据条件执行数值表达式	在“函数”选项卡中，搜索“if”，然后选择该函数。	首先，单击自定义字段旁边的“添加”按钮。 Select Table Calculation. Then type IF and enter the necessary parameters. Choose a name for the table calculation and select Save. Check more details in the Looker user guide.
Floor - 返回向下取整到最接近“1”的倍数的数字	搜索 Floor 函数，然后选择该函数并将其引入公式。	First, select the Add button next to the custom fields. Select Table Calculation. Then type Floor and enter the necessary parameters. Choose a name for the table calculation and select Save. Check more details in the Looker user guide.
筛选公式中的字段	(字段，筛选的字段) to filter a field inside a formula, add the field next to the original field, select it, select Rename, and then choose the filter.	To add a filter, select the Filter button next to the field name. 然后，您将在可视化顶部看到筛选器。
日差 - 返回开始时间和结束时间之间的差额	在“函数”选项卡中搜索日差，然后选择日差函数。	First, select the Add button next to the custom fields. Select Table Calculation. Then type diff_days and enter the necessary parameters. Choose a name for the table calculation and select Save. Check more details in the Looker user guide.
Count - 计算唯一值的数量	示例：Count(ProcessName)。 In the Functions tab type Count and select the function. Then navigate to the Data Browser tab, and select processname inside of the function.	First, select the Add button next to the custom fields. Select Table Calculation. Type Count_Distinct and enter the necessary parameters. Choose a name for the table calculation and select Save. Optionally, select the three dots next to a field and select Count. Check more details in the Looker user guide.
Count All - 返回项目列表的实际项目计数，包括重复项	示例：DUPCount(ProcessName)。 在“函数”选项卡中，搜索“Count All”，然后选择统计函数。	First, select the Add button next to the custom fields. Select Table Calculation. Then select Type Count and enter the necessary parameters. Choose a name for the table calculation and select Save. Optionally, select the three dots next to a field and select Count. Check more details in the Looker documentation.
Case - 根据条件执行结果表达式。如果不满足任何条件，则返回其他条件	搜索“Case”函数，然后从“函数”选项卡中选择该函数。	First, select the Add button next to the custom fields. Select Table Calculation. Then type Case and enter the necessary parameters. Choose a name for the table calculation and select Save. Check more details in the Looker documentation.
Average - 计算平均值	在“函数”选项卡中搜索“Average”，然后将其选中。	First, select the Add button next to the custom fields. Select Table Calculation. Type mean and enter the necessary parameters. Choose a name for the table calculation and select Save. Check more details in the Looker documentation.
全部		不可用
Ceiling - 向上舍入到 1 位数字	在“函数”选项卡中，搜索“Ceiling”，然后选择要引入公式编辑器的函数。	First, select the Add button next to the custom fields. Select Table Calculation. Then type Ceiling and enter the necessary parameters. Choose a name for the table calculation and select Save. Check more details in the Looker documentation.