I was wondering if somebody familiar with aggregations, particularly date
histogram aggregations, can point me in the right direction.
I'm currently looking to get a total count of records over a specific time
period. Each record contains a "date_submitted" field and if they're
closed, contain a "date_closed" field.
Is it possible to aggregate the records based off these values (i.e. only
showing open issues for a weekly period, even if the record was submitted a
year ago)? If so where abouts are the aggregations specified? In the
dashboard JSON or within the index mapping?
I believe this can be done in this manner.
Do 2 separate date histogram on the date_submitted field and date_closed
field.
The sum of count of date_submitted minus the sum of count on date_closed
on all the previous date should give you the number of open issues for that
week.
For eg:
Week1 - Open - 10 , closed - 5
Week2 - Open 20 m ,closed 6
Week3 - Open 30 , closed 10
Number of open issues on
Week1 - 10
Week2 - (20 + 10 ) - 5 = 25
Week3 - ( 30 + 20 + 10 ) - (6 + 5) = 49
I was wondering if somebody familiar with aggregations, particularly date
histogram aggregations, can point me in the right direction.
I'm currently looking to get a total count of records over a specific time
period. Each record contains a "date_submitted" field and if they're
closed, contain a "date_closed" field.
Is it possible to aggregate the records based off these values (i.e. only
showing open issues for a weekly period, even if the record was submitted a
year ago)? If so where abouts are the aggregations specified? In the
dashboard JSON or within the index mapping?
Many thanks for your reply, sounds like your method should work a treat!
One quick noob question, where abouts are the date histograms aggregations
created? Are they created on the index or on the dashboard itself? Any help
is appreciated.
Cheers,
Si.
On Monday, September 1, 2014 2:11:02 PM UTC+1, vineeth mohan wrote:
Hello Simon ,
I believe this can be done in this manner.
Do 2 separate date histogram on the date_submitted field and date_closed
field.
The sum of count of date_submitted minus the sum of count on date_closed
on all the previous date should give you the number of open issues for that
week.
For eg:
Week1 - Open - 10 , closed - 5
Week2 - Open 20 m ,closed 6
Week3 - Open 30 , closed 10
Number of open issues on
Week1 - 10
Week2 - (20 + 10 ) - 5 = 25
Week3 - ( 30 + 20 + 10 ) - (6 + 5) = 49
Thanks
Vineeth
On Mon, Sep 1, 2014 at 5:25 PM, Simon Edwards <simon_...@scee.net
<javascript:>> wrote:
Hi,
I was wondering if somebody familiar with aggregations, particularly date
histogram aggregations, can point me in the right direction.
I'm currently looking to get a total count of records over a specific
time period. Each record contains a "date_submitted" field and if they're
closed, contain a "date_closed" field.
Is it possible to aggregate the records based off these values (i.e. only
showing open issues for a weekly period, even if the record was submitted a
year ago)? If so where abouts are the aggregations specified? In the
dashboard JSON or within the index mapping?
Many thanks for your reply, sounds like your method should work a treat!
One quick noob question, where abouts are the date histograms aggregations
created? Are they created on the index or on the dashboard itself? Any help
is appreciated.
Cheers,
Si.
On Monday, September 1, 2014 2:11:02 PM UTC+1, vineeth mohan wrote:
Hello Simon ,
I believe this can be done in this manner.
Do 2 separate date histogram on the date_submitted field and date_closed
field.
The sum of count of date_submitted minus the sum of count on date_closed
on all the previous date should give you the number of open issues for that
week.
For eg:
Week1 - Open - 10 , closed - 5
Week2 - Open 20 m ,closed 6
Week3 - Open 30 , closed 10
Number of open issues on
Week1 - 10
Week2 - (20 + 10 ) - 5 = 25
Week3 - ( 30 + 20 + 10 ) - (6 + 5) = 49
I was wondering if somebody familiar with aggregations, particularly
date histogram aggregations, can point me in the right direction.
I'm currently looking to get a total count of records over a specific
time period. Each record contains a "date_submitted" field and if they're
closed, contain a "date_closed" field.
Is it possible to aggregate the records based off these values (i.e.
only showing open issues for a weekly period, even if the record was
submitted a year ago)? If so where abouts are the aggregations specified?
In the dashboard JSON or within the index mapping?
Many thanks in advance.
--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearc...@googlegroups.com.
My question was regarding where to set up the date histograms. Do i simply
add a section to the dashboard JSON or do I need to update the
index field mappings? If you could provide a small example that'd be great.
Thanks for all your help!
On Monday, September 1, 2014 4:12:14 PM UTC+1, vineeth mohan wrote:
Hello Simon ,
I didn't quite understand your question.
Kindly elaborate.
Thanks
Vineeth
On Mon, Sep 1, 2014 at 7:59 PM, Simon Edwards <simon_...@scee.net
<javascript:>> wrote:
Hello Vineeth,
Many thanks for your reply, sounds like your method should work a treat!
One quick noob question, where abouts are the date histograms
aggregations created? Are they created on the index or on the dashboard
itself? Any help is appreciated.
Cheers,
Si.
On Monday, September 1, 2014 2:11:02 PM UTC+1, vineeth mohan wrote:
Hello Simon ,
I believe this can be done in this manner.
Do 2 separate date histogram on the date_submitted field and date_closed
field.
The sum of count of date_submitted minus the sum of count on
date_closed on all the previous date should give you the number of open
issues for that week.
For eg:
Week1 - Open - 10 , closed - 5
Week2 - Open 20 m ,closed 6
Week3 - Open 30 , closed 10
Number of open issues on
Week1 - 10
Week2 - (20 + 10 ) - 5 = 25
Week3 - ( 30 + 20 + 10 ) - (6 + 5) = 49
I was wondering if somebody familiar with aggregations, particularly
date histogram aggregations, can point me in the right direction.
I'm currently looking to get a total count of records over a specific
time period. Each record contains a "date_submitted" field and if they're
closed, contain a "date_closed" field.
Is it possible to aggregate the records based off these values (i.e.
only showing open issues for a weekly period, even if the record was
submitted a year ago)? If so where abouts are the aggregations specified?
In the dashboard JSON or within the index mapping?
Many thanks in advance.
--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearc...@googlegroups.com.
I hope you are familiar with Elasticsearch API.
I believe by dashboard you are meaning Kibana.
If that is the case , you wont be able to see this result there as Kibana
does not currently offers this level of flexibility.
You will need to write JSON agg query based on -
There need not be any work on schma or index to use this.
Hope that helps.
My question was regarding where to set up the date histograms. Do i simply
add a section to the dashboard JSON or do I need to update the
index field mappings? If you could provide a small example that'd be great.
Thanks for all your help!
On Monday, September 1, 2014 4:12:14 PM UTC+1, vineeth mohan wrote:
Hello Simon ,
I didn't quite understand your question.
Kindly elaborate.
Many thanks for your reply, sounds like your method should work a treat!
One quick noob question, where abouts are the date histograms
aggregations created? Are they created on the index or on the dashboard
itself? Any help is appreciated.
Cheers,
Si.
On Monday, September 1, 2014 2:11:02 PM UTC+1, vineeth mohan wrote:
Hello Simon ,
I believe this can be done in this manner.
Do 2 separate date histogram on the date_submitted field and
date_closed field.
The sum of count of date_submitted minus the sum of count on
date_closed on all the previous date should give you the number of open
issues for that week.
For eg:
Week1 - Open - 10 , closed - 5
Week2 - Open 20 m ,closed 6
Week3 - Open 30 , closed 10
Number of open issues on
Week1 - 10
Week2 - (20 + 10 ) - 5 = 25
Week3 - ( 30 + 20 + 10 ) - (6 + 5) = 49
I was wondering if somebody familiar with aggregations, particularly
date histogram aggregations, can point me in the right direction.
I'm currently looking to get a total count of records over a specific
time period. Each record contains a "date_submitted" field and if they're
closed, contain a "date_closed" field.
Is it possible to aggregate the records based off these values (i.e.
only showing open issues for a weekly period, even if the record was
submitted a year ago)? If so where abouts are the aggregations specified?
In the dashboard JSON or within the index mapping?
Many thanks in advance.
--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearc...@googlegroups.com.
On Monday, September 1, 2014 5:03:38 PM UTC+1, vineeth mohan wrote:
Hello Simon ,
I hope you are familiar with Elasticsearch API.
I believe by dashboard you are meaning Kibana.
If that is the case , you wont be able to see this result there as Kibana
does not currently offers this level of flexibility.
There need not be any work on schma or index to use this.
Hope that helps.
Thanks
Vineeth
On Mon, Sep 1, 2014 at 8:59 PM, Simon Edwards <simon_...@scee.net
<javascript:>> wrote:
Hello Vineeth,
My question was regarding where to set up the date histograms. Do i
simply add a section to the dashboard JSON or do I need to
update the index field mappings? If you could provide a small example
that'd be great.
Thanks for all your help!
On Monday, September 1, 2014 4:12:14 PM UTC+1, vineeth mohan wrote:
Hello Simon ,
I didn't quite understand your question.
Kindly elaborate.
Many thanks for your reply, sounds like your method should work a treat!
One quick noob question, where abouts are the date histograms
aggregations created? Are they created on the index or on the dashboard
itself? Any help is appreciated.
Cheers,
Si.
On Monday, September 1, 2014 2:11:02 PM UTC+1, vineeth mohan wrote:
Hello Simon ,
I believe this can be done in this manner.
Do 2 separate date histogram on the date_submitted field and
date_closed field.
The sum of count of date_submitted minus the sum of count on
date_closed on all the previous date should give you the number of open
issues for that week.
For eg:
Week1 - Open - 10 , closed - 5
Week2 - Open 20 m ,closed 6
Week3 - Open 30 , closed 10
Number of open issues on
Week1 - 10
Week2 - (20 + 10 ) - 5 = 25
Week3 - ( 30 + 20 + 10 ) - (6 + 5) = 49
I was wondering if somebody familiar with aggregations, particularly
date histogram aggregations, can point me in the right direction.
I'm currently looking to get a total count of records over a specific
time period. Each record contains a "date_submitted" field and if they're
closed, contain a "date_closed" field.
Is it possible to aggregate the records based off these values (i.e.
only showing open issues for a weekly period, even if the record was
submitted a year ago)? If so where abouts are the aggregations specified?
In the dashboard JSON or within the index mapping?
Many thanks in advance.
--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to elasticsearc...@googlegroups.com.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.