# Kibnana 4: Multiple Counts by Row **URL:** https://discuss.elastic.co/t/kibnana-4-multiple-counts-by-row/863 **Category:** Kibana **Created:** [May 18, 2015, 8:50pm UTC](https://discuss.elastic.co/t/kibnana-4-multiple-counts-by-row/863 "2015-05-18T20:50:28Z") **Posts on this page:** 5 **Page:** 1
### Author: ![pczarnota](https://avatars.discourse-cdn.com/v4/letter/p/c2a13f/32.png) [@pczarnota](https://discuss.elastic.co/u/pczarnota) #### Post date: [May 18, 2015, 8:50pm UTC](https://discuss.elastic.co/t/kibnana-4-multiple-counts-by-row/863/1 "2015-05-18T20:50:28Z")
Hello, I am trying to build a table visual which breaks down the total count by terms in one row. For example, I have a record for myself (User) and I have two types of ratings, Good and Bad. If I want a count by User and a then one column is the total number of Good reviews and another column is the total number of Bad reviews, can I do that? I do not want to split the rows or the tables. Thank you! Philip ---
### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm) #### Post date: [May 18, 2015, 9:02pm UTC](https://discuss.elastic.co/t/kibnana-4-multiple-counts-by-row/863/2 "2015-05-18T21:02:12Z")
What if you split by column then? ---
### Author: ![pczarnota](https://avatars.discourse-cdn.com/v4/letter/p/c2a13f/32.png) [@pczarnota](https://discuss.elastic.co/u/pczarnota) #### Post date: [May 18, 2015, 9:24pm UTC](https://discuss.elastic.co/t/kibnana-4-multiple-counts-by-row/863/3 "2015-05-18T21:24:19Z")
Unfortunately I don't see that option. Only split by row or table exist. ---
### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm) #### Post date: [May 20, 2015, 7:36am UTC](https://discuss.elastic.co/t/kibnana-4-multiple-counts-by-row/863/4 "2015-05-20T07:36:37Z")
I am certain I saw split by column the other day, but I can't see it now sorry ☹ I'll keep an eye out though. EDIT - Ok I found it. If you split by table you can then split by column, not sure if that will do what you want though! ![](https://sea2.discourse-cdn.com/elastic/uploads/default/308/f3db0969916c3a83.jpg) ---
### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system) #### Post date: [July 6, 2017, 2:19pm UTC](https://discuss.elastic.co/t/kibnana-4-multiple-counts-by-row/863/5 "2017-07-06T14:19:16Z")