...
| Chart |
|---|
| showShapes | false |
|---|
| timePeriod | Quarter |
|---|
| width | 1200 |
|---|
| categoryLabelPosition | up45 |
|---|
| dataOrientation | vertical |
|---|
| type | line |
|---|
| yLabel | TB |
|---|
| height | 400 |
|---|
|
| SQL |
|---|
| id | mydata |
|---|
| dataSource | mars_apistats |
|---|
| select to_char(month, 'MM/YYYY') as monthyear, CAST(delivered AS FLOAT)/1024^4 as "Delivered" from datasets_stats_monthly where dataset='tigge-global' and month>=date'20061001' 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='tigge-global' and month>=date'20061001' order by month |
|
| Chart |
|---|
| 3D | true |
|---|
| showShapes | false |
|---|
| timePeriod | Quarter |
|---|
| width | 1200 |
|---|
| categoryLabelPosition | up45 |
|---|
| dataOrientation | vertical |
|---|
| type | bar |
|---|
| yLabel | TB |
|---|
| height | 400 |
|---|
|
| SQL |
|---|
| id | mydata |
|---|
| dataSource | mars_apistats |
|---|
| select to_char(month, 'MM/YYYY') as monthyear, CAST(delivered AS FLOAT)/1024^4 as "Delivered" from datasets_stats_monthly where dataset='tigge-global' and month>=date'20061001' 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='tigge-global' and month>=date'20061001' order by month |
|
User requests
(1 original user request could be split to more resulting MARS database retrieval requests shown in the graph below. It depends on MARS data design for given datasets. On average number of the original users requests is about 1/4 of the resulting "user requests" hitting MARS shown here)
...