Hour of Day dimension

[a_akande]

Hi, I currently have my hour of days listed out like below. How can I sort in order of actual hours so 1am, 2am, 3am etc...thanks 🙂

[FarazHusain]

I tested this on my end, but it is showing as expected. Is there any sorting applied based on metrics added to the report?

[a_akande · Accepted solution]

I retried it & it worked, thanks!!

[Jennifer_Dungan]

Hi @a_akande,

I can replicate your example if instead of pulling the "Hour of Day" over as a whole (dynamically populated values in the breakdown), if I open "Hour of Day" to see the values, then select the list of items.

Or if after I bring in the full dimension, I use the "display only selected rows" function.

The difference is, that when the full dynamic dimension is used, the items will sort accordingly... In the other two scenarios, where the list is essentially curated, each item acts more like a quick segment than a dynamic dimension, meaning that the sort order is now restricted to alphabetical.

In these two scenarios, you are also more likely to have messed up totals, as de-duplication will no longer apply (segments as breakdowns vs dimensions).

My assumption, based on your issue, is that you have a curated list of quick segments, hence the behaviour.

You should be able to fix it by replacing the breakdown with the full Hour of Day dimension: