Documentation

+

K

API Reference ↗Send feedback

Data connectivity & integrationPipeline Builder TransformsNumeric distribution

Numeric distribution

Supported in: Batch

Computes the distribution of numeric values in a specified column.

Transform categories: Numeric

Declared arguments

Bucket count - Number of buckets to distribute over.
Literal<Long>
Column - Column to compute distribution for.
Column<Numeric>
Dataset - Dataset to apply distribution to.
Table
Maximum value - Maximum value for distribution.
Literal<Double>
Minimum value - Minimum value for distribution.
Literal<Double>

Examples

Example 1: Base case

Argument values:

Bucket count: 10
Column: value
Dataset: ri.foundry.main.dataset.a
Maximum value: 20.0
Minimum value: 0.0

Input:

value
0.0
0.0
1.3
5.3
10.5

Output:

bucket	min_value	max_value	count	bucket_start	bucket_end
0	0.0	1.3	3	0.0	2.0
2	5.3	5.3	1	4.0	6.0
5	10.5	10.5	1	10.0	12.0

Example 2: Base case

Argument values:

Bucket count: 3
Column: value
Dataset: ri.foundry.main.dataset.a
Maximum value: 25.0
Minimum value: -5.0

Input:

value
-15
-5
0
15
20

Output:

bucket	min_value	max_value	count	bucket_start	bucket_end
0	-5	0	2	-5.0	5.0
2	15	20	2	15.0	25.0

Example 3: Edge case

Argument values:

Bucket count: 1
Column: value
Dataset: ri.foundry.main.dataset.a
Maximum value: 20.0
Minimum value: 20.0

Input:

value
-15
-5
0
15
20

Output:

bucket	min_value	max_value	count	bucket_start	bucket_end
0	20	20	1	20.0	20.0

Example 4: Edge case

Argument values:

Bucket count: 1
Column: value
Dataset: ri.foundry.main.dataset.a
Maximum value: 20.0
Minimum value: -5.0

Input:

value
-15
-5
0
15
20

Output:

bucket	min_value	max_value	count	bucket_start	bucket_end
0	-5	15	3	-5.0	20.0
1	20	20	1	20.0	45.0