First of all, I think this question is related to Kibana, let me know if I am wrong:-)
My question is that I want to aggregate my ElasticSearch Index data and then visualize it into the Gantt chart, I don't know if I am on the right path for solving the problem.
Here is the example of my data:
and I want to display it as the Gantt chart with x-axis being date time, and y-axis being ID1 and ID2, and the horizontal bar will be displayed from 2011-01-01 to 2011-01-02 for ID1 and 2011-01-03 to 2011-01-04 for ID2
What I am thinking about the steps as follows:
- Aggregate the ElasticSearch data using the query in Kibana into something like below:
- Using Vega component to display as in this thread:
Gantt Chart timeline issue with Vega visualization
Note: The reason I did not want to aggregate the data was to keep the original timestamp (which I did not add into my example above) and I want to generate other charts using the raw data.
What I could think of possibly is that maybe I don't need to aggregate the data and some functionalities exist?
Please advise, thanks a lot in advance!