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
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").