Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Chart
showShapesfalse
width1200
categoryLabelPositionup45
dataOrientationvertical
typebar
yLabelNr of requests
colors#FFAB00
height300


SQL
idmydata
dataSourcemars_apistats
select  to_char(month, 'MM/YYYY') as monthyear, requests as "user requests" from datasets_stats_monthly where dataset='s2s' and month>=date'20150501' order by month;


Number of active users

Users with at least 1 request in given month

Chart
showShapesfalse
width1200
categoryLabelPositionup45
dataOrientationvertical
typebar
yLabelNr of users
colors#36B37E
height300


SQL
idmydata
dataSourcemars_apistats
SELECT to_char(month, 'MM/YYYY') as monthyear, count(DISTINCT username) as "active users"
FROM  users_stats_monthly 
WHERE dataset='s2s' AND month>=date'20150501' 
AND username IN (
      SELECT username                        
      FROM  users_stats_monthly
      WHERE dataset='s2s'
      GROUP BY username
      HAVING sum(requests) >= 1
      )
GROUP BY month
ORDER BY month;


...