Finding maximum value of previous week

freceena — Sat, 16 Nov 2024 01:11:47 GMT

I want to calculate the difference between max(particular week for eg. week 21) - max(previous week for eg. week 20). I tried the following expression in expression editor :

max([Counter])-max({$<Date={">=$(=Date(WeekStart(Max([Date of Measurement]),-1, 0),'DD-MM-YYYY'))<=$(=Date(WeekEnd(Max([Date of Measurement]),-1, 0),'DD-MM-YYYY'))"}>}[Counter])

Could anyone please help me on this?

Re: Finding maximum value of previous week

MayilVahanan — Mon, 02 Nov 2020 05:13:25 GMT

Hi @freceena

max([Counter])-max({$<Date={">=$(=Date(WeekStart(Max([Date of Measurement]),-1, 0),'DD-MM-YYYY'))<=$(=Date(WeekEnd(Max([Date of Measurement]),-1, 0),'DD-MM-YYYY'))"},Year=,Week=,Month=>}[Counter])

Your expression looks correct , just need to exclude the Time filter in the expression.

topic Re: Finding maximum value of previous week in App Development

Finding maximum value of previous week

Re: Finding maximum value of previous week