Change Legend Order

b_rad
b_rad Contributor

Hi,

I have a multi line chart in which I have source as a line series.


Currently in the legend the source name is sorted in alphabetical order. However I want it sorted by sum(metric) descending order. Is this currently possible in Domo?


Thanks

Best Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Hi @b_rad

    Put the metric in the Sort section of your card in analyzer (and make sure you use the SUM aggregation on it - also select ascending or descending as needed)

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • b_rad
    b_rad Contributor
    edited March 2021 Answer ✓

    @GrantSmith

    Actually you are right. The only other thing I had do was to add the date field (x-axis field) first to the sort and then add the sum(metric) sort.


    Thanks a lot!!

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Hi @b_rad

    Put the metric in the Sort section of your card in analyzer (and make sure you use the SUM aggregation on it - also select ascending or descending as needed)

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • b_rad
    b_rad Contributor
    edited March 2021


  • b_rad
    b_rad Contributor
    edited March 2021 Answer ✓

    @GrantSmith

    Actually you are right. The only other thing I had do was to add the date field (x-axis field) first to the sort and then add the sum(metric) sort.


    Thanks a lot!!