| Parameters |
{
"compare_lag": "10",
"compare_suffix": "o10Y",
"granularity_sqla": "ds",
"groupby": [
"name"
],
"limit": "25",
"markup_type": "markdown",
"metrics": [
{
"aggregate": "SUM",
"column": {
"column_name": "num",
"type": "BIGINT"
},
"expressionType": "SIMPLE",
"label": "Births",
"optionName": "metric_11"
}
],
"row_limit": 50,
"since": "100 years ago",
"timeseries_limit_metric": {
"aggregate": "SUM",
"column": {
"column_name": "num_california",
"expression": "CASE WHEN state = 'CA' THEN num ELSE 0 END"
},
"expressionType": "SIMPLE",
"label": "SUM(num_california)"
},
"until": "now",
"viz_type": "table"
}
|
