...
| Chart |
|---|
| showShapes | false |
|---|
| timePeriod | Quarter |
|---|
| width | 1200 |
|---|
| categoryLabelPosition | up45 |
|---|
| dataOrientation | vertical |
|---|
| type | bar |
|---|
| yLabel | TiB |
|---|
| height | 400 |
|---|
|
| SQL |
|---|
| id | mydata |
|---|
| dataSource | mars_apistats |
|---|
| select to_char(month, 'MM/YYYY') as monthyear, to_char(delivered/1024^4, 'FM999,999,999,990') as "delivered" from datasets_stats_monthly where dataset='tigge-global' and month>=date'2015-01-01' order by month ;
select to_char(month, 'MM/YYYY') as monthyear, to_char(retrieved/1024^4, 'FM999,999,999,990') as "retrieved" from datasets_stats_monthly where dataset='tigge-global' and month>=date'2015-01-01' order by month |
|
Delivered data volume (zoom from the previous graph)
| Chart |
|---|
| showShapes | false |
|---|
| timePeriod | Quarter |
|---|
| width | 1200 |
|---|
| categoryLabelPosition | up45 |
|---|
| dataOrientation | vertical |
|---|
| type | bar |
|---|
| yLabel | TiB |
|---|
| colors | #008DA6, white |
|---|
| height | 300 |
|---|
|
| SQL |
|---|
| id | mydata |
|---|
| dataSource | mars_apistats |
|---|
| select to_char(month, 'MM/YYYY') as monthyear, to_char(delivered/1024^4, 'FM999,999,999,990') as "delivered" from datasets_stats_monthly where dataset='tigge-global' and month>=date'2015-01-01' order by month ;
|
|
...