topic Chart Sort Order Weekday & Time in App Development

Chart Sort Order Weekday & Time

CHL — Tue, 17 May 2022 10:07:05 GMT

Hi All,

I have a chart which is aggregating averages (this part works as expected). Although I need this to be over Weekday and Hour. My Dimension for that is:

(WEEKDAY([Time of Complete.Date])&' '& Interval( (HOUR([Time of Complete])) / 24 , 'hh:mm'))

But I cannot get this to sort in any logical order.

Can I get this to work via an expression?

Thanks!

Re: Chart Sort Order Weekday & Time

Or — Tue, 17 May 2022 10:15:23 GMT

You could use a Dual() to get this dimension to sort correctly - currently, the sort will be based on alphabetical sorting since you've created a string (by concatenating the whitespace). Should be something like:

Dual(

(WEEKDAY([Time of Complete.Date])&' '& Interval( (HOUR([Time of Complete])) / 24 , 'hh:mm')),

num(WEEKDAY([Time of Complete.Date])) + (HOUR([Time of Complete]) / 24)

)