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.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive