Create Multiple Rows and Columns with Data Table

[Sujit_Kumbhar]

Hi, I want to display the Data in Table Format as per below structure.

So, My question is it Possible to create the Kibana dashboard with above image format

[stephenb (Stephen Brown)]

Hi @Sujit_Kumbhar Welcome to the community.

Yes you mostly likely can using Lens (if you are on a newer version) or with the Legacy Table if you are not.

What version of Kibana / Elasticsearch are you on?

Plus you would need to provide some sample of the actual documents for help... how the data stored organized can have an effect on the possibility.

[Sujit_Kumbhar]

Thanks @stephenb for quick reply.

I am not using Kibana Lens. I have Data Table only.

I am working in IST time zone. So I will try to share the sample data tomorrow morning.

Thanks,
Sujit K

[stephenb (Stephen Brown)]

What version of Kibana / Elasticsearch?

[Sujit_Kumbhar]

Hi @stephenb I am using OpenSearch and the version is v 1.1.0 AND PLEASE check the sample JSON object for Data.

{
  "_index": "logs-service",
  "_type": "_doc",
  "_id": "DnLowY0BuSU3bIA6pro-",
  "_version": 1,
  "_score": null,
  "_source": {
    "timestamp": "2024-02-19T15:07:18.874Z",
    "functionVersion": "$LATEST",
    "traceIndex": 86,
    "serviceName": "sk-api",
    "serviceVersion": "latest",
    "envType": "nonprod",
    "awsRegion": "us-east-1",
    "message": "FTA: Create_User Completed Successfully.",
    "severity": "METERING"
  }
}

{
  "_index": "logs-service",
  "_type": "_doc",
  "_id": "DnLowY0BuSU3bIA6pro-",
  "_version": 1,
  "_score": null,
  "_source": {
    "timestamp": "2024-02-19T15:07:18.874Z",
    "functionVersion": "$LATEST",
    "traceIndex": 86,
    "serviceName": "sk-api",
    "serviceVersion": "latest",
    "envType": "nonprod",
    "awsRegion": "us-east-1",
    "message": "FTA: Create_User Started Successfully.",
    "severity": "METERING"
  }
}

{
  "_index": "logs-service",
  "_type": "_doc",
  "_id": "DnLowY0BuSU3bIA6pro-",
  "_version": 1,
  "_score": null,
  "_source": {
    "timestamp": "2024-02-19T15:07:18.874Z",
    "functionVersion": "$LATEST",
    "traceIndex": 86,
    "serviceName": "sk-api",
    "serviceVersion": "latest",
    "envType": "nonprod",
    "awsRegion": "us-east-1",
    "message": "FTA: Create_User Failed",
    "severity": "METERING"
  }
}```

[system]

OpenSearch/OpenDistro are AWS run products and differ from the original Elasticsearch and Kibana products that Elastic builds and maintains. You may need to contact them directly for further assistance.

(This is an automated response from your friendly Elastic bot. Please report this post if you have any suggestions or concerns )

[Sujit_Kumbhar]

I am able to create separate Column with the help of Metric but it's not displayed into single Row like below.

i want to show the single Row with all the Started,Completed and Failed messages.

[stephenb (Stephen Brown)]

Hi @Sujit_Kumbhar

Apologies that you're going to need to go to the opensearch forum, elasticsearch and opensearch are 2 completely different products now So we really can't help you here.

Good Luck!