topic Expression optimization in App Development

Expression optimization

fenjas72 — Wed, 18 Sep 2024 13:02:05 GMT

Hi,

I'm using the following expression to select 7 days for the given field. I am relatively new to expressions and was wondering if there's a neater way to do this:

='$(=date(Max({1} Total [Placed Bet Date])-6));' &
'$(=date(Max({1} Total [Placed Bet Date])-5));' &
'$(=date(Max({1} Total [Placed Bet Date])-4));' &
'$(=date(Max({1} Total [Placed Bet Date])-3));' &
'$(=date(Max({1} Total [Placed Bet Date])-2));' &
'$(=date(Max({1} Total [Placed Bet Date])-1));' &
'$(=date(Max({1} Total [Placed Bet Date])))'

Thanks!

Re: Expression optimization

hic — Thu, 19 Sep 2024 14:06:52 GMT

Try
>=$(=date(Max({1} Total [Placed Bet Date])-6))

Re: Expression optimization

fenjas72 — Tue, 24 Sep 2024 14:08:39 GMT

Hi,

In hindsight, your solution makes perfect sense however, even though it evaluates correctly, no selections are made.

It seems that the only way to set selections is to pass values as a comma-delimited string. I'm using a sheet action as follows:

Thanks!