topic Re: Previous Period's value in the current period. in App Development

Previous Period's value in the current period.

Shahith — Fri, 15 Nov 2024 20:57:34 GMT

Hello,

In the below picture, I have 2 columns, one is Fiscal Period as a Dimension and Claims Count as a measure(both the columns are from the same table).

I need to display the claims count for the period 2024004 as '7'(i.e. 2024003's claim value), and for 2024003 the claim value should be '8' and so on for all the periods.

I got a reply previously for the same question, which is to use the "Above" function, it worked as expected in Chart, but how can I achieve the same in the data load editor?

How can we do that? Any help is greatly appreciated.

Re: Previous Period's value in the current period.

brunobertels — Tue, 28 May 2024 16:25:05 GMT

Have a look to the previous and peek function in the help menu

Peek

Re: Previous Period's value in the current period.

anat — Tue, 28 May 2024 16:36:24 GMT

peek( 'Sales',-1 ) - returns the value of Sales in the previous record read ( equivalent to previous(Sales) ).