# How to solve Timelion Error: in cell #1: Unable to pairwise reduce seriesLists, number of series are not the same **URL:** \ **Category:** Kibana\ **Tags:** timelion\ **Created:** [February 28, 2019, 12:06pm UTC](https://discuss.elastic.co/t/how-to-solve-timelion-error-in-cell-1-unable-to-pairwise-reduce-serieslists-number-of-series-are-not-the-same/170334 "2019-02-28T12:06:02Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Ido\_PX](https://avatars.discourse-cdn.com/v4/letter/i/ecae2f/32.png) [@Ido\_PX](https://discuss.elastic.co/u/Ido_PX)\ **Post date:** [February 28, 2019, 12:06pm UTC](https://discuss.elastic.co/t/how-to-solve-timelion-error-in-cell-1-unable-to-pairwise-reduce-serieslists-number-of-series-are-not-the-same/170334/1 "2019-02-28T12:06:03Z")
Hi, I'm trying to divide two split series. Splitting by the same exact term with the same number of splits in both, however the query is a bit different, which if I understand correctly, yields different splits which then don't match. The query is as follows: `.es(q = 'TR:CR AND CV:true', split = account_name:10).divide(.es(q = 'TR:CR AND AT:B', split = account_name:10))` Note the query in the numerator and the query in the denomenator are different, however the split condition is the same. account\_name potentially has hundreds of values so I prefer not to repeat this by hand. Note also each query works on it's own. I get the following error: `Error: in cell #1: Unable to pairwise reduce seriesLists, number of series are not the same` Is it possible to: 1. Specify the split values so they match in each case. 2. Do some kind of join on the splits, so that even though they don't match, I can take the account\_name values in the numerator or the denomenator. 3. Split the result of the division. Any of these solutions would work for me, but I wasn't able to find a way to do any of them. ---
**Author:** ![Ido\_PX](https://avatars.discourse-cdn.com/v4/letter/i/ecae2f/32.png) [@Ido\_PX](https://discuss.elastic.co/u/Ido_PX)\ **Post date:** [March 5, 2019, 2:31pm UTC](https://discuss.elastic.co/t/how-to-solve-timelion-error-in-cell-1-unable-to-pairwise-reduce-serieslists-number-of-series-are-not-the-same/170334/2 "2019-03-05T14:31:29Z")
Anyone? ---
**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\ **Post date:** [March 5, 2019, 8:13pm UTC](https://discuss.elastic.co/t/how-to-solve-timelion-error-in-cell-1-unable-to-pairwise-reduce-serieslists-number-of-series-are-not-the-same/170334/3 "2019-03-05T20:13:48Z")
> however the query is a bit different, which if I understand correctly, yields different splits which then don't match You are correct, the different queries are returning different results so the splits do not line up and can not be reduced. There is no way around this but you can open an enhancement request at [Sign in to GitHub ยท GitHub](https://github.com/elastic/kibana/issues/new?template=Feature_request.md) ---
**Author:** ![Ido\_PX](https://avatars.discourse-cdn.com/v4/letter/i/ecae2f/32.png) [@Ido\_PX](https://discuss.elastic.co/u/Ido_PX)\ **Post date:** [March 6, 2019, 9:47am UTC](https://discuss.elastic.co/t/how-to-solve-timelion-error-in-cell-1-unable-to-pairwise-reduce-serieslists-number-of-series-are-not-the-same/170334/4 "2019-03-06T09:47:05Z")
Ok, done. > ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 3, 2019, 9:47am UTC](https://discuss.elastic.co/t/how-to-solve-timelion-error-in-cell-1-unable-to-pairwise-reduce-serieslists-number-of-series-are-not-the-same/170334/5 "2019-04-03T09:47:15Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.