Getting the content linked to the minimum/highest value

Just finishing the Coda tutorials, and trying to have a real usecase to practice :slight_smile:

I am building a dashboard about tournament results in role playing games.
I have various table, i would have to get the content linked to the lowest/highest value.

As an example, I would like to know which class got the maximum wins (dwarf) and the minimum wins (mercenary):

Can’t figure out how to deal with the min/max function for that.
Any direction I could search?

Thx :slight_smile:

Not sure if I completely understand what you’re looking for, but it sounds like this could do the trick (just type this anywhere on the canvas):

=[Class].Filter([Wins]=[Wins].Max()) and =[Class].Filter([Wins]=[Wins].Min())

1 Like

That’s perfect!
Thx a lot :slight_smile:

1 Like