New Historical Calculations: Standard Deviation, Variance, Sequential Count
You can now calculate Standard Deviations and Variance for Historical Values. Previously this was not available.
Historical Standard Deviation
You can calculate the historical standard deviation, and include the data entered in today into the calculation (just the same as the historicalmean functionality)
Historical Variance
You can calculate the historical variance, and include the data entered in today into the calculation (just the same as the historicalmean functionality).
Count of Sequential Historical Values that equal a specific value
The function is written as follows:
sequentialhistoricalvaluesthatequal(n, Historical field), where n is the historical value that you are searching for a match for.
For example, sequentialhistoricalvaluesthatequal(1, Historical Mood) searches for sequential matches since today over the historical values
Therefore, if the last 8 entries entered equal 1, then 8 will be returned. However, if 1 has been entered for 2 days, then 2 is entered and 1 is entered for another 4 days, it will only return 4 (the number of recent sequential values that match "n").
0 Comments
Add your comment