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
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 57 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive