# Bar chart comparison of count for today and yesterday
**URL:** https://discuss.elastic.co/t/bar-chart-comparison-of-count-for-today-and-yesterday/344687
**Category:** Kibana
**Tags:** lens
**Created:** [October 9, 2023, 6:37pm UTC](https://discuss.elastic.co/t/bar-chart-comparison-of-count-for-today-and-yesterday/344687 "2023-10-09T18:37:49Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Jason\_Paralta](https://discuss.elastic.co/u/Jason_Paralta)
#### Post date: [October 9, 2023, 6:37pm UTC](https://discuss.elastic.co/t/bar-chart-comparison-of-count-for-today-and-yesterday/344687/1 "2023-10-09T18:37:49Z")
Hello,
I have 3 different regions namely US,APAC and EMEA based licennse. Now I have index with below field:
us.region.license.inuse, apac.region.license.inuse and emea.region.license.inuse and now I want to make bar chart showing sum of inuse count of today and yesterday only for comparison in single bar visual for diffrent regions. How can I do this visual?
Thanx
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [October 9, 2023, 7:38pm UTC](https://discuss.elastic.co/t/bar-chart-comparison-of-count-for-today-and-yesterday/344687/2 "2023-10-09T19:38:59Z")
What version of Elastic / Kibana
Absolutely can use comparison, difference, shift etc with Lens
> **[Analyze time series data | Kibana Guide \[8.10\] | Elastic](https://www.elastic.co/guide/en/kibana/current/create-a-dashboard-of-panels-with-ecommerce-data.html#compare-time-ranges)**
---
### Author:  [@Jason\_Paralta](https://discuss.elastic.co/u/Jason_Paralta)
#### Post date: [October 10, 2023, 7:48am UTC](https://discuss.elastic.co/t/bar-chart-comparison-of-count-for-today-and-yesterday/344687/3 "2023-10-10T07:48:57Z")
Hello @stephenb
I am using 8.8 version and unable to understand proper way to make visual. I am aware of shift='1d",but still in single graph how can I compare today and yesterday count for different license zones?
---
### Author:  [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)
#### Post date: [October 10, 2023, 8:18am UTC](https://discuss.elastic.co/t/bar-chart-comparison-of-count-for-today-and-yesterday/344687/4 "2023-10-10T08:18:03Z")
Is your problem related to time zones of the different areas?
---
### Author:  [@Jason\_Paralta](https://discuss.elastic.co/u/Jason_Paralta)
#### Post date: [October 10, 2023, 8:31am UTC](https://discuss.elastic.co/t/bar-chart-comparison-of-count-for-today-and-yesterday/344687/5 "2023-10-10T08:31:00Z")
Nope, its not related to timezone.
Consider different products for different zones being sold and has been asked to make comparison graph showing sum of product.inuse for today and yesterday for 3 different zone in single graph as bar.This is just an example to explain.
My very first comment is my requirement, there I have mentioned available fields as well.
My document contains fields as-:
license.us.region.name:abc, us.region.license.inuse: 13
license.us.region.name:xyz, us.region.license.inuse: 12
license.emea.region.name:abc, emea.region.license.inuse: 11
license.emea.region.name:xyz, emea.region.license.inuse: 8
---
### Author:  [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)
#### Post date: [October 10, 2023, 10:19am UTC](https://discuss.elastic.co/t/bar-chart-comparison-of-count-for-today-and-yesterday/344687/6 "2023-10-10T10:19:53Z")
I've tried to put together an example with the Flights sample data. Is it something like that:
Mind that if you are going to go for this route I can suggest to use `Filters` rather than `Top values`, as it is possible to face scenarios where for region X there's no today/yesterday value (what is Top 10 today might not be the same for yesterday. With Filters it enforces specific values to appear).
---
### Author:  [@Jason\_Paralta](https://discuss.elastic.co/u/Jason_Paralta)
#### Post date: [October 12, 2023, 2:25pm UTC](https://discuss.elastic.co/t/bar-chart-comparison-of-count-for-today-and-yesterday/344687/7 "2023-10-12T14:25:28Z")
Hello @Marco_Liberati ,
Thanx for looking into this. This is helpful. I just want to know how you are managing the dates to be shown in horizontal axis for today and yesterday. I would like to do comparison of todays date count with yesterday date count.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [November 9, 2023, 2:25pm UTC](https://discuss.elastic.co/t/bar-chart-comparison-of-count-for-today-and-yesterday/344687/8 "2023-11-09T14:25:36Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.