Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have been trying to make a count of customers who make 3 or more orders per week
dimension - weekend(OrderDate)
Measure - count(aggr(if(count(distinct OrderID)>3,1), CustomerID))
this works when you select the week ending date, but when you unselected it , over counts the totals
for e.g week I get on the continuous chart 1,035, when I select the week, I get 6 which is the correct number
please help
Try this Expression.
Count({<CustomerID = {'=Count(Distinct OrderID) >3'}>}CustomerID)
Regards,
Kaushik Solanki
Hi
sorry this do not work
any more ideas please?
Kind Regards
Hi,
add a distinct :
Count(distinct {<CustomerID = {'=Count(Distinct OrderID) >3'}>}CustomerID)
Hi
still no joy
its the same issue
that's why I even tried using the aggr function
any more ideas?
Kind Regards