Expect a sum of values over the columns to be between max and min values.
expect_multicolumn_sum_values_to_be_between
This expectation level is BETA
Contributors:
@swittchawaTags:
multi-column sum to be between min and maxmulti-column expectation
Metrics:
multicolumn_values.sum_values_to_be_between_max_and_min.unexpected_count
table.row_count
multicolumn_values.sum_values_to_be_between_max_and_min.filtered_row_count
multicolumn_values.sum_values_to_be_between_max_and_min.unexpected_values
Description
Expect a sum of values over the columns to be between max and min values.
min_value <= SUM(col_a, cob_b, cob_c, ...) <= max_value
Args:
- column_list (list of str): A list of 2 or more integer columns
- min_value (int): A value that the sum of values over the column must be equal to or more than the given value
- max_value (int): A value that the sum of values over the column must be equal to or less than the given value
Want to make your own Expectation or an improvement to this one?
We've put together some great how to guides (including videos) on how to create your own expectations in a flash!
You can see those resources here: Contributor Resources
