Can I create timeline chart in Kibana?

Elastic Stack Kibana
1

Hi all,

I would like to create a timeline chart.
I have projects that have start-date and end-date values that I would like to visualize.
I've been struggling to find a solution for a while now.

My data looks like this approx.:

{
  "description": [
    "project"
  ],
  "description.keyword": [
    "project"
  ],
  "id": [
    "28aac9f41e9d2178393ccac103b0cb9c76ea54f196f58c42c82f4492757358f0"
  ],
  "metadata.properties.Project": [
    "Some name"
  ],
  "metadata.properties.Project.keyword": [
    "Some name"
  ],
  "metadata.properties.StartDate": [
    "2022-10-24T00:00:00.000Z"
  ],
  "metadata.properties.EndDate": [
    "2022-12-31T00:00:00.000Z"
  ],
  "metadata.properties.Client": [
    "Client name"
  ],
  "metadata.properties.Client.keyword": [
    "Client name"
  ],
  "metadata.properties.BillableAmount": [
    5500
  ],
  "metadata.properties.BillableHours": [
    37
  ],
  "metadata.properties.Budget": [
    325
  ],
  "metadata.properties.BudgetBy": [
    "Hours"
  ],
  "metadata.properties.BudgetBy.keyword": [
    "Hours"
  ],
  "metadata.properties.BudgetRemaining": [
    275
  ],
  "metadata.properties.BudgetSpent": [
    25
  ],
  "metadata.properties.ProjectCode": [
    "3400001043"
  ],
  "metadata.properties.ProjectCode.keyword": [
    "3400001043"
  ],
  "metadata.properties.ProjectID": [
    "0575e4e776897f36a7d1a70ed2c37df1eae4b348289013d9cce31b854c3e008d"
  ],
  "metadata.properties.ProjectID.keyword": [
    "0575e4e776897f36a7d1a70ed2c37df1eae4b348289013d9cce31b854c3e008d"
  ],
  "metadata.properties.TotalHours": [
    40
  ],
  "name": [
    "Some name"
  ],
  "name.keyword": [
    "Some name"
  ],
  "name.length": [
    9
  ],
  "source": [
    "Test Source"
  ],
  "_id": "28aac9f41e9d2178393ccac103b0cb9c76ea54f196f58c42c82f4492757358f0",
  "_index": "insights_default_xod",
  "_score": 0
}

The only values I care for are: metadata.properties: Project, StartDate, EndDate.
Does anyone has any ideas how I can do this?

Thank you in advance for reading and any suggestions.
Kamil

2

Hi @Kamil_BdBelfort

I think the best way to achieve that would be to use Vega.
A typical representation of such data is usually a Gantt chart. Here you can find a Vega configuration on how to build one: Gantt chart on Kibana using version 7.11 - #3 by bab

3

I was trying Vega indeed before, and I've posted a question on that previously, but received no replies. I will have a look into this link. Thanks

4

Hi @Marco_Liberati,
I have followed you example, from the link Gantt chart on Kibana using version 7.11 - #3 by bab .

I have modified the fields accordingly (see screenshot below):

kibana error
kibana error2363×1436 198 KB

Unfortunately I get 'Infinite extent for field' error for both StartDate and EndDate.
Do you have any idea why? I am of course looking into debugging this on my own in the meantime.

If successful, I will share the solution.

With regards,
Kamil

5

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