How to calculate percentage and show on panel or visualisation on dashboard

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.

Thanks for reaching out, @swtg , would something like this help: