Hello,
fine, it is done like a bubble-sort. (Would be great to have a sort function.)
Just to take care:
- “the highest” can be 1 or all items (with the same max value).
- the values must all be required (= yes)…
(@stephanealoo) Here is another (smarter?) option to get the cases with the highest values, using max(nodeset) function. (See https://docs.opendatakit.org/form-operators-functions/?highlight=max#max.)
Ranking 02.xlsx (13.5 KB)
Unfortunately, the max function only allows a pure nodeset, but nothing like if, numeric or calculation. So, probably max can’t be used to find also top 2 and top 3 value.
Furthermore, it might be difficult to implement the limit (of khasab) to get only 3 top cases in total…
Another idea: Might it be interesting to think about changing the whole structure with the q-questions to a repeat structure?
Update: I tried to deploy the Ranking 02 example, which works well in preview. But creates an error for deployment. I a sorry and forwarded the issue to development.
Kind regards
