UNICEF Cambodia Discover

Edit Chart

Name
Description	The content here can be displayed as widget headers in the dashboard view. Supports markdown
Visualization Type
Owners
Dashboards
Parameters	{ "adhoc_filters": [ { "clause": "WHERE", "comparator": "Province", "expressionType": "SIMPLE", "filterOptionName": "filter_89jxvkcqi4q_nz5p6xw711q", "fromFormData": true, "isExtra": false, "operator": "==", "sqlExpression": null, "subject": "category" } ], "align_pn": false, "all_columns": [], "color_pn": true, "datasource": "190__table", "granularity_sqla": null, "groupby": [ "category_value", "year", "year_new" ], "include_search": false, "include_time": false, "metrics": [ { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "men", "optionName": "metric_oth5g7pmubc_kcfvtoqnvge", "sqlExpression": "SUM(case when wife_beating_justified_for_at_least_one_specific_reason_men is null then 0 else wife_beating_justified_for_at_least_one_specific_reason_men end::numeric)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "women", "optionName": "metric_9ci6k0opgnj_mvgsklmdwz", "sqlExpression": "SUM(case when wife_beating_justified_for_at_least_one_specific_reason_women is null then 0 else wife_beating_justified_for_at_least_one_specific_reason_women end::numeric)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "burns_men", "optionName": "metric_8l673k8rxwl_pmh1frjsx", "sqlExpression": "SUM(case when wife_beating_justified_if_she_burns_the_food_men is null then 0 else wife_beating_justified_if_she_burns_the_food_men end::numeric )" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "burns_women", "optionName": "metric_hf76s7myqof_ual0rauug", "sqlExpression": "SUM(case when wife_beating_justified_if_she_burns_the_food_women is null then 0 else wife_beating_justified_if_she_burns_the_food_women end::numeric)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "argues_men", "optionName": "metric_30ukupam9n4_3d0m9dugc34", "sqlExpression": "SUM(case when wife_beating_justified_if_she_argues_with_him_men is null then 0 else wife_beating_justified_if_she_argues_with_him_men end::numeric)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "argues_women", "optionName": "metric_sb2skn4axs8_6c8m7pub35m", "sqlExpression": "SUM(case when wife_beating_justified_if_she_argues_with_him_women is null then 0 else wife_beating_justified_if_she_argues_with_him_women end::numeric)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "out_men", "optionName": "metric_5trxsnkua23_6hx6rh96k3b", "sqlExpression": "SUM(case when wife_beating_justified_if_she_goes_out_without_telling_him_men is null then 0 else wife_beating_justified_if_she_goes_out_without_telling_him_men end::numeric)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "out_women", "optionName": "metric_r5u12zm5tie_a3vc7mlpjpj", "sqlExpression": "SUM(case when wife_beating_justified_if_she_goes_out_without_telling_him_wome is null then 0 else wife_beating_justified_if_she_goes_out_without_telling_him_wome end::numeric)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "neglects_men", "optionName": "metric_e3nc0qtjolt_snh9bo08rsp", "sqlExpression": "SUM(case when wife_beating_justified_if_she_neglects_the_children_men is null then 0 else wife_beating_justified_if_she_neglects_the_children_men end::numeric)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "neglects_women", "optionName": "metric_mysjyg7k3k_z12onuoo36s", "sqlExpression": "SUM(case when wife_beating_justified_if_she_neglects_the_children_women is null then 0 else wife_beating_justified_if_she_neglects_the_children_women end::numeric)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "sex_men", "optionName": "metric_p6bwe37wu5h_w4q4yee2z9", "sqlExpression": "SUM(case when wife_beating_justified_if_she_refuses_to_have_sex_with_him_men is null then 0 else wife_beating_justified_if_she_refuses_to_have_sex_with_him_men end::numeric)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "sex_women", "optionName": "metric_g73prlwxjo9_vvjt3k82go", "sqlExpression": "SUM(case when wife_beating_justified_if_she_refuses_to_have_sex_with_him_wome is null then 0 else wife_beating_justified_if_she_refuses_to_have_sex_with_him_wome end::numeric)" } ], "order_by_cols": [], "order_desc": true, "page_length": 0, "percent_metrics": [], "row_limit": 10000, "slice_id": 1149, "table_filter": false, "table_timestamp_format": "%Y-%m-%d %H:%M:%S", "time_grain_sqla": "P1D", "time_range": "No filter", "time_range_endpoints": [ "inclusive", "exclusive" ], "timeseries_limit_metric": null, "url_params": {}, "viz_type": "table" } These parameters are generated dynamically when clicking the save or overwrite button in the explore view. This JSON object is exposed here for reference and for power users who may want to alter specific parameters.
Cache Timeout	Duration (in seconds) of the caching timeout for this chart. Note this defaults to the datasource/table timeout if undefined.