Sample

Sample pulls a portion of data from a tool based on rules.

Sample offers the ability to view and use a subset of your dataset. You can select this subset of your data using any of the options below.

Input/Output

Inputs	Outputs
Select Rules - rules to choose from for sample Value, N - N value in rules descriptions (number) Group By (optional) - column(s) to group by in table. N rows are returned for each group	Table with a subset of the data from your original input dataset. You can select this subset of your data using any of the options below.

Options

Option	Description
First N rows	Returns every row in the data from the beginning of the data through row N.
Last N rows	Returns the last N rows of the data.
Skip first N rows	Returns all rows in the data starting after row N.
1 every N rows	Returns the first row of every group of N rows.
First N% rows	Returns N percent of rows.

You also have the option to use a groupby that will apply the above rules to each group or rows in the groupby.

Example

Let's say we have a list of baseball players that we want to use a sample of:

We only want to see the first 5 players in the list. So we use the First N rows and set N = 5We get the following result:

Example 2

Now we want to only use the first 20% emails in the list. So we use the First N% rows and set N = 20We get the following result: