Live/historical charts by elasticsearch documents

Elastic Stack Elasticsearch
1

Hi everyone.
I want to create real time and historical charts (for example by chart.js library) from the elasticsearch documents.
each document has its own date field. So I want to have a linear chart (x axis : time field, y axis: another (value) filed) monthly, from example between (1-Jan-2020 to 1-Feb-2020).

If I want to query a list of (x,y) values between this time range, the problem is that the amount of data in this period is very large (2592000 records monthly).
Do I have to break down my chart into smaller periods (for example daily)?
what is the best way to do this scenario?

2

Are you having problems running the query? Elasticsearch should be able to handle that pretty easily.

3

If you base your visualisations on aggregations rather than try to return and process individual documents this should not be a problem. This is e.g. what Kibana does.

1 Like
4

@Christian_Dahlqvist
I'm new to the elasticsearch.
How can I do it? can you share an example or reference link please?

5

I would recommend having a look at the documentation.

6

@warkolm
Sure!
Elasticsearch can do it, but there is not enough advanced tutorial/examples about this case in the web.

7

As Christian mentioned, using aggregations is the best way.

8

I will read aggregations tonight and hope the reference can be a good help.
Thank you.

9

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