Sorting x axis on visualisation

[nougatitati]

Hi,

This is a problem I can see other people have had on the forums (here and here), but neither deal with timestamps on the x-axis.

I have this visualisation of frequencies per hour of the day. I want the x-axis sorted from 00:00 to 23:00. As you can see, it is not sorted, even though I have selected 'sort numerically'.

How can I sort these items in my visualisation?

[sugathirajkumar]

share your file .. Try to use dual otherwise

[cpomeren003]

You could use sort by expression, and make a custom expression like this:

if(hourOfTheDay = '00:00', 1,
if(hourOfTheDay = '01:00', 2,
if(hourOfTheDay = '02:00', 3,
if(hourOfTheDay = '03:00', 4,
if(hourOfTheDay = '04:00', 5,
if(hourOfTheDay = '05:00', 6,
if(hourOfTheDay = '06:00', 7,
if(hourOfTheDay = '07:00', 8,
if(hourOfTheDay = '08:00', 9,
if(hourOfTheDay = '09:00', 10,
if(hourOfTheDay = '10:00', 11,
if(hourOfTheDay = '11:00', 12,
if(hourOfTheDay = '12:00', 13,
if(hourOfTheDay = '13:00', 14,
if(hourOfTheDay = '14:00', 15,
if(hourOfTheDay = '15:00', 16,
if(hourOfTheDay = '16:00', 17,
if(hourOfTheDay = '17:00', 18,
if(hourOfTheDay = '18:00', 19,
if(hourOfTheDay = '19:00', 20,
if(hourOfTheDay = '20:00', 21,
if(hourOfTheDay = '21:00', 22,
if(hourOfTheDay = '22:00', 23,
if(hourOfTheDay = '23:00', 24))))))))))))))))))))))))

[Mauritz_SA · Accepted solution]

Hi there

Just an observation. It seems like your hour of entry is your second sorting field.

It will sort on the top field first and then break any ties using the second field. Try and drag it to the top.

Regards,

Mauritz

[StarinieriG]

Hi,

you could try to sort by expression

Num(Subfield(field,':',1))