How to get top 3 integer values in ODK

[noman.s2325]

1. What is the issue? Please be detailed.
Hi I have a question regarding this, if you can help..
I have 20 integer questions i.e. Brand-1, Brand-2, Brand-3 … Brand-20 and I am capturing the ratings from user for these brands now I want to ask the reason of top three rated brands can you please tell me how to achieve this because max function only get higher value not 2nd higher value and third higher value and i also want to show the name of these brand so user know the brand for which he is answering

please note relevance is applied to the brands so user can rate 3 brands or more than 3 brands and ratting can be duplicate, so if user rate 10 for 3 brands then these
3 brands will be shown in next question

immediate solution will be really appreciated...

Book3.xlsx (9.4 KB)

[chun_hing_yap]

May be this is close to what you are looking for.

You could have brand name and score in repeat group. then use select_one to manually answer the top 3 brands.

Not sure whether calculating the 2nd and 3rd rank can be done easily.

Generate multiple choice alternatives, based on the answers in a repeat

As of pyxform v1.3.1 and XLSForm Online v1.3.1, it is now possible to create a select from a repeat. The documentation is available here. We expect this will be released in Central within the next 2 weeks. This new feature produces exactly the same result as the example XForms modification I shared. Use it with question type select_one ${field_in_repeat} where ${field_in_repeat} is the field you want to use for your select options. Note that the same text used to display each choice will also b…

[wroos]

How would you rank, if in total you have more than 3 rated with same values, please?

[noman.s2325]

the idea is, populate the list in dropdown and user will select the brand according to their choice.