It all depends on the structure of your data. can you provide some data (even just some dummy data that makes sense to you) so someone can show you how to do it ?
Each row of my data represents an analytics event (the player did something we want to track) and contains a Player ID and a Timestamp. If it is their initial login event, I record the timestamp as Start Time. Because of the way we're reporting and filtering data, the Start Time may be NULL.
Attached is some sample data.
What's your definition of retention though ?
I would have thought it was something around how many continuous days (or maybe how many times in the same week) do they return to the game ? So you would have to have that sort of history in the data.
Sorry, I know you supplied some data, but it's not enough to actually create what you want because all players are only there once ..... or I don't understand the data properly
Okay, sorry about that. I've attached something more like what I end up with in the raw data.
For us, retention does not mean they logged in every single day in succession. So, the question I want answered is this:
Of the players who started 1 day ago, how many logged in today?
Of the players who started 7 days ago, how many logged in today?
Of the players who started 14 days ago, how many logged in today?
Of the players who started 30 days ago, how many logged in today?
Then, I want that data displayed over time, so I can see how the answers to those questions have changed from day to day.