Forum Discussion

annag815's avatar
annag815
Frequent Visitor
6 years ago
Solved

Random Sample of Data

Hi, this is my first time posting here so apologies if I am doing something wrong.   I am trying to return a table with a random sample of data. So far I have a new table:  TableWithRand = VA...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    annag815 - Equations that use SWITCH and IF to return different tables tend to fail. Create a variable, MySampleSize that chooses between SampleSize5 and SampleSize. Then use this in a single TOPN function.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

annag815 - Equations that use SWITCH and IF to return different tables tend to fail. Create a variable, MySampleSize that chooses between SampleSize5 and SampleSize. Then use this in a single TOPN function.

  • annag815's avatar
    annag815
    Frequent Visitor
    6 years ago

    Yup that fixed it. Thank you!!!