Get Last Value each 10 Days

Previous Member
Previous Member
500 Up Votes 500 Likes 500 Comments Second Anniversary
in Platform

Hi everyone,

 

Currently, I had a problem to find a way for getting last value each 10 Days (based on my Aging time). I tried to use Last Value function but didn't work (cause Last Value function characteristic -it won't stop till the time end- ). Is everyone any some suggestions? The example I attached.

 

Thank you.

 

Have a good day!

Answers

  • Björn Reuber
    Björn Reuber Employee, Community Captain
    500 Likes Fourth Anniversary 100 Comments 5 Answers

    Hi,

     

    should work with Yearly cumulated average with a cycle of ten (ok you need to multipoly the value with 10 to get the correct result).

     

    YCV can't work, cause it's starting from the 1.1. of your timerange, and not from the first day of your selection (or within the  element)

     

    My fault, won't work on Last Value, only for Cumulated value.

     

    Regards

    Björn

  • Björn Reuber
    Björn Reuber Employee, Community Captain
    500 Likes Fourth Anniversary 100 Comments 5 Answers
    edited March 2020

    It should be quite simple, you can re-use your first Layout. Just add a 3rd Block with Entity Day:

    image

    This can be used for a "filter"

    image

     

    would lead to this result:

    image

     

    then you can hide the blocks, which arent used

     

    regards

    Björn

  • Previous Member
    Previous Member
    500 Up Votes 500 Likes 500 Comments Second Anniversary

    Hi Björn Reuber Thank you for replying. I'm gonna try..

Categories