Versions Compared

Old Version 2

changes.mady.by.user Richard Mladek

Saved on

compared with

New Version 3

changes.mady.by.user Richard Mladek

Saved on

Key

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

...

Chart
showShapesfalse
timePeriodQuarter
width1200
categoryLabelPositionup45
dataOrientationvertical
typebar
yLabelTB
height400


SQL
idmydata
dataSourcemars_apistats
select  to_char(month, 'MM/YYYY') as monthyear, CAST(delivered AS FLOAT)/1024^4 as "delivered" from datasets_stats_monthly where dataset='yopp' and month>=date'2017070120170101' order by month ;
select  to_char(month, 'MM/YYYY') as monthyear, CAST(retrieved AS FLOAT)/1024^4 as "retrieved" from datasets_stats_monthly where dataset='yopp' and month>=date'2017070120170101' order by month


Users

  • user requests: number of MARS retrieval requests based on original user request (each user request leads usually to more MARS retrieval requests depending on the required period, parameters, level types etc)
  • active users: users with at least 3 requests in given month

...