# X axis scale showing wrong order in Heat map chart
**URL:** https://discuss.elastic.co/t/x-axis-scale-showing-wrong-order-in-heat-map-chart/238379
**Category:** Kibana
**Created:** [June 24, 2020, 5:38am UTC](https://discuss.elastic.co/t/x-axis-scale-showing-wrong-order-in-heat-map-chart/238379 "2020-06-24T05:38:41Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@Kavin](https://discuss.elastic.co/u/Kavin)
#### Post date: [June 24, 2020, 5:38am UTC](https://discuss.elastic.co/t/x-axis-scale-showing-wrong-order-in-heat-map-chart/238379/1 "2020-06-24T05:38:41Z")
I have created a 'heat map' chart for 'Day of Week' vs 'Time of Day' with the data 'No. of Sessions'. Inorder to get the correct alignment for 'Day of Week' (Monday,Tuesday,Wednersday......), I have created a separate scripted field to map Monday for 1, Tuesday for 2,....etc. and I achieved that.
But, for Time of Week which is a scripted field data, I am seeing wrong scale like 3 in the middle and 0 and 2 at the end though I chose Custom metric
---
### Author:  [@matw](https://discuss.elastic.co/u/matw)
#### Post date: [June 24, 2020, 7:54am UTC](https://discuss.elastic.co/t/x-axis-scale-showing-wrong-order-in-heat-map-chart/238379/2 "2020-06-24T07:54:36Z")
Hi
This should work, just tested with our demo data, which version of Kibana are you using?
Thx & Best,
Matthias
---
### Author:  [@Kavin](https://discuss.elastic.co/u/Kavin)
#### Post date: [June 24, 2020, 8:15am UTC](https://discuss.elastic.co/t/x-axis-scale-showing-wrong-order-in-heat-map-chart/238379/3 "2020-06-24T08:15:45Z")
Hi matw, Thank you so much for your response. The version I am using is,
[elk-server@insanalyticsdev121026 ~]$ /usr/share/kibana/bin/kibana --version
7.7.1
I also doubt whether the terms and sorting that I used for Y-axis could've affected the structure.
Thanks!
---
### Author:  [@matw](https://discuss.elastic.co/u/matw)
#### Post date: [June 26, 2020, 5:24am UTC](https://discuss.elastic.co/t/x-axis-scale-showing-wrong-order-in-heat-map-chart/238379/4 "2020-06-26T05:24:05Z")
Yes, x-axis works, could you share a screen that displays all you y-axis settings? many thx
---
### Author:  [@matw](https://discuss.elastic.co/u/matw)
#### Post date: [June 26, 2020, 5:39am UTC](https://discuss.elastic.co/t/x-axis-scale-showing-wrong-order-in-heat-map-chart/238379/5 "2020-06-26T05:39:37Z")
Have a look here, seems there is a workaround for this:
> [@Heatmap X-axis number sorting issue](https://discuss.elastic.co/t/heatmap-x-axis-number-sorting-issue/238627):
>
> Continuing the discussion from [Heatmap X-Axis - Simple number sorting issue](https://discuss.elastic.co/t/heatmap-x-axis-simple-number-sorting-issue/165722): I am facing a similar issue. Is there a solution for this? [image]
---
### Author:  [@Kavin](https://discuss.elastic.co/u/Kavin)
#### Post date: [June 26, 2020, 5:43am UTC](https://discuss.elastic.co/t/x-axis-scale-showing-wrong-order-in-heat-map-chart/238379/6 "2020-06-26T05:43:56Z")
Yeah. That helped. Thank you matw 🙂
---
### Author:  [@matw](https://discuss.elastic.co/u/matw)
#### Post date: [June 26, 2020, 5:45am UTC](https://discuss.elastic.co/t/x-axis-scale-showing-wrong-order-in-heat-map-chart/238379/7 "2020-06-26T05:45:37Z")
ah it was you, who posted again 😃, so my advise was to look at your own posting 😃
---
### Author:  [@Kavin](https://discuss.elastic.co/u/Kavin)
#### Post date: [June 26, 2020, 5:48am UTC](https://discuss.elastic.co/t/x-axis-scale-showing-wrong-order-in-heat-map-chart/238379/8 "2020-06-26T05:48:56Z")
I got answer for that question just an hour ago and I fixed that. Just wanted to make you feel good. So, I didn't mention you that it was me 🙂
Have a great day matw!
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 24, 2020, 5:59am UTC](https://discuss.elastic.co/t/x-axis-scale-showing-wrong-order-in-heat-map-chart/238379/9 "2020-07-24T05:59:11Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.