Getting the content linked to the minimum/highest value

[Jeremie_Abric]

Hello.
Just finishing the Coda tutorials, and trying to have a real usecase to practice

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

[mr_motus]

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())

[Jeremie_Abric]

That’s perfect!
Thx a lot