Ambiguity with firstvalue and lastvalue historical calculations
It was uncovered that there was ambiguity regarding interpretation of the firstvalue and lastvalue calculations
Some users were using last value, as the first value and vice versa. This ambiguity has been addressed and the descriptions clearly state what each calculation will return.
First Value: returns the first ever entered value
Last Value: returns the last entered value (e.g. the most recent)
Firstvalue historical calculation that includes today's data
You can write in historical calculations to include the value entered on that day. The example here shows that the first value ever on all existing data will be returned, or the data point from today will be used (slightly redundant for use with the firstvalue calculation as the first value will only ever be returned).
Last Value including today's data
The image here shows data being entered over a period of a week
YOu can see here that the first ever entered value (first value) will be calculated from the 13th January data; this will return 1.0.
The last ever entered value will change to show the value before the current one (if using lastvalue (Historical Number), or to return the last ever entered value (if using lastvalue(Historical Number, Number). The image in the step below shows the output for each calculation
0 Comments
Add your comment