Random Sample from Population already in Domo
I am interested in running experiments with dataset(s) already in domo but want to be able to sample, is there now or are there plans for a way to randomise cases in one or more datasets in domo to build a sample set to run projections on?
Preferably Random/Stratafied random sampling.
Has anyone found a way to mimic the rand function in excel to make sampling possible?
Comments
-
Lauren,
You can use the RAND MySQL function if you use a SQL transform.
The basic version of your sampling query would look like this:
SELECT * FROM dataset
ORDER BY RAND()
LIMIT 10Just increase the LIMIT to whatever size of sample you want and rerun the data transform each time you want new data.
Hopefully that's what you're looking for,
ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0 -
Hi,
I also want to use the RAND() Function in MySQL to pick ten random records per partition in the table. I have created partitions thorugh windowed ranking. I am not sure how to pick ten records from each partition (ex: if there are 5 partitions, I need the query to return 50 random rows). Can you help me with this?
Fatima
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive