# How to use conditional operator in bucket\_script.i tried this query

**URL:** <https://discuss.elastic.co/t/how-to-use-conditional-operator-in-bucket-script-i-tried-this-query/187107>\
**Category:** Kibana\
**Created:** [June 24, 2019, 11:08am UTC](https://discuss.elastic.co/t/how-to-use-conditional-operator-in-bucket-script-i-tried-this-query/187107 "2019-06-24T11:08:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sakthivanan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sakthivanan/32/77897_2.png) [@Sakthivanan](https://discuss.elastic.co/u/Sakthivanan)\
**Post date:** [June 24, 2019, 11:08am UTC](https://discuss.elastic.co/t/how-to-use-conditional-operator-in-bucket-script-i-tried-this-query/187107/1 "2019-06-24T11:08:10Z")

</div>

```
{
            "size": 0,
            "query": {
              "bool": {
                "filter": [],
                "must": [
                  {
                    "terms": {
                      "metric_id": [
                        10003,
                        10007,
                        1009,
                        1032,
                        1033
                      ]
                    }
                  }
                ]
              }
            },
                "aggs": {
                  "groupby_metric_id": {
                    "terms": {
                      "field": "metric_name.keyword",
                      "size": 999,
                      "order": {
                        "_key": "desc"
                      }
                    },
                    "aggs": {
                      "groupby_school_year": {
                        "terms": {
                          "field": "school_year",
                          "size": 1,
                          "order": {
                            "_key": "desc"
                          }
                        },
                        "aggs": {
                          "groupby_school_name": {
                            "terms": {
                              "field": "school_official_name.keyword",
                              "size": 999,
                              "order": {
                                "_key": "desc"
                              }
                            },
                            "aggs": {
                              "document_sample": {
                                "top_hits": {
                                  "_source": {
                                    "includes": [
                              "school_official_name",
                              "address_1",
                              "school_logo",
                              "school_city",
                              "school_state",
                              "school_zip_code",
                              "school_grade_configuration",
                              "principal_photo",
                              "school_principal",
                              "@timestamp",
                              "metric_prefix",
                              "metric_suffix",
                              "metric_mask",
                              "metric_precision",
                              "metric_indicator_type",
                              "metric_icon_location",
                              "school_grade",
                              "school_image",
                              "metric_type"
                            ]
                                  }
                                }
                              },
                              "sum_num_cy": {
                                "sum": {
                                  "script": {
                                    "lang": "painless",
                                    "source": "Float.parseFloat(params._source.metric_numerator === null ? '0':String.valueOf(params._source.metric_numerator))"
                                  }
                                }
                              },
                              "sum_den_cy": {
                                "sum": {
                                  "script": {
                                    "lang": "painless",
                                    "source": "Float.parseFloat(params._source.metric_denominator === null ? '0':String.valueOf(params._source.metric_denominator))"
                                  }
                                }
                              },
                              "current_year": {
                                "bucket_script": {
                                  "buckets_path": {
                                    "var1": "sum_num_cy",
                                    "var2": "sum_den_cy"
                                  },
                                  "script": {
                                    "lang": "painless",
                                    "source": "Float.parseFloat(params._source.metric_type === percentage ? '(params.var1/params.var2*100)':'(params.var1))'"
                                  }
                                }
                              }
                            }
                          }
                        }
                      }
                    }
                  }
                }
              }

```

error:  
{  
"error": {  
"root\_cause": ,  
"type": "search\_phase\_execution\_exception",  
"reason": "",  
"phase": "fetch",  
"grouped": true,  
"failed\_shards": ,  
"caused\_by": {  
"type": "script\_exception",  
"reason": "compile error",  
"script\_stack": [  
"... r2_100)':'(params.var1))'",  
" ^---- HERE"  
],  
"script": "Float.parseFloat(params.\_source.metric\_type === percentage ? '(params.var1/params.var2_100)':'(params.var1))'",  
"lang": "painless",  
"caused\_by": {  
"type": "illegal\_argument\_exception",  
"reason": "unexpected end of script.",  
"caused\_by": {  
"type": "no\_viable\_alt\_exception",  
"reason": null  
}  
}  
}  
},  
"status": 503  
}

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 22, 2019, 11:08am UTC](https://discuss.elastic.co/t/how-to-use-conditional-operator-in-bucket-script-i-tried-this-query/187107/2 "2019-07-22T11:08:16Z")

</div>

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