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.
There is a :group by function. Group by the the answers, using the sum of votes as the aggregate.
Thanks very much @alan.mackintosh1
I’ve given it a few goes but everything keeps disappearing …will keep at it though!
Do you know if this action should be carried out on the RG itself or individual cells?
on the repeating group. It should be Search for Answers: grouped by (Answer, aggregate by sum of votes)
The value will use do search for:count
:groupby is a better option but both work
Thanks again Alan. I’ve given it another go but not working - can you tell from the inspector where I’ve gone wrong? Cheers
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.
Tried suggestion by @chris.williamson1996 but getting error (see image).
Unfortunately I’m getting an error…
The :count should be for the text element that will display the count in each rep group cell.
That expression should end after :unique elements.
Data source for RG is Search for Answers:unique elements
But inspector doesn’t give “count” as an option in rep group cell for vote count…
Is your data type a number and not a “text”. I think :sum is probably the more suitable option.
To clarify each cell in your repeating group should have a text with the Answer displayed, then a separate text with the Votes sum.
I would use a grouping on the answer field as a data source. I would use an aggregation of count
Then you could display
this cells groupings answer and
this cells groupings count
The issue you’ll run into here is if two users answer very similarly but spell their answers differently. The bubble engine won’t account for this.
It means that its the correct approach.
Thanks Alan for continuing to look at this.
The data type is an “answer” so I’ve got as text. As I say, the inspector doesn’t offer “sum” as an option, in either the “rank” or “votes” cells.
Thanks. I think I tried that but it didn’t work
Thanks again Jared. I shall manually aggregate synonymous answers in the database.