In my app, users send 20 datas -which is number- to a list.
The data is 1 to 5, like a questionnaire.
As you know, a list cannot contain the same numbers.
In order to save 20datas, I devised a way to add “5” to the second data and “10” to the third data.
Now, many users have answered these questionnaires, then I’d like to average the 1st data. But I got stuck now.
example
user A’s list (5,9,13,16)
user B’s list (1,6,14,19)
user C’s list (3,7,13,16)
average the first item in the list is (5+1+3)/3=3.
Is it possible to average this kind of list?
I’d really appreciate it if you have any solution.
You’ve really over complicated it. I’d recommend adding an Answer data type which has the User, their answer (number) and the question they’re answering (Question). Better in every single way. Do a search for Answers:each items number:average would be all you need.
Thank you for your heartful advise. When I Stard developing, I tried what you advised. but, because of our use (many user send datas at the same time in a HR training), the number of user times 20 datas have sent. Then, bubble was stopped by overload.
Anyway I really thank your kindness.
As a desperate measures, I chose using a list of things.
This is called technical debt, and it’ll be fixed much easier and cheaper early on.
You just need a backend workflow and schedule it with Schedule API workflow on a list so that you create an entry for each answer. Trust me, you need to do this.
