Custom Sort - Time

[Anonymous]

Hello,

I created a custom sort order for times of the day: from 12 AM - 11PM.

The sort order appears correct in my table view, but when I try to visualize on a matrix chart, the sequence is out of order. I already selected the hour column and sorted by the custom sort column I created. The order should be from 12AM - 11PM.

I'm not sure what the issue might be. Any idea on what I could be missing?

Thank you,

[mangaus1111]

first select the column [Hour] , then sort it by the column [Hour Sort], then refresh the matrix.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mangaus1111]

Hi @Anonymous ,

Column Tools, then Sort by Colum

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I tried that already, but the hour is still out of order in the matrix