Show Chart

Owners [Ona ]
Created By Ona
Changed By Ona
Created On 2021-11-22 16:25:52.094384
Changed On 2021-12-20 13:26:01.262560
Name indicator4_9_details
Datasource Id 185
Datasource Type table
Datasource Name public.indicator4_9_data
Visualization Type table
Parameters { "adhoc_filters": [], "align_pn": false, "all_columns": [], "color_pn": true, "datasource": "185__table", "granularity_sqla": null, "groupby": [ "province" ], "include_search": false, "include_time": false, "metrics": [ { "aggregate": "SUM", "column": { "column_name": "old_class_a", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 2271, "is_dttm": false, "optionName": "_col_old_class_a", "type": "BIGINT", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "old_cases_a", "optionName": "metric_frzokv5wgvu_gz753alp2od", "sqlExpression": null }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "all_new_b", "optionName": "metric_npdsc7m0b1a_yuicl0e9dq", "sqlExpression": "SUM(case when all_new_b is null then 0 else all_new_b end::NUMERIC)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "closed", "optionName": "metric_wgkgvhreoc_2qy2mut7bnj", "sqlExpression": "SUM(case when total_cases_closed is null then 0 ELSE total_cases_closed end::numeric)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "remaining", "optionName": "metric_t6sith9ym1_zss9vq14bv", "sqlExpression": "SUM(case when total_remaining_cases is null then 0 else total_remaining_cases end::numeric)" } ], "order_by_cols": [], "order_desc": true, "page_length": 0, "percent_metrics": [], "row_limit": 10000, "slice_id": 1127, "table_filter": false, "table_timestamp_format": "%Y-%m-%d %H:%M:%S", "time_grain_sqla": "P1D", "time_range": "Last week", "time_range_endpoints": [ "inclusive", "exclusive" ], "timeseries_limit_metric": null, "url_params": {}, "viz_type": "table" }
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[indicator4_9_data](id:185)
Schema Perm [UNICEF Cambodia].[public]
Dashboards []
Email Schedules []