Skip to main content
Question

Random Sample

  • September 19, 2019
  • 0 replies
  • 133 views

Hi does anyone know if there is a way to have QB pull a random sample from a table of data?

------------------------------
Sheri W
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • September 19, 2019
Typically this is done by taking every nth record based on the Record ID# and that is done using the REM function.  can you give me a specific example of the sample that you want to pull.  It is like 10% of the records or do you need 200 random samples.

Do you need the samples restricted to a certain time period?

For a quick answer, if you wanted every 20th record, it would be where

REM([Record ID#], 20) = 0.


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------