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

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

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

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

E-Mail me when someone replies to this comment