Let’s say I have a table of users, each one has a name, age and country. I would like to define an expectation that checks that the average age for user in US is between 25 and 30.
In the docs I read that I should prepare an aggregated table that has an average age for a country. But if I want to do this for multiple countries, I would have to create a table like this for each country.
Is there a better way to do this? Like an expectation - there should be a row with country = US and avg_age column between 25 and 30? Is there anything on the GE roadmap to help with these kind of expectations?