Mathematical operation in kibana

Elastic Stack Kibana
1

Hi,

Can I perform calculations on a field?
"PatientID","PatientName","Age","Gender","Doctor","Revenue" are the fields I have. I want to perform the following operations:

  1. Total revenue per doctor
  2. Percentage of revenue per doctor to the hospital (percent=("Total Revenue of the doctor" / "Total Hospital Revenue")*100)

I want to perform these operations, Can anyone please help me in doing this?

Thanks & Regards,
Sanjay