I am trying to create a query to output a ratio. The first number is the sum aggregation of the OutageTime field. The second number is a scripted field.
Here is my mapping:
Here is my query:
So my question is: is it possible to use the result of the aggregation in the scripted query?