lvd

LVD (Last value date) is a time function in the Function calculator that returns all values registered on the last date on which data was registered, relative to the selected period, in a node on the current organization.

LV is a similar function that returns the last registered value, i.e. only one value.

Syntax

[node,LVD,EOP]

Instead of functions, fixed dates in the format YYYY-MM-DD may be used to specify Start and End, e.g. [node100,2013-01-01,EOP].

Use

The function is often used when the Information period is greater than the data frequency. E.g. where results of a half-yearly survey are to be presented on a monthly basis, you can use the following formula:

[node1, LVD+BM, EOP]

This will find all the values from the month in which the last registration occurred.

Combine LVD with an AGG function to retrieve the last registration date from several organizations. An AGG function like that will search back in time in all organizations specified, and when a value is found it will return all the values found in that period for all organizations. It will not search for the last value in every organization. If no organization is specified, e.g. in an AGG function, only values in the current organization will be included.

Examples:

[100, lvd, lvd] will return all values found on the last date on which data was registered on node [100], relative to the period selected, and only for the current organization.

AGG('[100,lvd,lvd]',100,101) will return all values found on the last date on which data was registered on node [100], relative to the period selected, for organizations 100 and 101.