Get Last Value each 10 Days

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!

Find more posts tagged with

Accepted answers

All comments

Björn Reuber

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

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

This can be used for a "filter"

would lead to this result:

then you can hide the blocks, which arent used

regards

Björn

Previous Member

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