Random Row Index
Description
A random index assigned to each row, often used for random sampling or shuffling data.
Calculation Editor
Options
| Input Parameter Values | Input Values |
|---|---|
| Mode | All, Threshold or less, Threshold percent or less |
| Threshold | Column or Literal (Default is 0) |
Remarks
- Mode: Indicates the amount of records (rows) in the report that will receive a Random Row Index that's not zero.
- Threshold: Threshold is only relevant when Mode is not set to All.
- When Mode is set to Threshold or less and Threshold is set to "20", only 20 randomly selected rows will receive a number (1 - 20) while the rest of the records will receive a 0.
- When Mode is set to Threshold Percent or less and Threshold is set to "20", only 20% of the total number of records will receive a number while the rest of the records receive 0.