Custom Sort in bar charts

Cintia
Cintia Member
edited March 2023 in Charting

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

Best Answer

  • MichelleH
    MichelleH Coach
    Answer ✓

    @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.

Answers

  • MichelleH
    MichelleH Coach
    Answer ✓

    @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.

  • Cintia
    Cintia Member

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

  • MichelleH
    MichelleH Coach

    @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
    Cintia Member

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

  • MichelleH
    MichelleH Coach

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

  • Cintia
    Cintia Member
    image.png image.png


  • MichelleH
    MichelleH Coach

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

  • Cintia
    Cintia Member
    edited March 2023

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

  • MichelleH
    MichelleH Coach

    @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.

Categories