Hi, I'm running your app for a World Cup competition with family and friends. Although technically I don't think it's a sweepstake as there is some degree of skill involved.
I really like it and it looks like it's going to be a good bit of fun to add to the competition.
I would really like to see two things added if possible.
A) Some fun stats on what's been picked, or maybe just a page of stats as I guess fun is subjective and not easy to define in software. E.g. which teams have been picked as the tournament winner and by how many, same for groups. Maybe a fun way to do it is to show outliers and similarities, e.g. for Tournament winners on my instance we have 4 votes each for Spain, England, Argentina and Brazil so evenly spread, we also have 14 for Germany winning Group E and 1 for Ivory Coast so a contrasting outlier. I added everyone to a WhatsApp group so it adds a bit for me to be able to send some info occasionally to the group to keep the interest levels up.
B) Some admin stats, e.g. who hasn't picked everything yet. I added pgadmin to the compose file and ran this query to do it manually but just to give an idea of what I mean see below. Now I know I should really add the tournament_id but I only have one so kept it simple for now. This shows me anyone who hasn't picked a tournament winner and how many group and individual matches they have picked, I can then chase up to remind them to get it sorted.
select u.email, t1.name, count(pg.*), (select count(*) from public.predict_match where user_id = u.id)
from public.user u
left outer join public.predict_tournament pt on u.id = pt.user_id
left outer join public.predict_group pg on u.id = pg.user_id
left outer join public.team t1 on pt.winner_team_id = t1.id
group by u.id, u.email, t1.name
order by 4
Thanks for an awesome app just in time for the WC
Hi, I'm running your app for a World Cup competition with family and friends. Although technically I don't think it's a sweepstake as there is some degree of skill involved.
I really like it and it looks like it's going to be a good bit of fun to add to the competition.
I would really like to see two things added if possible.
A) Some fun stats on what's been picked, or maybe just a page of stats as I guess fun is subjective and not easy to define in software. E.g. which teams have been picked as the tournament winner and by how many, same for groups. Maybe a fun way to do it is to show outliers and similarities, e.g. for Tournament winners on my instance we have 4 votes each for Spain, England, Argentina and Brazil so evenly spread, we also have 14 for Germany winning Group E and 1 for Ivory Coast so a contrasting outlier. I added everyone to a WhatsApp group so it adds a bit for me to be able to send some info occasionally to the group to keep the interest levels up.
B) Some admin stats, e.g. who hasn't picked everything yet. I added pgadmin to the compose file and ran this query to do it manually but just to give an idea of what I mean see below. Now I know I should really add the tournament_id but I only have one so kept it simple for now. This shows me anyone who hasn't picked a tournament winner and how many group and individual matches they have picked, I can then chase up to remind them to get it sorted.
Thanks for an awesome app just in time for the WC