Comparing First and last element of a a 10 days range limited dataset

marcoserilio — Thu, 29 Apr 2021 09:00:21 GMT

Hi,

I'm trying to accomplish the following: I've got a dataset made of total market sales per day, I need to get to last day total sales-10 days before total sales, to get to total sales in the last 10 days. Now, I was able to kind of getting to it by using today() function, but my goal to make the report dinamically ever taking into account the last 10 days only, i'd need to use the data field instead.

sum( {<Data={"$(=Date(Max({1}today())-2))"}>}ItaliaG)-

sum( {<Data={"$(=Date(Max({1}today())-14))"}>}ItaliaG)

Re: Comparing First and last element of a a 10 days range limited dataset

marcoserilio — Thu, 29 Apr 2021 09:37:59 GMT

figure it out. Thanks anyway. I have to get rid of " " to make it work

Sum({<ItaliaG={$(=Max(ItaliaG))}>}ItaliaG)-Sum({<ItaliaG={$(=Max(ItaliaG,10))}>}ItaliaG)

topic Comparing First and last element of a a 10 days range limited dataset in App Development

Comparing First and last element of a a 10 days range limited dataset

Re: Comparing First and last element of a a 10 days range limited dataset