I'm trying to get the Count of Products but I would need to aggregate it with Date and Account ID fields - is the below expression correct?
Can anyone please help with the expression.
Change to this for the correct syntax:
But I'm not sure if this gets you useful data. It's basically the count of different values of Date and Account_ID. Do you need the count of Products for each Date and Account_ID?
Yes, I would require Count of products for each date and acc_id.