Show Chart

Last Saved By Ona
Owners [Ona ]
Tags []
Table temp.domain_four_summary_table_update_view
Created By Ona
Changed By None
Uuid 657d7fce-fa0c-272b-2905-dd45630451e1
Created On 2021-11-22 13:01:04.646539
Changed On 2024-03-28 09:55:44.287272
Name Indicators
Datasource Id 174
Datasource Type table
Datasource Name temp.domain_four_summary_table_update_view
Visualization Type table
Parameters {"datasource": "3574__table", "viz_type": "table", "slice_id": 13695, "url_params": {}, "granularity_sqla": null, "time_grain_sqla": "P1D", "time_range": "Last week", "groupby": [], "metrics": [], "percent_metrics": [], "timeseries_limit_metric": null, "row_limit": 25, "include_time": false, "order_desc": true, "all_columns": ["indicator_no", "sub-indicator", "indicator_updated"], "order_by_cols": ["[\"indicator_number\", true]", "[\"sub-indicator\", true]"], "adhoc_filters": [{"expressionType": "SQL", "sqlExpression": "breakdown_indicator IS NULL OR breakdown_indicator = 'Physical violence'", "clause": "WHERE", "subject": null, "operator": null, "comparator": null, "fromFormData": true, "filterOptionName": "filter_fb80yhqh87_b0qxqaq1f6b"}], "table_timestamp_format": "%Y-%m-%d %H:%M:%S", "page_length": null, "include_search": false, "table_filter": false, "align_pn": false, "color_pn": true, "remote_id": 13695, "datasource_name": "domain_four_summary_table_update_view", "schema": "temp", "database_name": "UNICEF Cambodia", "import_time": 1637586045}
Query Context {"datasource":{"id":174,"type":"table"},"force":false,"queries":[{"time_range":"Last week","granularity":null,"filters":[],"extras":{"time_grain_sqla":"P1D","having":"","where":"(breakdown_indicator IS NULL OR breakdown_indicator = 'Physical violence')"},"applied_time_extras":{},"columns":["indicator_no","sub-indicator","indicator_updated"],"metrics":[],"orderby":[["indicator_number",true],["sub-indicator",true]],"annotation_layers":[],"row_limit":25,"series_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{},"post_processing":[]}],"form_data":{"adhoc_filters":[{"clause":"WHERE","comparator":null,"expressionType":"SQL","filterOptionName":"filter_fb80yhqh87_b0qxqaq1f6b","fromFormData":true,"operator":null,"sqlExpression":"breakdown_indicator IS NULL OR breakdown_indicator = 'Physical violence'","subject":null}],"align_pn":false,"all_columns":["indicator_no","sub-indicator","indicator_updated"],"color_pn":true,"database_name":"UNICEF Cambodia","datasource":"174__table","datasource_name":"domain_four_summary_table_update_view","granularity_sqla":null,"groupby":[],"import_time":1637586045,"include_search":false,"include_time":false,"metrics":[],"order_by_cols":["[\"indicator_number\", true]","[\"sub-indicator\", true]"],"order_desc":true,"page_length":null,"percent_metrics":[],"remote_id":13695,"row_limit":25,"schema":"temp","slice_id":1107,"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","force":false,"result_format":"json","result_type":"full"},"result_format":"json","result_type":"full"}
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[domain_four_summary_table_update_view](id:174)
Schema Perm [UNICEF Cambodia].[temp]
Last Saved At 2021-11-22 13:01:04.646549
Certified By None
Certification Details None
Is Managed Externally False
External Url None
Dashboards [Dashboard<34>]
Report Schedules []