Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have fields Owner, CustomerId, EnterDate. Based on this EnterDate I need to calculate count(CustomerId)
I,e
Dimension: Owner
Expression: Count(CustomerId) when EnterDate between last monday to current Monday I,e from 08/09/2014 to 15/09/2014
Can anyone please help me with expression. As I can see this with selection of list box but user don't want to select in list box.
Thanks.
=SUM({<[Invoice Date] = {'>=$(=Date(WeekStart(Today())-7))<=$(=Date(WeekStart(Today())))'}>}Amount)
1) Change FieldName Accordingly
2) Also, if instead of Today(), you want Previous Week Monday to Selected Date Monday,
Replace Today() with Max([Invoice Date])
=SUM({<[Invoice Date] = {'>=$(=Date(WeekStart(Today())-7))<=$(=Date(WeekStart(Today())))'}>}Amount)
1) Change FieldName Accordingly
2) Also, if instead of Today(), you want Previous Week Monday to Selected Date Monday,
Replace Today() with Max([Invoice Date])
hi
try this
=count({<EnterDate = {'>=$(=Date(WeekStart(Today())-7))<=$(=Date(WeekStart(Today())))'}>}CustomerId)
I have used SUM(Amout).... as Vishwaranjan said, you can change as COUNT(CustomerID)
Thanks.
Thanks
How can I change the same expression if I want to include the same condition but with
CustomerStatus='Fail1'
Please help
=COUNT({<CustomerStatus = {'Fail1'},[Invoice Date] = {'>=$(=Date(WeekStart(Today())-7))<=$(=Date(WeekStart(Today())))'}>}CustomerId)
Great Thanks.