# Scripted field for same month data
**URL:** https://discuss.elastic.co/t/scripted-field-for-same-month-data/256121
**Category:** Elasticsearch
**Created:** [November 20, 2020, 12:56pm UTC](https://discuss.elastic.co/t/scripted-field-for-same-month-data/256121 "2020-11-20T12:56:22Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Gauti](https://discuss.elastic.co/u/Gauti)
#### Post date: [November 20, 2020, 12:56pm UTC](https://discuss.elastic.co/t/scripted-field-for-same-month-data/256121/1 "2020-11-20T12:56:23Z")
Hi All,
We are trying to build a dashboard for a new scenario,like we are ingesting data from servicenow using logstash, the data has ticket information like opened and closed, we want to build a dashboard for monthly backlog tickets, which is tickets opened and not closed on the same month.
Trying to writing a scripted field to identify this, but not able to, can someone guide me how can i achieve this.
**logic we are trying is, if "created month" and "closed month" are same then return 0 else return 1**
Thanks
Gautham
---
### Author:  [@Hendrik\_Muhs](https://discuss.elastic.co/u/Hendrik_Muhs)
#### Post date: [November 20, 2020, 2:08pm UTC](https://discuss.elastic.co/t/scripted-field-for-same-month-data/256121/2 "2020-11-20T14:08:38Z")
Are the fields part of the _same_ or _different_ documents?
---
### Author:  [@Gauti](https://discuss.elastic.co/u/Gauti)
#### Post date: [November 20, 2020, 2:31pm UTC](https://discuss.elastic.co/t/scripted-field-for-same-month-data/256121/3 "2020-11-20T14:31:26Z")
@Hendrik_Muhs Fields are from same documents.
---
### Author:  [@Hendrik\_Muhs](https://discuss.elastic.co/u/Hendrik_Muhs)
#### Post date: [November 20, 2020, 2:57pm UTC](https://discuss.elastic.co/t/scripted-field-for-same-month-data/256121/4 "2020-11-20T14:57:34Z")
You can use a `script` as part of the aggregation you are looking for, e.g. [`sum`](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics-sum-aggregation.html#_script_15). The script is applied per data point, therefore if you return 1 if and only if your criteria is met you get the total count the criteria was met. Vice versa you can create another sum aggregation with reversed logic.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 18, 2020, 2:57pm UTC](https://discuss.elastic.co/t/scripted-field-for-same-month-data/256121/5 "2020-12-18T14:57:40Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.