Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=Count({<Date={">=$(=Date(WeekStart(Today())-7))<=$(Date(WeekEnd(Today())-7))"},Tailors={'Open','open'}>}ID)
Change 7 to 8 as per your date requirements...
Thanks. I tried it. It is showing count more when compared to database records.
Use Distinct ID
Hi
Try some thing like this
=Count( DISTINCT {<Date={">=$(=Date(floor((WeekStart(Today())-7)))<=$(Date(floor(WeekEnd(Today())-7)))"},
Tailors={'Open','open'}>}ID)
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.
Thanks. tried. showing all blank values. do I need to change anything?
The expression was missing an = sign:
Count({<Date={">=$(=Date(WeekStart(Today(1))-7)) <=$(=Date(WeekEnd(Today(1))-7))"}, Tailors={'Open','open'}>} ID)
Jonathan
Thanks. near to result. getting extra 4 values. Actually the count is 460. but it is showing 464. Any change please.
Provide sample data