Quicksight distribute and assign count of rows equally among list of logins provided

Q&A
, , ,
1

I want to distribute rows among no. of logins user has provided.
for ex let;'s say number of logins are 5 and count of rows are 12904. I want to assign these no.of logins to these 12904 distributed equally if there count of rows is not divisble by no.of logins divide the remaining rows equally started with 1st login then 2nd and then 3rd and lastly 4th if possible.

just like this excel

image
image224×824 3.43 KB

1 Like
2

Hello @atulrana, this sounds like something you would want to complete either in your database or with custom SQL in Quick Sight at the dataset level. While there are definitely some functions in Quick Sight to manage calculations at a group or partition level, you need to manage data transformations in SQL.

I’ll include some documentation for utilizing SQL to customize data in Quick Sight.

Let me know if you have any further questions. Thank you!

1 Like
3

Thanks man, you can mark it as closed!

1 Like