How can I sort by half hour intervals?
I'm unable to figure out how to sort my card by half hour intervals. It seemed to be fine at first, but when changing date ranges, the intervals shift in seemingly random ways. I have a date field, `contactStart`, that's formatted as YYYY-MM-DD HH:MM:SS (example: 2018-06-18 14:41:28). I've tried the following sorting options with no success:
'contactStart' - minimum and no aggregation
HOUR('contactStart') - minimum and no aggregation
FLOOR('contactStart') - minimum and no aggregation
Please note, my X-Axis must be sorted in half hour intervals, so I've applied the following Beast Mode:
CONCAT(Hour(`contactStart`),':',CASE WHEN MINUTE(`contactStart`)>=30 THEN '30' ELSE '00' END)
Any solution or guidance would be greatly appreciated!