I have a dataset with a field as Order Country. It has field values as 'AUS', 'USA', 'GBR', 'IND', 'KEN', etc.
Now, is there any way to bucket these values as
bucket 1: 'AUS', 'USA', 'GBR' - Total id count of these three countries
bucket 2: 'USA', 'GBR', 'IND', 'KEN' - Total id count of these Four countries
bucket 3: 'KEN', 'AUS', 'IND' - Total id count of these three countries
Please suggest
Best Answer
Basically you have 2 options:
Then create subqueries to count
And finally union or cogroup the suqueries back together, depending on what you want to do with these numbers.
Hope that helps!