How to show values in chart only with in date range?

[#1]

Hi,

I have dimension and expression as below

Dimension: Region

Expression: count(Id)

now I need to show count(Id) only within week. so, the week should be from Last Friday to current Thursday.

for eg: count(id) should show values from 01/05/2015 to 07/05/2015. This should appear for further weeks also. so, if I run report next week it should be from 08/05/2015 to 14/05/2015 and so on.

Please can anyone suggest me how to do this.

EDIT : I have Date field named as EnterDate

Thanks.

[#2]

please can anyone suggest me this

[pokassov]

Hello!

count({$<EnterDate={'>=$(=date(WeekStart(Today(),0,-3)))<=$(=date(WeekEnd(Today(),0,-3)))'}>}Id)

[jonathandienst]

Assuming you mean a rolling 7 days - something like:

Count({<EnterDate = {">=$(=Today()-7)<$(=Today())"}> Id)

[#5]

Thanks. if I want to use expression as dimension how to do this?

so, I need dimension as Week  should show week number as from Last Friday to current Thursday

[pokassov]

The best solution is creating calendar with EnterData and Week name with your constraint...

However you can do something like this:

=aggr(WeekName(WeekStart(EnterDate,0,-3)),EnterDate)