# Creating data table using group by like clause in Kibana?
**URL:** https://discuss.elastic.co/t/creating-data-table-using-group-by-like-clause-in-kibana/63352
**Category:** Kibana
**Created:** [October 19, 2016, 7:58am UTC](https://discuss.elastic.co/t/creating-data-table-using-group-by-like-clause-in-kibana/63352 "2016-10-19T07:58:02Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Kulasangar\_Gowrisang](https://discuss.elastic.co/u/Kulasangar_Gowrisang)
#### Post date: [October 19, 2016, 7:58am UTC](https://discuss.elastic.co/t/creating-data-table-using-group-by-like-clause-in-kibana/63352/1 "2016-10-19T07:58:02Z")
I'm having a dataset fed from my database into an index which I created using `logstash`. I'm trying to create a `table data` visualization through `Kibana` for the data set available.
I've got to create a `table data` in `Kibana` which should look more a like this.
In the above image I could simply get the date and the month seperately. The next column (num of Txn) is an aggregation from a `groupby` which contains the total hits of a particular `userid`, a `string` value. The other columns, (Gross Transaction Val) is a sum of a field (chargeamount) which is a `string` value and the other columns are `response code counts` for a particular `userid` in db.
I tried creating the table using `metrics` and `buckets`, but couldn't get it done completely. These are some snapshots of what I tried:
The sub buckets:
**These are the issues:**
1. I'm having a date and month fields separately. But is it possible to append both of them together in `Kibana`?
2. How can I get a
`count metric` being applied to a `String` value? Is there a way
that I could convert it to `int` through `Kibana`?
3. Is `groupby` clause in `MySQL` equal to aggregation buckets in
`Kibana`?
Where am I going wrong? Any help could be appreciated.
---
### Author:  [@lukas](https://discuss.elastic.co/u/lukas)
#### Post date: [October 19, 2016, 8:02pm UTC](https://discuss.elastic.co/t/creating-data-table-using-group-by-like-clause-in-kibana/63352/2 "2016-10-19T20:02:25Z")
Unfortunately, the data table visualization isn't going to get you the same table you have in your example.
In the data table visualization, think of the rows as buckets, and the columns as metrics calculated on the buckets. So the closest I think you could get to recreating your desired table is to select a date histogram bucket aggregation with a daily interval. Then, you can add metrics, like count, sum chargeamount, etc. Unfortunately you won't be able to have separate group by metrics as columns, because those are counts of separate buckets. You could then add a second bucket aggregation and split rows by response code, but then you'd have different rows when what you really want is separate columns.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 1:36pm UTC](https://discuss.elastic.co/t/creating-data-table-using-group-by-like-clause-in-kibana/63352/3 "2017-07-06T13:36:14Z")