Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 19

...

Chart
stackedtrue
width900
dataOrientationvertical
opacity75
height700


SQL
idmydata
dataSourcemars_apistats
SELECT profile_country.name, count(DISTINCT auth_user.username) as total_users
    FROM  profile_country
         RIGHT JOIN profile_profile ON profile_profile.country_id = profile_country.id
         RIGHT JOIN auth_user ON auth_user.id = profile_profile.user_id
         RIGHT JOIN users_stats_monthly ON users_stats_monthly.username = auth_user.username
    WHERE users_stats_monthly.dataset='tigge-lam' and users_stats_monthly.month>=date'2013-01-01'
GROUP BY profile_country.name
HAVING count(DISTINCT auth_user.username)>=1
ORDER BY total_users DESC
Section
Column

Image Removed

At least one active user

Column

Image Removed

At least one active user with colour density depending on the number of active users (from 1 to 742)