Show Chart

Last Saved By Ona
Owners [Ona ]
Tags []
Table english_views.domain_5_data_trend
Created By Ona
Changed By Ona
Uuid 854f17c5-6d12-464c-84b0-c41684971ec9
Created On 2021-11-24 06:05:58.694806
Changed On 2021-11-24 06:06:50.959896
Name Domain 5 Data
Datasource Id 191
Datasource Type table
Datasource Name english_views.domain_5_data_trend
Visualization Type table
Parameters {"adhoc_filters": [], "align_pn": false, "all_columns": [], "color_pn": true, "datasource": "191__table", "granularity_sqla": null, "groupby": ["province"], "include_search": false, "include_time": false, "metrics": [{"aggregate": "SUM", "column": {"column_name": "poor_level1", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 2326, "is_dttm": false, "optionName": "_col_poor_level1", "type": "INTEGER", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "poor_level1", "optionName": "metric_adiafkgu196_w13y5fy2kie", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "poor_level2", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 2327, "is_dttm": false, "optionName": "_col_poor_level2", "type": "INTEGER", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "poor_level2", "optionName": "metric_p942wa7qip_omvszd4hmla", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "poor_level3", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 2328, "is_dttm": false, "optionName": "_col_poor_level3", "type": "INTEGER", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "poor_level3", "optionName": "metric_ofs1xqbspj_kdwe9y9pkdl", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "children_detention", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 2329, "is_dttm": false, "optionName": "_col_children_detention", "type": "INTEGER", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "detention", "optionName": "metric_ix7ziaamc9p_jtpzl6f4s3", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "living_prison", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 2330, "is_dttm": false, "optionName": "_col_living_prison", "type": "INTEGER", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "prison", "optionName": "metric_k3aa5fdzfy_q853f7kocaa", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "injured", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 2331, "is_dttm": false, "optionName": "_col_injured", "type": "INTEGER", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "injured", "optionName": "metric_v4uyrxehf_i6zt7d0ry38", "sqlExpression": null}], "order_by_cols": [], "order_desc": true, "page_length": 0, "percent_metrics": [], "row_limit": 10000, "slice_id": 1150, "table_filter": false, "table_timestamp_format": "%Y-%m-%d %H:%M:%S", "time_grain_sqla": "P1D", "time_range": "No filter", "timeseries_limit_metric": null, "url_params": {}, "viz_type": "table"}
Query Context None
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[domain_5_data_trend](id:191)
Schema Perm [UNICEF Cambodia].[english_views]
Last Saved At 2021-11-24 06:06:50.959896
Certified By None
Certification Details None
Is Managed Externally False
External Url None
Dashboards []
Report Schedules []