Parameters |
{"datasource": "1758__table", "viz_type": "dist_bar", "slice_id": 4727, "url_params": {}, "granularity_sqla": "year", "time_grain_sqla": "P1D", "time_range": "No filter", "metrics": [{"expressionType": "SQL", "sqlExpression": "SUM(children_not_living_with_a_biological_parent)/100", "column": null, "aggregate": null, "hasCustomLabel": true, "fromFormData": true, "label": "Not biological parent", "optionName": "metric_4t7nueg7meh_bhyeikx4bhk"}, {"expressionType": "SQL", "sqlExpression": "SUM(children_living_with_neither_parent_both_alive)/100", "column": null, "aggregate": null, "hasCustomLabel": true, "fromFormData": true, "label": "Both alive", "optionName": "metric_ph43m3nv7y8_wrpjkm1lcl"}, {"expressionType": "SQL", "sqlExpression": "SUM(children_living_with_neither_parent_mother_alive)/100", "column": null, "aggregate": null, "hasCustomLabel": true, "fromFormData": true, "label": "Mother alive", "optionName": "metric_01xygue9bigq_wgtcpezu3w8"}, {"expressionType": "SQL", "sqlExpression": "SUM(children_living_with_neither_parent_father_alive)/100", "column": null, "aggregate": null, "hasCustomLabel": true, "fromFormData": true, "label": "Father alive", "optionName": "metric_6jdmnioxias_vli76ngzoko"}], "adhoc_filters": [{"expressionType": "SIMPLE", "subject": "category", "operator": "==", "comparator": "Age", "clause": "WHERE", "sqlExpression": null, "fromFormData": true, "filterOptionName": "filter_fowfq9jpr4v_oxd3eqmcgro"}, {"expressionType": "SIMPLE", "subject": "year", "operator": "==", "comparator": "2014", "clause": "WHERE", "sqlExpression": null, "fromFormData": true, "filterOptionName": "filter_2tu5witu4x_qznx1wyzt0f"}, {"expressionType": "SQL", "sqlExpression": "category_value <> '0-1' AND category_value <> '2-4'", "clause": "WHERE", "subject": null, "operator": null, "comparator": null, "fromFormData": true, "filterOptionName": "filter_ykes6lbman_931143qcz8l"}], "groupby": ["category_value"], "columns": [], "row_limit": 10000, "contribution": false, "color_scheme": "bnbColors", "show_legend": true, "show_bar_value": false, "bar_stacked": false, "order_bars": true, "y_axis_format": ",.1%", "y_axis_label": "", "show_controls": false, "x_axis_label": "", "bottom_margin": "auto", "x_ticks_layout": "auto", "reduce_x_ticks": false, "remote_id": 706, "datasource_name": "indicator5_6_cdhs_data_updated", "schema": null, "database_name": "UNICEF Cambodia", "import_time": 1642578313}
|