I’m trying to sort a bat graphs columns by weekday, the label is Text (days of week, Monday, Tuesday, etc.) but I have set the sort by to use a numeric day of week column (0,1,2, etc.)
group by weekday, weekdayname;
However, the ordering of the visualisation is seemingly random:
If it makes any difference (It shouldn’t I would assume) all the tables (fact and dimensions) are in Redshift.
Is this a bug?