# How to calculate percentage and show on panel or visualisation on dashboard **URL:** \ **Category:** Kibana\ **Created:** [May 13, 2024, 5:09am UTC](https://discuss.elastic.co/t/how-to-calculate-percentage-and-show-on-panel-or-visualisation-on-dashboard/359338 "2024-05-13T05:09:23Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![swtg](https://avatars.discourse-cdn.com/v4/letter/s/bbce88/32.png) [@swtg](https://discuss.elastic.co/u/swtg)\ **Post date:** [May 13, 2024, 5:09am UTC](https://discuss.elastic.co/t/how-to-calculate-percentage-and-show-on-panel-or-visualisation-on-dashboard/359338/1 "2024-05-13T05:09:23Z")
Hi All, I have got an index where all my maillogs are getting uploaded. There is a dashboard where we have got different panels showing count of mails being sent, deferred or bounced. Its being done with panels. What I want is another panel or visualization to show percentage of mails not being delivered, which I can calculate by below formulat. However I cant figure out a way to do so. Total mails - "sent+deferred+bounced" Formula - (deferred+bounced)/total mails \*100 Can someone please help here. ---
**Author:** ![jessgarson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jessgarson/32/129841_2.png) [@jessgarson](https://discuss.elastic.co/u/jessgarson)\ **Post date:** [May 13, 2024, 6:18pm UTC](https://discuss.elastic.co/t/how-to-calculate-percentage-and-show-on-panel-or-visualisation-on-dashboard/359338/2 "2024-05-13T18:18:07Z")
Thanks for reaching out, @swtg , would something like this help: > **[How to display data as a percentage in Kibana visualizations](https://www.elastic.co/blog/how-to-display-data-as-a-percentage-in-kibana-visualizations)** > > Using percentages in data analytics is essential for effective numeric comparison, especially when working with drastically different sample sizes or totals. Find out how to calculate percentages in K...