Can I use the result of a query in other scripted query to perform calculations?

paulo.leao · October 12, 2018, 9:00pm

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:

gist.github.com

https://gist.github.com/591573/5f7b8b891ed6e6cd246ba76878569a63#file-gistfile1-txt

gistfile1.txt

{
  "ms-services-2018.10.11": {
    "mappings": {
      "doc": {
        "properties": {
          "@timestamp": {
            "type": "date"
          },
          "@version": {
            "type": "text",

This file has been truncated. show original

Here is my query:

gist.github.com

https://gist.github.com/591573/fb3bf3b50a1425c1a1f9440d4ee60462#file-gistfile1-txt

gistfile1.txt

GET ms-services-*/_search
{
  "_source": {
              "includes": [ "RequestedDateTime"]
  },
  "aggs":{  
         "TotalOutageTimSeconds":{  
             "sum":{  
                 "script":"doc['OutageTime'].value"
             }

This file has been truncated. show original

So my question is: is it possible to use the result of the aggregation in the scripted query?

system · November 9, 2018, 9:00pm

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.