# Create Multiple Rows and Columns with Data Table

**URL:** https://discuss.elastic.co/t/create-multiple-rows-and-columns-with-data-table/353619
**Category:** Kibana
**Created:** [February 19, 2024, 3:02pm UTC](https://discuss.elastic.co/t/create-multiple-rows-and-columns-with-data-table/353619 "2024-02-19T15:02:34Z")
**Posts on this page:** 9
**Page:** 1

<div class="post-metadata">

### Author: ![Sujit\_Kumbhar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sujit_kumbhar/32/131899_2.png) [@Sujit\_Kumbhar](https://discuss.elastic.co/u/Sujit_Kumbhar)
#### Post date: [February 19, 2024, 3:02pm UTC](https://discuss.elastic.co/t/create-multiple-rows-and-columns-with-data-table/353619/1 "2024-02-19T15:02:35Z")

</div>

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

 ![Screenshot 2024-02-19 at 6.40.26 PM](https://us1.discourse-cdn.com/elastic/original/3X/e/e/ee304874871608d61562c7ebc709423f3ced0062.png)

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

---

<div class="post-metadata">

### Author: ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [February 19, 2024, 4:02pm UTC](https://discuss.elastic.co/t/create-multiple-rows-and-columns-with-data-table/353619/2 "2024-02-19T16:02:03Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![Sujit\_Kumbhar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sujit_kumbhar/32/131899_2.png) [@Sujit\_Kumbhar](https://discuss.elastic.co/u/Sujit_Kumbhar)
#### Post date: [February 19, 2024, 5:54pm UTC](https://discuss.elastic.co/t/create-multiple-rows-and-columns-with-data-table/353619/3 "2024-02-19T17:54:41Z")

</div>

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

---

<div class="post-metadata">

### Author: ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [February 19, 2024, 5:56pm UTC](https://discuss.elastic.co/t/create-multiple-rows-and-columns-with-data-table/353619/4 "2024-02-19T17:56:47Z")

</div>

What version of Kibana / Elasticsearch?

---

<div class="post-metadata">

### Author: ![Sujit\_Kumbhar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sujit_kumbhar/32/131899_2.png) [@Sujit\_Kumbhar](https://discuss.elastic.co/u/Sujit_Kumbhar)
#### Post date: [February 20, 2024, 7:29am UTC](https://discuss.elastic.co/t/create-multiple-rows-and-columns-with-data-table/353619/5 "2024-02-20T07:29:10Z")

</div>

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

````auto
{
  "_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"
  }
}```
````

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [February 20, 2024, 7:29am UTC](https://discuss.elastic.co/t/create-multiple-rows-and-columns-with-data-table/353619/6 "2024-02-20T07:29:11Z")

</div>

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 :elasticheart: )

---

<div class="post-metadata">

### Author: ![Sujit\_Kumbhar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sujit_kumbhar/32/131899_2.png) [@Sujit\_Kumbhar](https://discuss.elastic.co/u/Sujit_Kumbhar)
#### Post date: [February 20, 2024, 12:53pm UTC](https://discuss.elastic.co/t/create-multiple-rows-and-columns-with-data-table/353619/7 "2024-02-20T12:53:45Z")

</div>

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

 ![Screenshot 2024-02-20 at 6.22.50 PM](https://us1.discourse-cdn.com/elastic/original/3X/2/5/2525a8c4629a23f6a4fef56ff08977cef9b33177.png)

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

---

<div class="post-metadata">

### Author: ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [February 20, 2024, 2:56pm UTC](https://discuss.elastic.co/t/create-multiple-rows-and-columns-with-data-table/353619/8 "2024-02-20T14:56:29Z")

</div>

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!

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 19, 2024, 2:56pm UTC](https://discuss.elastic.co/t/create-multiple-rows-and-columns-with-data-table/353619/9 "2024-03-19T14:56:32Z")

</div>

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