Show Chart

Owners [Bella Okiddy]
Created By Bella Okiddy
Changed By Bella Okiddy
Created On 2020-07-01 17:13:17.983831
Changed On 2020-07-07 17:40:20.059229
Name If we want to respond to your feedback and concerns, which ways would be the most convenient for you? (gender)
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": "Females", "optionName": "metric_4c543loz7a_v8wfd9ymf4", "sqlExpression": "Cast(COUNT(*) FILTER (WHERE elementfound='y_prefered_receive' AND sex='female') as float)/ NULLIF(COUNT(*) FILTER (WHERE sex='female'), 0)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Males", "optionName": "metric_a03otwz7e2_a2xmt7ae2eh", "sqlExpression": "Cast(COUNT(*) FILTER (WHERE elementfound='y_prefered_receive' AND sex='male') as float)/ NULLIF(COUNT(*) FILTER (WHERE sex='male'), 0)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Other", "optionName": "metric_n9ul3drw8i_85kql36ltbu", "sqlExpression": "Cast(COUNT(*) FILTER (WHERE elementfound='y_prefered_receive' AND sex='other') as float)/ NULLIF(COUNT(*) FILTER (WHERE sex='other'), 0)" } ], "order_bars": true, "reduce_x_ticks": false, "row_limit": 10000, "show_bar_value": true, "show_controls": false, "show_legend": true, "slice_id": 217, "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 []