How to get data with in date range?

[#1]

Hi,

I have table with below details

Dimension: Member

Expression: =Count({<Date={">=$(WeekStart(today())-7))<=$(Weekend(today())-8)"},Tailors={'Open','open'}>}ID)

The data should show the count of ID between 23/06/2014 and 27/06/2014 for open tailors. The table is showing incorrect data. Can anyone suggest me do I need to make any changes in expression?

Thanks.

[MK_QSL]

=Count({<Date={">=$(=Date(WeekStart(Today())-7))<=$(Date(WeekEnd(Today())-7))"},Tailors={'Open','open'}>}ID)

Change 7 to 8 as per your date requirements...

[#3]

Thanks. I tried it. It is showing count more when compared to database records.

[MK_QSL]

Use Distinct ID

[sasikanth]

Hi

Try some thing like this

=Count( DISTINCT {<Date={">=$(=Date(floor((WeekStart(Today())-7)))<=$(Date(floor(WeekEnd(Today())-7)))"},

Tailors={'Open','open'}>}ID)

[#6]

Same count getting. I created two variables from and to

From = =WeekStart(today()-7)

To= =Date(WeekEnd(today()-5)-1,'DD/MM/YYYY')

I used button 'Apply' with these and the data is showing correct.

But I would need to show the data with expression instead of variables. Is that possible?

Thanks.

[#7]

Thanks. tried. showing all blank values. do I need to change anything?

[jonathandienst]

The expression was missing an = sign:

Count({<Date={">=$(=Date(WeekStart(Today(1))-7)) <=$(=Date(WeekEnd(Today(1))-7))"}, Tailors={'Open','open'}>} ID)

Jonathan

[#9]

Thanks. near to result. getting extra 4 values. Actually the count is 460. but it is showing 464. Any change please.

[MK_QSL]

Provide sample data