You’re right that if you know the exact range of values that a column will have then you would know the exact minimum. But, if there is variation between different batches of data, then it may make more sense to expect the minimum of any given batch to fall in a range. For example, you might expect a minimum transaction value between 0 and 1 dollars if you may have variation inside a day, but you want to ensure there are always small transactions in your data.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| How to set expectation to have a threshold | 5 | 331 | October 18, 2024 | |
| How could I create an expectation to say the time value in a field should be later than some number of hours ago? | 0 | 553 | September 29, 2020 | |
| Expect_column_value_lengths_to_be_between: ERROR SQLSTATE 42704 | 1 | 273 | May 6, 2024 | |
| Evaluate evaluation parameters for data docs | 1 | 504 | October 26, 2020 | |
| Can we combine/chain expectations or use expectations with specific rules depending on values of another column? | 0 | 531 | May 18, 2021 |