Last value function

Options
Unknown
Unknown Active Partner
edited April 2020 in Platform

Hello,

Somebody can explain the behavior of this Last value function?

image

Thank you and best regards

Marcel

Answers

  • Björn Reuber
    Björn Reuber Employee
    Community Captain First Answer First Anniversary 5 Up Votes
    edited March 2020
    Options

    Hi,

     

    SHORT: Last Value: It returns the last value of the series;

    LONG:

    the Last Value funciton "repeats" the last non Zero value (regarding to the time) [keep in mind that board doesnt disinguish between the number zero and NULL, i.e. no value existent ]:

    image

     

    In our example board has very intermittent time series. So board will repeat the last value, until there is a new one.

    Furthermore the "last value" is independent from "time borders" so it won't stop repeating if there is a new year (Cause the old value is still the last valid)

    image

     

    Regards

    Björn

  • Unknown
    Unknown Active Partner
    Options

    Thanks Björn, it's clear.