# Multi Batch expectations?

**URL:** <https://discourse.greatexpectations.io/t/multi-batch-expectations/625>\
**Category:** Archive\
**Created:** [February 14, 2021, 10:43am UTC](https://discourse.greatexpectations.io/t/multi-batch-expectations/625 "2021-02-14T10:43:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![omribromberg](https://avatars.discourse-cdn.com/v4/letter/o/74df32/32.png) [@omribromberg](https://discourse.greatexpectations.io/u/omribromberg)\
**Post date:** [February 14, 2021, 10:43am UTC](https://discourse.greatexpectations.io/t/multi-batch-expectations/625/1 "2021-02-14T10:43:27Z")

</div>

Hey guys I’m generally new to GE, seen a bunch of webinars and read the docs, my problem is trying to compare metrics between 2 different tables (yesterday’s and today’s data), for example:

- distinct values diff on a column
- the null % of a column between tables
- and basically any other result such as X% values were out of [range,set]

would be great if someone could help to shed some light on that, I’ve seen a reference to something called “multi-batch” but couldnt really get that to work

---

<div class="post-metadata">

**Author:** ![eugene.mandel](https://yyz1.discourse-cdn.com/flex031/user_avatar/discourse.greatexpectations.io/eugene.mandel/32/22_2.png) [@eugene.mandel](https://discourse.greatexpectations.io/u/eugene.mandel)\
**Post date:** [February 19, 2021, 10:23pm UTC](https://discourse.greatexpectations.io/t/multi-batch-expectations/625/2 "2021-02-19T22:23:19Z")

</div>

Multi-batch Expectations are on our roadmap, but are not implemented yet. Once they exist, it will be possible to express tests like this one: if you have a table of invoices, you can test if the number of invoices today was within x% of the mean count of the last 10 days.

Your case might be possible without waiting for multi-batch. If you are comparing two tables, check out the write-up of a workflow that does it:

> [@How to compare two tables with the UserConfigurableProfiler](https://discourse.greatexpectations.io/t/how-to-compare-two-tables-with-the-userconfigurableprofiler/618):
>
> Comparing two tables with the user\_configurable\_profiler With this workflow, we will use GE’s user\_configurable\_profiler to gauge whether two tables are identical. The workflow is as follows: General GE set-up Creating a suite from the source data Set up a batch for your source data - this is the data that you trust to be correct Instantiate a profiler and run the build\_suite method to build a suite from your source data Validating your migrated data with your suite Set up a batch…