Page History

...

Expand

title	Monthly sums

Data volumes

Volume of data retrieved from MARS before post-processing vs volume of data delivered to users after post-processing.

Chart

showShapes	false
timePeriod	Quarter
width	1200
categoryLabelPosition	up45
dataOrientation	vertical
type	bar
yLabel	TiB
height	400

SQL

id	mydata
dataSource	mars_apistats_new

select  to_char(month, 'MM/YYYY') as monthyear, to_char(delivered/1024^4, 'FM999,999,999,990.9999') as "delivered" from datasets_stats_monthly where dataset='s2s' and month>=date'2015-05-01' order by month ;
select  to_char(month, 'MM/YYYY') as monthyear, to_char(retrieved/1024^4, 'FM999,999,999,990.9999') as "retrieved" from datasets_stats_monthly where dataset='s2s' and month>=date'2015-05-01' order by month

Number of requests

Chart

showShapes	false
width	1200
categoryLabelPosition	up45
dataOrientation	vertical
type	bar
yLabel	Nr of requests
colors	#FFAB00
height	300

SQL

id	mydata
dataSource	mars_apistats_new

select  to_char(month, 'MM/YYYY') as monthyear, requests as "user requests" from datasets_stats_monthly where dataset='s2s' and month>=date'2015-05-01' order by month;

Number of active users

Chart

showShapes	false
width	1200
categoryLabelPosition	up45
dataOrientation	vertical
type	bar
yLabel	Nr of users
colors	#36B37E
height	300

SQL

id	mydata
dataSource	mars_apistats_new

SELECT to_char(month, 'MM/YYYY') as monthyear, count(DISTINCT username) as "active users"
FROM  users_stats_monthly 
WHERE dataset='s2s' AND month>=date'2015-05-01' 
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;

Expand

title	Yearly sums

Data volumes

Volume of data retrieved from MARS before post-processing vs volume of data delivered to users after post-processing.

Chart

showShapes	false
timePeriod	Quarter
width	1200
categoryLabelPosition	up45
dataOrientation	vertical
type	bar
yLabel	TiB
height	400

SQL

id	mydata
dataSource	mars_apistats_new

select  to_char(month, 'YYYY') as year, to_char(sum(delivered/1024^4), 'FM999,999,999,990.9999') as "delivered" from datasets_stats_monthly where dataset='s2s' and month>=date'2015-01-01' group by year order by year ;
select  to_char(month, 'YYYY') as year, to_char(sum(retrieved/1024^4), 'FM999,999,999,990.9999') as "retrieved" from datasets_stats_monthly where dataset='s2s' and month>=date'2015-01-01' group by year order by year

Number of requests

Chart

showShapes	false
width	1200
categoryLabelPosition	up45
dataOrientation	vertical
type	bar
yLabel	Nr of requests
colors	#FFAB00
height	300

SQL

id	mydata
dataSource	mars_apistats_new

select  to_char(month, 'YYYY') as year, sum(requests) as "user requests" from datasets_stats_monthly where dataset='s2s' and month>=date'2015-01-01' group by year order by year;

Number of active users

Chart

showShapes	false
width	1200
categoryLabelPosition	up45
dataOrientation	vertical
type	bar
yLabel	Nr of users
colors	#36B37E
height	300

SQL

id	mydata
dataSource	mars_apistats_new

SELECT to_char(month, 'YYYY') as year, count(DISTINCT username) as "active users"
FROM  users_stats_monthly 
WHERE dataset='s2s' AND month>=date'2015-01-01' 
AND username IN (
      SELECT username                        
      FROM  users_stats_monthly
      WHERE dataset='s2s'
      GROUP BY username
      HAVING sum(requests) >= 1
      )
GROUP BY year
ORDER BY year;

Users per country

only countries with at least 5 active users are shown

...

Space shortcuts

Page tree

Versions Compared

Old Version 4

New Version 5

Key

Users per country