Taking a random sample of rows

Hi All

I'm trying to take a random sample (around 10%) of a list. Not sure exactly how to do this and googling has no answers.

Hi @Ted
I'm not sure if you are looking for LIMIT, which is possible in the UI of Metabase, or if you are looking to get random results (by ordering the table randomly) which would require doing it in SQL (and depends on the database type you're using)
https://stackoverflow.com/questions/8674718/best-way-to-select-random-rows-postgresql

Hi @flamber I was thinking around the lines of using LIMIT, how can i implement it using the UI?

@Ted You can set row limit in the Notebook or clicking the amount of results in bottom-right corner:
https://www.metabase.com/docs/latest/questions/query-builder/introduction#setting-a-row-limit

1 Like