Expand all | Collapse all

Random Sample

  • 1.  Random Sample

    Posted 09-19-2019 17:55
    Hi does anyone know if there is a way to have QB pull a random sample from a table of data?

    Sheri W

  • 2.  RE: Random Sample

    Posted 09-19-2019 18:30
    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

  • 3.  RE: Random Sample

    Posted 09-19-2019 18:34
    Hi Mark,  Thanks!  I'll give it  a shot.

    Sheri W

  • 4.  RE: Random Sample

    Posted 01-23-2020 12:49
    What if I wanted a random sample of 76 drawn per week, and of course, items chosen previously would not be chosen again?  This is out of potentially thousands that may change from week to week.

    Paul Saylor