# How to create time series bar with site names in y-axis **URL:** \ **Category:** Kibana\ **Created:** [March 18, 2021, 4:10pm UTC](https://discuss.elastic.co/t/how-to-create-time-series-bar-with-site-names-in-y-axis/267700 "2021-03-18T16:10:46Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Dvir\_Alony](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dvir_alony/32/77517_2.png) [@Dvir\_Alony](https://discuss.elastic.co/u/Dvir_Alony)\ **Post date:** [March 18, 2021, 4:10pm UTC](https://discuss.elastic.co/t/how-to-create-time-series-bar-with-site-names-in-y-axis/267700/1 "2021-03-18T16:10:47Z")
Hi, I would like to create time series bar with site names in y-axis. For each site there will be a horizontal line representing the validity of the site with colors (green, yellow, red) according to the relevant time. How can I draw such bar with kibana? TIA, Dvir ---
**Author:** ![Felix\_Roessel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/felix_roessel/32/41623_2.png) [@Felix\_Roessel](https://discuss.elastic.co/u/Felix_Roessel)\ **Post date:** [March 18, 2021, 6:30pm UTC](https://discuss.elastic.co/t/how-to-create-time-series-bar-with-site-names-in-y-axis/267700/2 "2021-03-18T18:30:25Z")
Hello @Dvir_Alony and welcome to the community.. Could you share a picture of what you would like to achieve? ---
**Author:** ![Dvir\_Alony](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dvir_alony/32/77517_2.png) [@Dvir\_Alony](https://discuss.elastic.co/u/Dvir_Alony)\ **Post date:** [March 19, 2021, 1:58pm UTC](https://discuss.elastic.co/t/how-to-create-time-series-bar-with-site-names-in-y-axis/267700/3 "2021-03-19T13:58:29Z")
Hi Felix, Here is what I need in the following png. Tanksj, dvir ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/e/de38bfd91e138b2f57d57b152f588c329fa3a597.png) ---
**Author:** ![Felix\_Roessel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/felix_roessel/32/41623_2.png) [@Felix\_Roessel](https://discuss.elastic.co/u/Felix_Roessel)\ **Post date:** [March 19, 2021, 3:12pm UTC](https://discuss.elastic.co/t/how-to-create-time-series-bar-with-site-names-in-y-axis/267700/4 "2021-03-19T15:12:17Z")
I think the heat map visualization is the closest one. Use terms aggregation on your site name field for y axes, @timestamp for date histogram for x axes and the validy as value. Let me know if this helps. ---
**Author:** ![Dvir\_Alony](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dvir_alony/32/77517_2.png) [@Dvir\_Alony](https://discuss.elastic.co/u/Dvir_Alony)\ **Post date:** [March 20, 2021, 8:07pm UTC](https://discuss.elastic.co/t/how-to-create-time-series-bar-with-site-names-in-y-axis/267700/5 "2021-03-20T20:07:34Z")
I created heatmap according to your suggestion. I have further questuons: 1. For x-axis, the field " Acceptable date formats" is in conflict with the "Show dates" in the main date filter. I would like to select date range using "Show dates". 2,. For Color schema, how can I define my own palette (green, red, yellow) in Options -\> Heatmap settings. ---
**Author:** ![Felix\_Roessel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/felix_roessel/32/41623_2.png) [@Felix\_Roessel](https://discuss.elastic.co/u/Felix_Roessel)\ **Post date:** [March 21, 2021, 7:13am UTC](https://discuss.elastic.co/t/how-to-create-time-series-bar-with-site-names-in-y-axis/267700/6 "2021-03-21T07:13:15Z")
1.) You probably use Date range at the moment. But you need to choose date histogram 2.) Its not possible to add a custom palette. But you can change colors in the legend based on your needs.. ---
**Author:** ![Dvir\_Alony](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dvir_alony/32/77517_2.png) [@Dvir\_Alony](https://discuss.elastic.co/u/Dvir_Alony)\ **Post date:** [March 21, 2021, 8:28am UTC](https://discuss.elastic.co/t/how-to-create-time-series-bar-with-site-names-in-y-axis/267700/7 "2021-03-21T08:28:58Z")
Ok. That works. 10x. 1. Can I control the tooltip and decide what data it will include and to add my own data? 2. Can I filter the "sites" in y-axis by displaying the list of sites and choose sub-list to display (in a convenient way rather using the default "search" filter? 3.If [2] is possible, there is a way to add "Update" button to update the Heatmap according to the site sub-list selection? ---
**Author:** ![Felix\_Roessel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/felix_roessel/32/41623_2.png) [@Felix\_Roessel](https://discuss.elastic.co/u/Felix_Roessel)\ **Post date:** [March 21, 2021, 2:04pm UTC](https://discuss.elastic.co/t/how-to-create-time-series-bar-with-site-names-in-y-axis/267700/8 "2021-03-21T14:04:43Z")
1.) Tooltips can not be changed in heatmap visualizations.. 2.) This works by creating a control visualization and adding both to a single Dashboard. Should be also to Filter by clicking on the values in the heatmap. Any update in the dashboard also leads to a new filter for the heatmap. ---
**Author:** ![Dvir\_Alony](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dvir_alony/32/77517_2.png) [@Dvir\_Alony](https://discuss.elastic.co/u/Dvir_Alony)\ **Post date:** [March 21, 2021, 2:36pm UTC](https://discuss.elastic.co/t/how-to-create-time-series-bar-with-site-names-in-y-axis/267700/9 "2021-03-21T14:36:04Z")
1. Ok. Thanks 2. I created a control visualization and it works but I got 2 messages ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/6/36a751f62d9ebbd9987ad54f50c1244f95e748a2.png) ---
**Author:** ![Felix\_Roessel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/felix_roessel/32/41623_2.png) [@Felix\_Roessel](https://discuss.elastic.co/u/Felix_Roessel)\ **Post date:** [March 21, 2021, 5:08pm UTC](https://discuss.elastic.co/t/how-to-create-time-series-bar-with-site-names-in-y-axis/267700/10 "2021-03-21T17:08:38Z")
In this case its no problem to use this experimental visualization. Experimental means: Of you ever have an issue because of that feature with our support they may take longer to help you. Here is how to change this configuration > [@Controls visualization does show incomplete items](https://discuss.elastic.co/t/controls-visualization-does-show-incomplete-items/198206/2): > > Here it is from the [Configuring Kibana](https://www.elastic.co/guide/en/kibana/current/settings.html) docs: kibana.autocompleteTerminateAfter: Default: "100000" Maximum number of documents loaded by each shard to generate autocomplete suggestions. This value must be a whole number greater than zero. How many different entities has your site name field? ---
**Author:** ![Dvir\_Alony](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dvir_alony/32/77517_2.png) [@Dvir\_Alony](https://discuss.elastic.co/u/Dvir_Alony)\ **Post date:** [March 23, 2021, 1:59pm UTC](https://discuss.elastic.co/t/how-to-create-time-series-bar-with-site-names-in-y-axis/267700/11 "2021-03-23T13:59:48Z")
I have about 2000 entiries. I will configure kibana.autocompleteTerminateAfter to 5000. I works good. Thanks I have another question. I need to set site color horizontal bar from the last sample to the next one. For example, Site\_A color is red at time X and green at time x+2 hours. I need that the Heatmap will drow red color from x to x+2h and green color from x+2h. Currently, the Heatmap drow red color only on time x an no color/white color form x to x+2h. ---
**Author:** ![Dvir\_Alony](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dvir_alony/32/77517_2.png) [@Dvir\_Alony](https://discuss.elastic.co/u/Dvir_Alony)\ **Post date:** [April 1, 2021, 8:46am UTC](https://discuss.elastic.co/t/how-to-create-time-series-bar-with-site-names-in-y-axis/267700/12 "2021-04-01T08:46:23Z")
> [@Dvir\_Alony](#): > > I have another question. I need to set site color horizontal bar from the last sample to the next one. For example, Site\_A color is red at time X and green at time x+2 hours. I need that the Heatmap will drow red color from x to x+2h and green color from x+2h. Currently, the Heatmap drow red color only on time x an no color/white color form x to x+2h. Can you please answer my question - how to spread the color from current sample to the next one where x-axis is the timestamp. ---
**Author:** ![Felix\_Roessel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/felix_roessel/32/41623_2.png) [@Felix\_Roessel](https://discuss.elastic.co/u/Felix_Roessel)\ **Post date:** [April 1, 2021, 4:24pm UTC](https://discuss.elastic.co/t/how-to-create-time-series-bar-with-site-names-in-y-axis/267700/13 "2021-04-01T16:24:41Z")
This is not possible within the visualization configuration. You can 1.) Adapt your data source to have data available that can be visualized Or 2.) Build a vega visualization that is able to remember the value and draw it ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 29, 2021, 4:25pm UTC](https://discuss.elastic.co/t/how-to-create-time-series-bar-with-site-names-in-y-axis/267700/14 "2021-04-29T16:25:34Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.