topic Re: first, second and third classified in App Development

first, second and third classified

francescoj_albini — Fri, 09 Sep 2022 07:58:04 GMT

I have to calculate the first, second and third classified of a race based on times. Which function can I use?

Best regards,

francesco

sergio0592 — Fri, 09 Sep 2022 08:18:05 GMT

Hi,

Can you share a sample?

francescoj_albini — Fri, 09 Sep 2022 09:45:01 GMT

I want to know who are the first, second and third who have the lowest time,I don't know what you need more?

I have the fields name, event(race) and time of every athlete

tresB — Fri, 09 Sep 2022 09:51:08 GMT

Try using firstsortedvalue().

Firstsortedvalue(name, time) - first (took least time)

Firstsortedvalue(name, time, 2) - second

...

francescoj_albini — Fri, 09 Sep 2022 10:17:45 GMT

sorry, i solved with fisrtsortedvalue

francescoj_albini — Fri, 09 Sep 2022 10:20:15 GMT

thx, I had already found this function 2 minutes before I read you