Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Scenario
customers may place more then 1 order in a day for same products
Question
I want to know the count of those orders which contains same product and same customer name and same date.
Data Model (is not normalised) contains following fields :
I hope I have explained the scenario properly.
Thanks
Not sure though, may be like this -
Dimension - Date, Customer Name, Product
Expression - If(Count(OrderID>1,Count(OrderID))
Thanks.. I will update you on how it goes.