Show Chart

Owners [Bella Okiddy]
Created By Bella Okiddy
Changed By Bella Okiddy
Created On 2020-07-01 18:29:40.272858
Changed On 2020-07-13 12:54:39.757415
Name Responses by disability
Datasource Id 18
Datasource Type table
Datasource Name kap.covid_survey_complete
Visualization Type dist_bar
Parameters { "adhoc_filters": [ { "clause": "WHERE", "comparator": "yes", "expressionType": "SIMPLE", "filterOptionName": "filter_vtp9a2srhnd_6nfzdex6f6q", "fromFormData": true, "operator": "==", "sqlExpression": null, "subject": "proceed" } ], "bar_stacked": true, "bottom_margin": "auto", "color_scheme": "bnbColors", "columns": [], "contribution": false, "datasource": "18__table", "granularity_sqla": "metadata_today", "groupby": [ "proceed_label_khmer" ], "label_colors": { "Disability": "#003366", "Females": "#ff5a5f", "I prefer not to say": "#00d1c1", "Males": "#7b0051", "No disability": "#40D7D9", "No. of Respondents": "#00A2E8", "Null": "#5E666E", "Other": "#007A87", "a. \u1789\u17b9\u1780\u1789\u17b6\u1794\u17cb": "#4DAF4A", "a. \u1798\u17b6\u1793\u1794\u17d2\u179a\u179f\u17b7\u1791\u17d2\u1792\u1797\u17b6\u1796\u1781\u17d2\u1796\u179f\u17cb": "#488f31", "b. \u1796\u17c1\u179b\u1781\u17d2\u179b\u17c7": "#00a0aa", "b. \u1798\u17b6\u1793\u1794\u17d2\u179a\u179f\u17b7\u1791\u17d2\u1792\u1797\u17b6\u1796\u1781\u17d2\u179b\u17c7": "#6aaa96", "c. \u1792\u1798\u17d2\u1798\u178f\u17b6": "#f1f1f1", "c. \u1798\u17b7\u1793\u178a\u17c2\u179b": "#9ccfd4", "d. \u1798\u17b6\u1793\u1794\u17d2\u179a\u179f\u17b7\u1791\u17d2\u1792\u1797\u17b6\u1796\u178f\u17b7\u1785\u178f\u17bd\u1785": "#ffbda4", "e. \u1796\u17bb\u17c6\u1798\u17b6\u1793\u1794\u17d2\u179a\u179f\u17b7\u1791\u17d2\u1792\u1797\u17b6\u1796\u1791\u17b6\u179b\u17cb\u178f\u17c2\u179f\u17c4\u17c7": "#CCCCCC", "female": "#B5E271", "male": "#1A6EAA", "other": "#CCCCCC", "\u1794\u17d2\u179a\u17bb\u179f": "#1A6EAA", "\u1795\u17d2\u179f\u17c1\u1784\u1791\u17c0\u178f": "#CCCCCC", "\u1798\u17b7\u1793\u1785\u1784\u17cb\u1786\u17d2\u179b\u17be\u1799": "#7CAFD7", "\u179f\u17d2\u179a\u17b8": "#B5E271" }, "metrics": [ { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Disability", "optionName": "metric_n7upr5ih85d_717a71l5508", "sqlExpression": "COUNT(*) FILTER (WHERE disability='yes')" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "No disability", "optionName": "metric_5hq8swqb2g3_t19ppk0ej88", "sqlExpression": "COUNT(*) FILTER (WHERE disability='no')" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "I prefer not to say", "optionName": "metric_q44xqlq3yn_yexkkolk65", "sqlExpression": "COUNT(*) FILTER (WHERE disability='i_prefer_not_t')" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Null", "optionName": "metric_zti6mcvyqic_nau4kamnhid", "sqlExpression": "(COUNT(*) FILTER (WHERE proceed='yes')) - (COUNT(*) FILTER (WHERE disability='yes')) -(COUNT(*) FILTER (WHERE disability='no')) - (COUNT(*) FILTER (WHERE disability='i_prefer_not_t'))" } ], "order_bars": false, "reduce_x_ticks": false, "row_limit": 10000, "show_bar_value": true, "show_controls": false, "show_legend": true, "slice_id": 302, "time_range": "No filter", "time_range_endpoints": [ "unknown", "inclusive" ], "url_params": { "preselect_filters": "{\"300\": {\"__time_range\": \"No filter\"}, \"318\": {\"__time_range\": \"No filter\"}}" }, "viz_type": "dist_bar", "x_axis_label": "", "x_ticks_layout": "flat", "y_axis_format": "100", "y_axis_label": "" }
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[covid_survey_complete](id:18)
Schema Perm [UNICEF Cambodia].[kap]
Dashboards [UNICEF Cambodia Covid-19 Awareness Survey (Khmer)]
Email Schedules []