Rank based on 2 metrics?

moneyshot
moneyshot The Valley ⚪️

I created a RANK beast mode on a card. It's currently based on the 2nd column in this screenshot, TOTAL: Current Run.

As you can see, we've got some ties. Is it possible to (forgive the layman terms) create a tiebreaker of sorts? So if there's a tie in one metric, it then looks at another to make a final determination on rank?


Thanks for any help you can provide!

Best Answer

Answers

  • moneyshot
    moneyshot The Valley ⚪️

    More like Mark BAD@SS. That did the trick. Only took my caveman brain a few tries to get it humming.

    If anyone reading this needs a hand with the syntax, here's an example. In my case I needed to sum up two different metrics, one for count (Field) and a tiebreaker for size (Field 2).

    Thanks again @MarkSnodgrass!


  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🥷

    @moneyshot glad I could help!

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.