Show Chart

Owners [Bella Okiddy]
Created By Bella Okiddy
Changed By Bella Okiddy
Created On 2020-07-01 17:13:21.344539
Changed On 2020-07-07 17:40:58.998392
Name If we want to respond to your feedback and concerns, which ways would be the most convenient for you? (disability)
Datasource Id 26
Datasource Type table
Datasource Name kap.covid_concerns_feedback
Visualization Type dist_bar
Parameters { "adhoc_filters": [ { "clause": "WHERE", "comparator": "preferred_channels_receive_feedback", "expressionType": "SIMPLE", "filterOptionName": "filter_ths4lt9t1x_kjepc577zx", "fromFormData": true, "operator": "==", "sqlExpression": null, "subject": "arrayname" } ], "bar_stacked": false, "bottom_margin": "auto", "color_scheme": "bnbColors", "columns": [], "contribution": false, "datasource": "26__table", "granularity_sqla": "metadata_today", "groupby": [ "option_label" ], "label_colors": { "Disability": "#003366", "Female": "#7b0051", "Females": "#B5E271", "I prefer not to say": "#007A87", "I prefer not to say": "#7CAFD7", "Male": "#ff5a5f", "Males": "#1A6EAA", "No disability": "#40D7D9", "No. of Respondents": "#00A2E8", "Null": "#5E666E", "Other": "#CCCCCC", "a. Frequently": "#4DAF4A", "a. Very effective": "#488f31", "b. Sometimes": "#00a0aa", "b. Somewhat effective": "#6aaa96", "c. Neutral": "#f1f1f1", "c. Never": "#9ccfd4", "d. Slightly effective": "#ffbda4", "e. Not effective": "#CCCCCC", "female": "#B5E271", "male": "#1A6EAA", "other": "#CCCCCC" }, "metrics": [ { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Disability", "optionName": "metric_4c543loz7a_v8wfd9ymf4", "sqlExpression": "Cast(COUNT(*) FILTER (WHERE elementfound='y_prefered_receive' AND disability='yes') as float)/ NULLIF(COUNT(*) FILTER (WHERE disability='yes'), 0)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "No disability", "optionName": "metric_a03otwz7e2_a2xmt7ae2eh", "sqlExpression": "Cast(COUNT(*) FILTER (WHERE elementfound='y_prefered_receive' AND disability='no') as float)/ NULLIF(COUNT(*) FILTER (WHERE disability='no'), 0)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "I prefer not to say", "optionName": "metric_n9ul3drw8i_85kql36ltbu", "sqlExpression": "Cast(COUNT(*) FILTER (WHERE elementfound='y_prefered_receive' AND disability='i_prefer_not_t') as float)/ NULLIF(COUNT(*) FILTER (WHERE disability='i_prefer_not_t'), 0)" } ], "order_bars": true, "reduce_x_ticks": false, "row_limit": 10000, "show_bar_value": true, "show_controls": false, "show_legend": true, "slice_id": 265, "time_range": "No filter", "time_range_endpoints": [ "unknown", "inclusive" ], "url_params": { "preselect_filters": "{\"223\": {\"__time_range\": \"No filter\"}, \"241\": {\"__time_range\": \"No filter\"}}" }, "viz_type": "dist_bar", "x_axis_label": "", "x_ticks_layout": "auto", "y_axis_format": ",.0%", "y_axis_label": "" }
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[covid_concerns_feedback](id:26)
Schema Perm [UNICEF Cambodia].[kap]
Dashboards [UNICEF Cambodia Covid-19 Awareness Survey (English)]
Email Schedules []