Closed gl1000007 closed 11 years ago
too complicated. change to simple answer count.
Can't you run a query for list IDs that linked to a certain question ID? That's all there is to it, assuming that every candidate is linked to a list. If still complicated, please explain why, including any relevant constraints.
it's complicated because it's a number that has no intuitive meaning to the user - they know what an answer count is, they don't know what a response rate % means. Also the calculation is very heavy on the db - checking every question for entity, then every question all answers and who answered etc, which is calculated every time a page is loaded...
Simple answer count.
כמו לגבי תצוגת מועמדים רשומים להבנתי, אם לא ניתן לשינוי מהיר, עדיף למחוק זמנית מאשר להציג כך
Existing method: % of (sum of questions * sum of candidates) That leads to:
New calculation method (proposal): 100% = at least one answer from every list, to every question. For that matter, a "Single List" (רשימת יחיד) is also a list. That single answer can be written by the candidate for mayor, or by someone on their list.
what do you think?