I followed Domo tutorial to create a custom sorting https://www.youtube.com/watch?v=QAKgsoRweQM but mine it's not working as I expect
Firts I created a beast mode to transform my column like this:
DATE_FORMAT(`Snapshot`,'%b')
and then I needed to sorting by month
so I try to create another beast mode like this:
(CASE
WHEN DATE_FORMAT(`Snapshot`,'%b') = 'Jan' THEN 1
WHEN DATE_FORMAT(`Snapshot`,'%b') = 'Feb' THEN 2
WHEN DATE_FORMAT(`Snapshot`,'%b') = 'Mar' THEN 3
WHEN DATE_FORMAT(`Snapshot`,'%b') = 'Apr' THEN 4
WHEN DATE_FORMAT(`Snapshot`,'%b') = 'Mai' THEN 5
WHEN DATE_FORMAT(`Snapshot`,'%b') = 'Jun' THEN 6
WHEN DATE_FORMAT(`Snapshot`,'%b') = 'Jul' THEN 7
WHEN DATE_FORMAT(`Snapshot`,'%b') = 'Aug' THEN 8
WHEN DATE_FORMAT(`Snapshot`,'%b') = 'Sep' THEN 9
WHEN DATE_FORMAT(`Snapshot`,'%b') = 'Oct' THEN 10
WHEN DATE_FORMAT(`Snapshot`,'%b') = 'Nov' THEN 11
else 12
end )
But when I use the filter the sequence it's not in the right timeline