My app asks users questions, such as, “What’s the world’s biggest mistake?”.
All submitted answers appear in a leaderboard of answers - however, when a user gives an answer that’s already been submitted, I can’t work out how to aggregate that answer with the existing duplicate answer (simply by increasing the existing answer’s “vote” count by one)?
Currently, duplicate answers are being listed in ADDITION to the existing entry - see image.
Hmm… this is exactly what I would do.
Are the answers genuinely unique? No extra spaces etc.
Chris.williamson1996 suggestion would also work, search for answers:unique elements.
In the Rep Group, have a text to display the answer, then a text to display Current cell’s Answer’s Vote’s :sum (or count, depending on what works best for your data)
So currently, with the above grouping function implemented, ALL the data from the table disappears so there might be something more fundamentally wrong.
…the two answers I’m trying to aggregate are identical.