# Comparison of data between two time points **URL:** \ **Category:** Kibana\ **Created:** [August 16, 2022, 11:03am UTC](https://discuss.elastic.co/t/comparison-of-data-between-two-time-points/312172 "2022-08-16T11:03:06Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![RonGros](https://avatars.discourse-cdn.com/v4/letter/r/e9a140/32.png) [@RonGros](https://discuss.elastic.co/u/RonGros)\ **Post date:** [August 16, 2022, 11:03am UTC](https://discuss.elastic.co/t/comparison-of-data-between-two-time-points/312172/1 "2022-08-16T11:03:06Z")
Hi, I think the answer is "no can do" but I will ask anyhow in case I am missing something (and if I'm right it's surprising that I'm the only one to need it) We are monitoring results of tests on a daily basis. we have a large number of tests running, and the results keep changing. Now I would like to have a view of the top differences between the results of today and yesterday. The way my data is modeled is that each document is a test with pass/fail and some categorization and the date of running. Currently it seems that you can't mix two dates in a formula, so the only thing you can do is visualization over time, but no way you can show a table with comparison of today vs yesterday. Anything I am missing? ---
**Author:** ![defalt](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/defalt/32/71379_2.png) [@defalt](https://discuss.elastic.co/u/defalt)\ **Post date:** [August 16, 2022, 11:14am UTC](https://discuss.elastic.co/t/comparison-of-data-between-two-time-points/312172/2 "2022-08-16T11:14:29Z")
I am unsure but I think this could come close to it [Tutorial: Create a workpad for monitoring sales | Kibana Guide [8.3] | Elastic](https://www.elastic.co/guide/en/kibana/current/canvas-tutorial.html#_customize_your_data_with_metrics). Never used it myself but allows very specific aggregations. ---
**Author:** ![RonGros](https://avatars.discourse-cdn.com/v4/letter/r/e9a140/32.png) [@RonGros](https://discuss.elastic.co/u/RonGros)\ **Post date:** [August 16, 2022, 2:55pm UTC](https://discuss.elastic.co/t/comparison-of-data-between-two-time-points/312172/3 "2022-08-16T14:55:11Z")
Hi @defalt ! thanks for answering. sadly - it doesn't here is why - and I should have probably explained it initially For me to be able to focus on what's important, the best would have been to find the differences between today's result and yesterday's result. we have thousands of tests, so I would only want to show the diff. So what I thought is doing something like sum(kql='something') - sum(kql='something' shift="1d") and then I could sort by the differences. but that's not possible today.... So how can I do any comparison between 2 different points in time? ---
**Author:** ![defalt](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/defalt/32/71379_2.png) [@defalt](https://discuss.elastic.co/u/defalt)\ **Post date:** [August 17, 2022, 6:39am UTC](https://discuss.elastic.co/t/comparison-of-data-between-two-time-points/312172/4 "2022-08-17T06:39:24Z")
How about: [New to ES/Compare daily data to previous date's data](https://discuss.elastic.co/t/new-to-es-compare-daily-data-to-previous-dates-data/125392)? Does this work? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [September 14, 2022, 6:39am UTC](https://discuss.elastic.co/t/comparison-of-data-between-two-time-points/312172/5 "2022-09-14T06:39:25Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.