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 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
@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