# Number of rows in heatmap

**URL:** https://discuss.elastic.co/t/number-of-rows-in-heatmap/102316
**Category:** Kibana
**Created:** [September 29, 2017, 8:58pm UTC](https://discuss.elastic.co/t/number-of-rows-in-heatmap/102316 "2017-09-29T20:58:35Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![bgoldowsky](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bgoldowsky/32/22664_2.png) [@bgoldowsky](https://discuss.elastic.co/u/bgoldowsky)
#### Post date: [September 29, 2017, 8:58pm UTC](https://discuss.elastic.co/t/number-of-rows-in-heatmap/102316/1 "2017-09-29T20:58:35Z")

</div>

I would like to be able to control the number of rows (aka y-axis buckets) in a heatmap. In this screenshot, you'll see the "size" field has been set to "7", but many more rows are displayed. If I set the number much higher, I get an error: "There are too many series defined". Am I interpreting "size" here completely wrong? Or is there a bug?

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/6/36d55feae9bcd3406a1b162ec167920fd5fbee23.png)

I'd appreciate any clues you can provide.

Boris

---

<div class="post-metadata">

### Author: ![dsnider](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dsnider/32/44068_2.png) [@dsnider](https://discuss.elastic.co/u/dsnider)
#### Post date: [September 29, 2017, 10:59pm UTC](https://discuss.elastic.co/t/number-of-rows-in-heatmap/102316/2 "2017-09-29T22:59:06Z")

</div>

Asked some questions from our viz team. They said that it looks like you need to flip your x and y aggregations. It's hard to see in your screenshot was X aggregates.

---

<div class="post-metadata">

### Author: ![bgoldowsky](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bgoldowsky/32/22664_2.png) [@bgoldowsky](https://discuss.elastic.co/u/bgoldowsky)
#### Post date: [September 30, 2017, 12:09pm UTC](https://discuss.elastic.co/t/number-of-rows-in-heatmap/102316/3 "2017-09-30T12:09:40Z")

</div>

Thank you!  
The X axis is: Histogram, interval 1, on a numeric field.  
Following your advice, I dragged the Y axis up so that it had top priority, and then its "Size" setting was respected (in that I can control the number of rows directly).

Help me to understand what's actually happening here -- was it looking for the top 7 items in every assignment\_number column, and combining all of those into the display?

---

<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: [October 28, 2017, 12:09pm UTC](https://discuss.elastic.co/t/number-of-rows-in-heatmap/102316/4 "2017-10-28T12:09:46Z")

</div>

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