X axis scale showing wrong order in Heat map chart

Elastic Stack Kibana
1

image
image1366×659 75.2 KB

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

image
image1041×291 20.2 KB

2

Hi

This should work, just tested with our demo data, which version of Kibana are you using?

Bildschirmfoto 2020-06-24 um 09.53.42
Bildschirmfoto 2020-06-24 um 09.53.421822×1106 180 KB

Thx & Best,
Matthias

3

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.

image
image1281×482 53.8 KB

image
image1035×546 38.6 KB

image
image1040×293 21.1 KB

Thanks!

4

Yes, x-axis works, could you share a screen that displays all you y-axis settings? many thx

5

Have a look here, seems there is a workaround for this:

6

Yeah. That helped. Thank you matw :slight_smile:

7

ah it was you, who posted again :smiley:, so my advise was to look at your own posting :smiley:

8

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 :slight_smile:
Have a great day matw!