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:
[{
ID: ID1,
StartEndFlag: Start
Date: 2011-01-01
},
{
ID: ID1,
StartEndFlag: End
Date: 2011-01-02
},{
ID: ID2,
StartEndFlag: Start
Date: 2011-01-03
},
{
ID: ID2,
StartEndFlag: End
Date: 2011-01-04
}]
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:
{ID: ID1
StartDate: 2011-01-01
EndDate: 2011-01-02
} - 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!