How to devide a field value by 100

  • What Grafana version and what operating system are you using?
    I am using grafana v9.0.5 on Oracle Linux Version 8

  • What are you trying to achieve?
    I am trying to devide numeric filed value from elasticsearch data source in table view by 100

  • How are you trying to achieve it?

  • What happened?

  • What did you expect to happen?

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?

Welcome @faizalshamri

Have you tried using a transformation? See below (ignore the first two transformations…all you should need is the “Add field from calculation” transformation).