How to aggregate ranked data?

I have a use case where I need to group the data and display it as a visual after providing ranks.
But quicksight converts ranks into a custom field and doesn’t allow me to group the ranked field even though it consists only of integers. Is there any workaround to fix this issue?

Can you give an example of what you are looking for?

I have 3 fields (Dates, Users[string])
I want to get the first instance of each user and then group the number of users in each month indicating the number of users that were onboarded this month.

I’m not able to group the first occurrences since we can’t club custom fields in quicksight

It seems as though you would need to partition by Users so you will need to show users in your visual if you use a calculated field.

The only way to get around this is to use custom sql instead of a calculated field.