Klip Map : Model my source



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?


Please sign in to leave a comment.