You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
We would like to get stats for a user's connections scores over a week.
First - we need to define what does that look like. What kind of stats do we care about?
Some easy ones are - this user clutched up and did their connections in 7 guesses. We can add this to some # of Clutches metric. Another easy one is adding # of Perfect Scores
Second- after getting these stats, we want to be able to store these stats for a given week in our postgres database.
Some notes on this is we want to try minimize number of tables we have. Currently, we have one table just for all connections messages. I think flushing this out every week is probably the right move. We will also need a global table, to store metadata, like "What is Today's Connection Number". We then probably want to store a user's all time scores + weekly score together.
The text was updated successfully, but these errors were encountered:
We would like to get stats for a user's connections scores over a week.
First - we need to define what does that look like. What kind of stats do we care about?
Some easy ones are - this user clutched up and did their connections in 7 guesses. We can add this to some
# of Clutches
metric. Another easy one is adding# of Perfect Scores
Second- after getting these stats, we want to be able to store these stats for a given week in our postgres database.
Some notes on this is we want to try minimize number of tables we have. Currently, we have one table just for all connections messages. I think flushing this out every week is probably the right move. We will also need a global table, to store metadata, like "What is Today's Connection Number". We then probably want to store a user's all time scores + weekly score together.
The text was updated successfully, but these errors were encountered: