One of the interesting challenges when exploring the Redash visualisations, is not having a handy source of data that fits well with them (for learning).
The nifty looking Choropleth maps are a case in point. They look interesting, but there’s no example data provided for playing with.
So, created some and uploaded it here for people to use:
That’s the (real) daily users count for DB Browser for SQLite, from when we first started measuring through to a few days ago.
An example query to use with it (via the URL and Query Mapper data sources) is:
SELECT country, users FROM query_6 WHERE date = '2019-04-22'
query_6 being the ID number of the URL data source created for it. When using this data set, your query number will have a different ID number on the end.
This is the Choropleth (map) visualisation from that query:
The settings used for the visualisation are: