Show Chart

Owners []
Created By None
Changed By None
Created On 2020-06-28 22:40:51.081461
Changed On 2020-06-28 22:40:51.081474
Name Top 10 California Names Timeseries
Datasource Id 3
Datasource Type table
Datasource Name None
Visualization Type line
Parameters { "compare_lag": "10", "compare_suffix": "o10Y", "granularity_sqla": "ds", "groupby": [ "name" ], "limit": "10", "markup_type": "markdown", "metrics": [ { "aggregate": "SUM", "column": { "column_name": "num_california", "expression": "CASE WHEN state = 'CA' THEN num ELSE 0 END" }, "expressionType": "SIMPLE", "label": "SUM(num_california)" } ], "row_limit": 5000, "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": "line" }
Description None
Cache Timeout None
Perm [examples].[birth_names](id:3)
Schema Perm None
Dashboards [Misc Charts]
Email Schedules []