Well, I have a scenario , where I have to show the count of current month active product in a locale which have a rating above 4.3 across all the months aggregated over market.
So For Ex - So suppose there is a product A which is active in the Locale CA and TX for october under north America and in active under any locale in north america , so we need to take their rating sum and reviews and calculate their rating and if rating is greater than 4.3 , we would take the count as 1 for whole NA for that product. This product locale combination can be active under any other month as well, so i have to check in other months as well with the same condition and if it satisfies I have to show that count rolled in october month only. so basically it's a accumulated sum.
Below is my expression - It checks the prod locale key , but while aggregating as I'm have to do it on the product id, market level it only takes the product and aggregates over all the locale and gives me the count. so I'm getting some extra numbers. Can any one help me ?