Custom Sort in bar charts

Cintia · 2023-03-02T11:51:04+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

Accepted answers

MichelleH

@Cintia Is `Snapshot` already being used on the X-axis of your bar chart? If so, you shouldn't need to sort by date since Domo should already know to sort dates chronologically. If you are sorting by other fields as well, that could potentially mess with your date sorting.

All comments

MichelleH

Cintia

@MichelleH Yes, I need it to be "implemented" then "firm" and "potential" how can I use both sorting?

MichelleH

@Cintia In that case, you would need to sort first by MIN of `Snapshot` then by this beast mode:

case 
     when `Series` = 'Implemented' then 1
     when `Series` = 'Firm' then 2
     when `Series` = 'Potential' then 3
end

Cintia

@MichelleH When I do this the sorting by month keeps not working

MichelleH

@Cintia Can you please send a screenshot of what you see in analyzer (hiding any sensitive info)?

Cintia

MichelleH

@Cintia It looks like you are sorting based on a COUNT of both of your fields. Try changing the aggregation to MIN instead.

Cintia

@MichelleH both of them in MIN? or one in count and the other in MIN?

MichelleH

@Cintia Both of them MIN. Changing the aggregation to MIN ensures that your data is sorted based on the value that you assigned in the beast modes (1, 2, 3, etc.), whereas COUNT only considers whether there is a value but does not care what the value is.