You can probably do this via aggregate functions used to get mean, total, Standard Deviation type values which you then combine to reproduce the particular statistical formula that you need to do.
But 250 fields in one table suggest that you may be trying to add fields for data recording that should actually be stored as multiple records of a related table instead.
To the best of my knowledge, standard deviation is not really used in time series analysis. The mean average is heavily used in various formats.
I would rather be working with large tables for calculations rather than having to rely on relationships in Filemaker.
But an example is can Filemaker produce a graph trend line? Can the formula or preferably the number used for the graph trend line be further used for calculation of seasonal effects. It is knowing what Filemaker is capable of doing?
1 of 1 people found this helpful
While FileMaker doesn’t have simple features for creating trend lines or performing time series analysis, it is possible to produce some useful results if you’re willing to dig into FileMaker’s calculation engine. You might find the following blog series and accompanying sample file to be helpful.