Show Chart

Last Saved By Ona
Owners [Ona ]
Tags []
Table public.indicator4_9_data
Created By Ona
Changed By Ona
Uuid 3b50b8c5-69a6-2c64-a24a-4fd7e312ff1d
Created On 2021-12-21 06:25:38.495790
Changed On 2021-12-21 06:25:38.495801
Name indicator4_9_details new
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, "table_filter": false, "table_timestamp_format": "%Y-%m-%d %H:%M:%S", "time_grain_sqla": "P1D", "time_range": "Last week", "timeseries_limit_metric": null, "url_params": {}, "viz_type": "table"}
Query Context None
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[indicator4_9_data](id:185)
Schema Perm [UNICEF Cambodia].[public]
Last Saved At 2021-12-21 06:25:38.495801
Certified By None
Certification Details None
Is Managed Externally False
External Url None
Dashboards []
Report Schedules []