对FileMaker数据集的后三个值进行分析 [英] Perform analysis on last three values of a FileMaker dataset
问题描述
我的最终目标是当FileMaker中最后3条记录输入到字段中时(基于输入时间)达到特定条件(例如方差<2)时,改变框的颜色.我想知道如何做到这一点,或者如何编写计算/脚本以仅查看最后3条记录.
My end goal is to have a box change color when the last 3 records input into a field (based on the time of input) in FileMaker achieve a certain criteria (ex. variance < 2). I would like to know how to make this happen, or how a calculation/script can be written to only look at the last 3 records.
推荐答案
有几种方法可以解决此问题.一种简单的方法是使用脚本:
There are several ways you could approach this. A simple one would be to use a script to:
- 显示给定表中的所有记录;
- 取消排序(假设它们按时间顺序输入;否则按创建时间戳排序);
- 省略除最后三个记录以外的所有记录;
- 获取一个摘要字段的值,该字段定义为您的值字段的标准差;
- 将全局变量/字段设置为返回值的平方.
然后使用全局变量/字段有条件地格式化框".
Then use the global variable/field to conditionally format your "box".
如果您不想使用脚本,则必须定义一个关系才能获取表中的最后三个值,而与当前找到的集和/或排序顺序无关.或者,您可以使用ExecuteSQL()
函数.
If you don't want to use a script, you will have to define a relationship in order to get the last three values in the table, regardless of the current found set and/or sort order. Or you may use the ExecuteSQL()
function for this.
这篇关于对FileMaker数据集的后三个值进行分析的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!