Formula to show percentage on gauge showing wrong values

[akshay_bhardwaj]

Formula to show percentage or division on gauge showing wrong values

I have used below advanced json formula but its showing zero.
Please help and let me know the correct method to find percentage .

I need (sum of punctuality /count)*100

{
  "script": {
    "inline": "doc['punctuality'].value/100",
    "lang": "painless" 
  }
}

[akshay_bhardwaj]

Any solution?

[Marco_Liberati]

That is a scripted field, not a formula. The main difference is that with scripted/runtime fields you operate at each document level, while in formula it works at the aggregation level.

If you're looking to create a Gauge chart for a ratio ( A / B ) then you need to operate on a aggregation level. You might look into TSVB for that.