# Heatmap respect X or Y axis metric, not both

**URL:** https://discuss.elastic.co/t/heatmap-respect-x-or-y-axis-metric-not-both/254447
**Category:** Kibana
**Created:** [November 5, 2020, 6:11pm UTC](https://discuss.elastic.co/t/heatmap-respect-x-or-y-axis-metric-not-both/254447 "2020-11-05T18:11:27Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![nunes](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nunes/32/78412_2.png) [@nunes](https://discuss.elastic.co/u/nunes)
#### Post date: [November 5, 2020, 6:11pm UTC](https://discuss.elastic.co/t/heatmap-respect-x-or-y-axis-metric-not-both/254447/1 "2020-11-05T18:11:27Z")

</div>

Im trying to make a calendar with heatmap vizualization. Sum of field group by week number and week day. And this works when i use histogram aggregate for week day.

 ![Captura de tela de 2020-11-05 14-58-12](https://us1.discourse-cdn.com/elastic/original/3X/b/1/b1ad5ff0cf1b91ed845e37b8579a4dbf728e3431.png) But i want to use the week days in text (Mon, Tue, Wed), not in number (1, 2, 3), aggregating by term and sort by a custom metric, aggregating by the week days in number, but the X axis sort dont work. ![Captura de tela de 2020-11-05 15-05-09](https://us1.discourse-cdn.com/elastic/original/3X/3/f/3fa3b6aa42d14b0d79738398afbd71dac94ba741.png) When I search for this problem, people say to inverte the axis priority, but when I do, the X axis is right and Y is wrong. ![Captura de tela de 2020-11-05 15-08-32](https://us1.discourse-cdn.com/elastic/original/3X/0/3/03069b82b4351501c8c4b2d143ddeb43ee7c4015.png) What can I do? (sorry for some english error)

---

<div class="post-metadata">

### Author: ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)
#### Post date: [November 11, 2020, 3:48pm UTC](https://discuss.elastic.co/t/heatmap-respect-x-or-y-axis-metric-not-both/254447/2 "2020-11-11T15:48:33Z")

</div>

I see you [opened an issue for this](https://github.com/elastic/kibana/issues/82762). Have you tried sorting the Terms aggregation by the numeric value of the week?

---

<div class="post-metadata">

### Author: ![nunes](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nunes/32/78412_2.png) [@nunes](https://discuss.elastic.co/u/nunes)
#### Post date: [November 11, 2020, 4:39pm UTC](https://discuss.elastic.co/t/heatmap-respect-x-or-y-axis-metric-not-both/254447/3 "2020-11-11T16:39:09Z")

</div>

Yes, im alredy doing this (in custom metric). But my problem is the X axis, where im trying to sorting by day of week

---

<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: [December 9, 2020, 4:39pm UTC](https://discuss.elastic.co/t/heatmap-respect-x-or-y-axis-metric-not-both/254447/4 "2020-12-09T16:39:10Z")

</div>

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