Heatmap with time spans calculated out of documents

Elastic Stack Kibana
1

Hi everyone.

I have documents that look like this:

{
 "resource":"xyz",
 "started_at":"2020-01-01T10:00:00Z",
 "finished_at":"2020-01-01T14:23:54Z"
}

What I want to do is creating a heatmap which uses the resource for the y-axis and date range on the x-axis. The heatmap should show if a resource was in use or not at the point of time. Is there a way to do this?

Thanks for your help.

2

Hi, the described chart looks like a gantt chart, you can use Vega for that. Here an example of how to build that chart : Gantt Chart (Ranged Bar Marks) | Vega-Lite
Follow this guide for an understanding on how Vega works within Kibana Vega | Kibana Guide [7.11] | Elastic