Show Chart

Last Saved By Ona
Owners [Ona ]
Tags []
Table summary.domain_five_summary_table
Created By Ona
Changed By None
Uuid 0c6c8524-6fd8-4d0d-3b20-a8e23ac61813
Created On 2021-11-22 13:01:05.310031
Changed On 2024-03-28 08:12:46.415781
Name 5.4 Children living in poor households
Datasource Id 166
Datasource Type table
Datasource Name summary.domain_five_summary_table
Visualization Type big_number_total
Parameters {"adhoc_filters": [{"clause": "WHERE", "comparator": "5.4", "expressionType": "SIMPLE", "filterOptionName": "filter_zg89ls4z5ff_ilihnyh78w", "fromFormData": true, "operator": "==", "sqlExpression": null, "subject": "indicator_no"}], "database_name": "UNICEF Cambodia", "datasource": "2644__table", "datasource_name": "domain_five_summary_table", "granularity_sqla": null, "import_time": 1637586045, "metric": {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": false, "label": "MAX(855396)", "optionName": "metric_37578i54icb_fp9k168454f", "sqlExpression": "MAX(855396)"}, "remote_id": 13706, "schema": "summary", "slice_id": 13706, "subheader": "Children", "time_grain_sqla": "P1D", "time_range": "Last week", "url_params": {}, "viz_type": "big_number_total", "y_axis_format": ","}
Query Context {"datasource":{"id":166,"type":"table"},"force":false,"queries":[{"time_range":"Last week","granularity":null,"filters":[{"col":"indicator_no","op":"==","val":"5.4"}],"extras":{"time_grain_sqla":"P1D","having":"","where":""},"applied_time_extras":{},"columns":[],"metrics":[{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":false,"label":"MAX(855396)","optionName":"metric_37578i54icb_fp9k168454f","sqlExpression":"MAX(855396)"}],"annotation_layers":[],"series_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{}}],"form_data":{"adhoc_filters":[{"clause":"WHERE","comparator":"5.4","expressionType":"SIMPLE","filterOptionName":"filter_zg89ls4z5ff_ilihnyh78w","fromFormData":true,"operator":"==","sqlExpression":null,"subject":"indicator_no"}],"database_name":"UNICEF Cambodia","datasource":"166__table","datasource_name":"domain_five_summary_table","granularity_sqla":null,"import_time":1637586045,"metric":{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":false,"label":"MAX(855396)","optionName":"metric_37578i54icb_fp9k168454f","sqlExpression":"MAX(855396)"},"remote_id":13706,"schema":"summary","slice_id":1116,"subheader":"Children","time_grain_sqla":"P1D","time_range":"Last week","url_params":{},"viz_type":"big_number_total","y_axis_format":",","force":false,"result_format":"json","result_type":"full"},"result_format":"json","result_type":"full"}
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[domain_five_summary_table](id:166)
Schema Perm [UNICEF Cambodia].[summary]
Last Saved At 2021-11-22 13:01:05.310042
Certified By None
Certification Details None
Is Managed Externally False
External Url None
Dashboards [Dashboard<34>]
Report Schedules []