Show Chart

Last Saved By Ona
Owners [Ona ]
Tags []
Table 4_1_indicator_summary
Created By Ona
Changed By None
Uuid 86c645b4-b634-e7b0-2122-455669a89266
Created On 2021-11-22 11:49:51.047738
Changed On 2024-04-06 10:43:53.997936
Name Children with at least one type of disability
Datasource Id 97
Datasource Type table
Datasource Name 4_1_indicator_summary
Visualization Type big_number_total
Parameters {"adhoc_filters": [{"clause": "WHERE", "comparator": "'Children with at least one type of disability'", "expressionType": "SIMPLE", "filterOptionName": "filter_egcdol50uvc_vf981m7eqo", "fromFormData": true, "operator": "==", "sqlExpression": null, "subject": "item"}], "datasource": "97__table", "granularity_sqla": null, "header_font_size": 0.3, "metric": {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": false, "label": "SUM(coalesce(\"PwDF_J\",0))", "optionName": "metric_n78gpjtplsg_f3fpdan5fzh", "sqlExpression": "SUM(coalesce(\"PwDF_J\",0))"}, "slice_id": 557, "subheader": "(Source: Administrative records 2018)", "subheader_font_size": 0.125, "time_range": "Last week", "url_params": {}, "viz_type": "big_number_total", "y_axis_format": ","}
Query Context {"datasource":{"id":97,"type":"table"},"force":false,"queries":[{"time_range":"Last week","granularity":null,"filters":[{"col":"item","op":"==","val":"'Children with at least one type of disability'"}],"extras":{"having":"","where":""},"applied_time_extras":{},"columns":[],"metrics":[{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":false,"label":"SUM(coalesce(\"PwDF_J\",0))","optionName":"metric_n78gpjtplsg_f3fpdan5fzh","sqlExpression":"SUM(coalesce(\"PwDF_J\",0))"}],"annotation_layers":[],"series_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{}}],"form_data":{"adhoc_filters":[{"clause":"WHERE","comparator":"'Children with at least one type of disability'","expressionType":"SIMPLE","filterOptionName":"filter_egcdol50uvc_vf981m7eqo","fromFormData":true,"operator":"==","sqlExpression":null,"subject":"item"}],"datasource":"97__table","granularity_sqla":null,"header_font_size":0.3,"metric":{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":false,"label":"SUM(coalesce(\"PwDF_J\",0))","optionName":"metric_n78gpjtplsg_f3fpdan5fzh","sqlExpression":"SUM(coalesce(\"PwDF_J\",0))"},"slice_id":557,"subheader":"(Source: Administrative records 2018)","subheader_font_size":0.125,"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].[4_1_indicator_summary](id:97)
Schema Perm None
Last Saved At 2021-12-15 01:52:27.765968
Certified By None
Certification Details None
Is Managed Externally False
External Url None
Dashboards [Dashboard<31>]
Report Schedules []