Expression optimization

[fenjas72]

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!

[hic]

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

[fenjas72]

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!