Extract the year from a date

[marwa]

Hello,
i have data stored in elasticsearch with a field called transaction_date mapped as a date ,this is its structure in the csv file 2/24/2017;14:15:43 and this how it is viewed in kibana April 18th 2016, 15:15:44.000 .In fact , i want to perform calculations using aggregatiuons with scripted field but i want to extract only data of the year 2016 .how can i extract only the year from the date field ???? any help

[dadoonet (David Pilato)]

It's better to solve this problem at index time.

If your field is a date field, you can just generate a date histogram with a year size bucket and that will do what you expect.

[marwa]

Hi , thank you for your reply but i didn't get it are you talking about a bucket using kibana ???
in fact i need to divide my data into two bucket one for the year 2016 and one for the year 2017 , i know i can make it with aggregations using kibana visualization but i need to extract a metric from the buckets i mentionned then perform an other calculation with both results obtained .

I am trying to use scripted metrics with elasticsearch ? i don't know even if this can lead me to my goal ?? i need your consult !!! even more i am confused between aggregations and using painless to perform this calculation !! any help

[marwa]

Any suggestions please ???

[dadoonet (David Pilato)]

Please read be patient section at

About the Elasticsearch category

The heart of the free and open Elastic Stack Elasticsearch is a distributed, RESTful search and analytics engine capable of addressing a growing number of use cases. As the heart of the Elastic Stack, it centrally stores your data for lightning fast search, fine‑tuned relevancy, and powerful analytics that scale with ease. PLEASE READ THIS SECTION IF IT'S YOUR FIRST POST Some useful links: elasticsearch reference guide elasticsearch user guide elasticsearch plugins elasticsearch cl…

May be your question is more for Kibana? So may be move it to kibana instead?
I believe you can do something similar with time series visual builder.

[marwa]

sorry if i hadn't been patient

[Ravi_Shanker_Reddy]

Its better to show some sample data along with the output format you need. No one can help with these type of inputs. Be more specific.

[marwa]

hi ,
thankyou for you reply, maybe i get into details in my question but my main purpose is to perform calculations with elasticsearch then store the results . is there any API that allow me to do this ?