I have a list of 200 users that I want to display in alphabetically order all on one dashboard. However because they can't nicely display on the dashboard as 1 list, I want to split that list into 4 distinct lists and each 50 users in length and display them side by side on the dashboards.
So I want to sort the list alphabetically by User name and create four lists
Users 1-50
Users 51-100
Users 101-150
Users 150-End
Example TABLE 1
Name | Score
A | 1
B | 1
C | 4
D | 10
E | 12
F | 22
G | 12
H | 19
I | 4
J | 6
K | 5
L | 11
I know how to generate the first list by sorting alphabetically using row limit 50 but how to generate the other 3?
Why wouldn't a regular table visualization work to display the 200 records? You can page through the records with the button on the bottom right for paging through the records.
If you really want to break them up you could use a SQL question to create the separate list. In Postgres, for example, you could do something like this:
WITH numbered_users AS (
SELECT
Name,
Score,
ROW_NUMBER() OVER (ORDER BY Name) AS row_num
FROM
your_table_name
),
grouped_users AS (
SELECT
Name,
Score,
CASE
WHEN row_num <= 50 THEN 'Users 1-50'
WHEN row_num <= 100 THEN 'Users 51-100'
WHEN row_num <= 150 THEN 'Users 101-150'
ELSE 'Users 151-End'
END AS group_name
FROM
numbered_users
)
SELECT
group_name,
Name,
Score
FROM
grouped_users
ORDER BY
group_name,
Name;