Hi all, I’m faced with the following problem: I have a table that has the following columns of importance: orderDate, orderID, userID, userName, orderValue My goal is to find out the bucket in which a user belongs, i.e., a user placed between 5-10 orders in in the current month, 10-15, 15-20, etc…

Hi @rohit_SB You can get your result with the following steps Create a calculated field that uses the Level Aware Calculation to count order by customer [image] Another calculated field for unique Customer Count [image] Create another calculated field that gets you your Bucket groups (so…

Creating "buckets" on Quicksight - Using custom aggregated field as a dimension

Question & Answer

Giridhar.Prabhu October 30, 2024, 10:05am 8

Hi @rohit_SB

Here’s a nice article from @David_Wong. Hope this helps explain things in detail.

Regards,
Giri

2 Likes