I have a table with all my user login.
Timestamp - Country Location - UserID
My Country Location is in 2 digits format. (Ex: CA, US, GB)
I wish to Count the number of login per Country. So I try to make a master table where I summarized my login table as follow:
Country Location - Number of login
But... Well I have no idea how to model a table so I can create a summarized version that I will feed as a datasource for the map. Any help?