Set Analysis - last 7 days

[Giselle100]

Hi All

i have this expression 

Count({<[DBN Status ID No]={12}>}distinct [Order No] ) 

I need it to only return the last weeks data. So [In Branch Date] from today and 7days back.

[albert_guito]

Try with

Count({<[DBN Status ID No]={12}, [In Branch Date] ={">=$(=Today()-7)"}>} distinct [Order No] ) 

Ag+

[Giselle100]

It's returning a zero value.

[sunny_talwar]

What is your in branch date field format? May be you need to add that to your set analysis as set analysis is format sensitive.... something like this

Count({<[DBN Status ID No] = {12}, [In Branch Date] ={">=$(=Date(Today()-7, 'DD-MM-YYYY'))"}>} DISTINCT [Order No])

DD-MM-YYYY was an example... make sure to use the format that you have In Branch Date stored as in your dashboard.