# Stacked bar graph **URL:** \ **Category:** Kibana\ **Tags:** lens\ **Created:** [August 21, 2023, 7:04am UTC](https://discuss.elastic.co/t/stacked-bar-graph/341203 "2023-08-21T07:04:52Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Neelam\_Zanvar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/neelam_zanvar/32/103116_2.png) [@Neelam\_Zanvar](https://discuss.elastic.co/u/Neelam_Zanvar)\ **Post date:** [August 21, 2023, 7:04am UTC](https://discuss.elastic.co/t/stacked-bar-graph/341203/1 "2023-08-21T07:04:52Z")
Hi i am working on a stacked bar graph, ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/0/f04a0177ce3742fbedb2c496737ddb1ddb4ba898.png) As shown in the image, on x axis i have time on y i have sum of bytes and breakdown by service name. so basically in logs in every entry there is a service name, bytes and time and duration. Is it possible to add the sum of duration and sum of bytes for a service in a single bar? ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/1/81a741243d7f1c68c5bc2e1c798e8e8b13ee8743.png) as shown in the image after i add sum of duration as separate field on y axis it is creating multiple entry for every service e.g. 3dpassport-sum of bytes 3dpassport-sum of duration. Is there anyway to display 3dpassport: 4B 4ms? something n this way ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [August 21, 2023, 1:18pm UTC](https://discuss.elastic.co/t/stacked-bar-graph/341203/2 "2023-08-21T13:18:51Z")
Hi @Neelam_Zanvar not sure I follow what you are looking for. Maybe you want to divide the sum of bytes by the sum of duration (ie. in Lens formula: `sum(bytes) / sum(duration)`)? Or something else? ---
**Author:** ![Neelam\_Zanvar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/neelam_zanvar/32/103116_2.png) [@Neelam\_Zanvar](https://discuss.elastic.co/u/Neelam_Zanvar)\ **Post date:** [August 22, 2023, 5:09am UTC](https://discuss.elastic.co/t/stacked-bar-graph/341203/3 "2023-08-22T05:09:11Z")
no i dont want to divide it. i want the sum of bytes and sum of duration both separately to be seen on every bar ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/c/3ce57a3507eb9ba2a3ea5b6114410f4fa4d1ae89.png) something like dis sum of bytes and sum of duration for that service at that minute ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [August 22, 2023, 10:17am UTC](https://discuss.elastic.co/t/stacked-bar-graph/341203/4 "2023-08-22T10:17:10Z")
No, that is not possible in Lens. Would a table work better for this type of visualization? You could color encode each sum of bytes cell there and show alongside the sum of duration as well. ---
**Author:** ![Neelam\_Zanvar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/neelam_zanvar/32/103116_2.png) [@Neelam\_Zanvar](https://discuss.elastic.co/u/Neelam_Zanvar)\ **Post date:** [August 22, 2023, 10:21am UTC](https://discuss.elastic.co/t/stacked-bar-graph/341203/5 "2023-08-22T10:21:48Z")
No, looking for a graphical visualization like this. is it not possible to add a formula in the graph which concatenates sum(bytes) and sum(duration) ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [August 22, 2023, 10:28am UTC](https://discuss.elastic.co/t/stacked-bar-graph/341203/6 "2023-08-22T10:28:20Z")
No, that is not just a formula, rather a different encoding for one of the dimension (sum of duration) as label only, while the other one (sum of bytes) has to be rendered as stacked bar + label. ---
**Author:** ![Neelam\_Zanvar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/neelam_zanvar/32/103116_2.png) [@Neelam\_Zanvar](https://discuss.elastic.co/u/Neelam_Zanvar)\ **Post date:** [August 22, 2023, 10:33am UTC](https://discuss.elastic.co/t/stacked-bar-graph/341203/7 "2023-08-22T10:33:26Z")
sorry, but I didn't get you! How can I do that? ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [August 22, 2023, 10:46am UTC](https://discuss.elastic.co/t/stacked-bar-graph/341203/8 "2023-08-22T10:46:22Z")
It is not possible. Just explaining that why formula would not work. ---
**Author:** ![Neelam\_Zanvar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/neelam_zanvar/32/103116_2.png) [@Neelam\_Zanvar](https://discuss.elastic.co/u/Neelam_Zanvar)\ **Post date:** [August 22, 2023, 10:48am UTC](https://discuss.elastic.co/t/stacked-bar-graph/341203/9 "2023-08-22T10:48:58Z")
ok, is there any visualization other than table? i want a graphical visualization. for every minute i want to see the sum of bytes transferred and duration for each service ---
**Author:** ![Neelam\_Zanvar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/neelam_zanvar/32/103116_2.png) [@Neelam\_Zanvar](https://discuss.elastic.co/u/Neelam_Zanvar)\ **Post date:** [August 22, 2023, 10:49am UTC](https://discuss.elastic.co/t/stacked-bar-graph/341203/10 "2023-08-22T10:49:41Z")
annotation is somewhat doing it. but i am not able to access all entries. nor sort them in descending order ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [August 22, 2023, 1:25pm UTC](https://discuss.elastic.co/t/stacked-bar-graph/341203/11 "2023-08-22T13:25:14Z")
Other than having a side by side charts on a dashboard (which syncs the cursors position on hover) something like this is what I had in mind: ![Screenshot 2023-08-22 at 15.23.55](https://us1.discourse-cdn.com/elastic/original/3X/4/0/407cc914981cf425e4734b385ca73704d0f1ecb5.jpeg) This ensure the time sorting order and the breakdown by Top values ---
**Author:** ![Neelam\_Zanvar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/neelam_zanvar/32/103116_2.png) [@Neelam\_Zanvar](https://discuss.elastic.co/u/Neelam_Zanvar)\ **Post date:** [August 23, 2023, 4:24am UTC](https://discuss.elastic.co/t/stacked-bar-graph/341203/12 "2023-08-23T04:24:48Z")
okay will give it a try. Thanks! ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [September 20, 2023, 4:25am UTC](https://discuss.elastic.co/t/stacked-bar-graph/341203/13 "2023-09-20T04:25:07Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.