Percentage Sampling


This transform returns the specified percentage out of the full set of input records using random selection.

Transform - Percentage Sampling
Transform - Percentage Sampling

1. Input

The Percentage Sampling transform requires one input transform that has at least one column.

2. Add the transform

Click to select the connector link between two transforms.

Select the connector link
Select the connector link

In the toolbar, choose Insert Other, then Percentage Sampling.

Adding from the toolbar
Adding from the toolbar

To edit/configure the transform, select it and choose Configure in the toolbar.

Configure the transform
Configure the transform

3. Configure

In the Percentage Sampling transform configuration dialog:

Percentage Sampling transform configuration
Percentage Sampling transform configuration

  1. Set the Sampling Percentage - The percentage of the input records that you want included in the output.
  2. Optionally, set the Random Seed - An arbitrary number no greater than 2,147,483,647, used to used to initialize a pseudorandom number generator. If this is set to zero, the current time is used to randomly determine which records will be sampled; otherwise, the same records will be sampled given the same input data and sampling percentage.
  3. Select the columns to be included in the output.

As with other transforms, these settings can be turned into a parameter to be changed outside of the transform or the data cube (e.g., with a filter on a dashboard) by clicking Define parameters.

4. Output

Submit the configuration dialog, and with the transform selected, open the Data Preview to view the output.

5. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri