Set Analysis a week ago Dynamic

[Anonymous]

Hi

The following expression shows data based on any data for when the roster date=today.

(Count({<

Sickness_SMART.Roster_RosterDate={'$(=Today())'}

>} [Sickness_SMART.Full Name]))

I want to create the same expression for this day last week, but it returns zero.  See below

(Count({<

Sickness_SMART.Roster_RosterDate={'$(=Today()-1)'}

>} [Sickness_SMART.Full Name]))

Any thoughts why it doesn't work

[tresesco · Accepted solution]

Try like: (Count({<Sickness_SMART.Roster_RosterDate={'$(=Date(Today()-7))'} >} [Sickness_SMART.Full Name]))

[pradosh_thakur]

hi

this is why your expression is not working.

1: You have done today()-1 instead of today()-7

2: today()-7 will return you a number not a date

3: Change that number to date by date() function

4: Make sure all your dates are in same format.

The solution is already provided by tresesco  and should work

[Anonymous]

I realised typed 1 on my question, but I meant to type 7. 

Thanks

Phil