Show Chart

Owners [Bella Okiddy]
Created By Bella Okiddy
Changed By Bella Okiddy
Created On 2020-07-01 17:13:20.732054
Changed On 2020-07-27 08:02:20.592917
Name Which group of people do you think are at a higher risk of being infected with COVID-19? (disability)
Datasource Id 23
Datasource Type table
Datasource Name kap.covid_groups_risk_perceived_spread
Visualization Type dist_bar
Parameters { "adhoc_filters": [ { "clause": "WHERE", "comparator": "groups_perceived_at_risk", "expressionType": "SIMPLE", "filterOptionName": "filter_xu00f0q9739_hr4x1l33ab5", "fromFormData": true, "operator": "==", "sqlExpression": null, "subject": "arrayname" }, { "clause": "WHERE", "comparator": "", "expressionType": "SIMPLE", "filterOptionName": "filter_l42jnu9po5_bflb7x57kx7", "fromFormData": true, "operator": "IS NOT NULL", "sqlExpression": null, "subject": "option_label" } ], "bar_stacked": false, "bottom_margin": "auto", "color_scheme": "bnbColors", "columns": [], "contribution": false, "datasource": "23__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_f6h0dzqhdj5_n9y4vt3l4m", "sqlExpression": "Cast(COUNT(*) FILTER (WHERE elementfound='y_groups_risk' AND sex='female') as float)/ NULLIF(COUNT(*) FILTER (WHERE sex='female'), 0)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "No disability", "optionName": "metric_i3vafskza89_ewj027psgke", "sqlExpression": "Cast(COUNT(*) FILTER (WHERE elementfound='y_groups_risk' 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_0vmrqh7seimf_mveme1tg1t", "sqlExpression": "Cast(COUNT(*) FILTER (WHERE elementfound='y_groups_risk' AND disability='i_prefer_not_t') as float)/ NULLIF(COUNT(*) FILTER (WHERE disability='i_prefer_not_t'), 0)" } ], "order_bars": false, "reduce_x_ticks": false, "row_limit": 10000, "show_bar_value": true, "show_controls": false, "show_legend": true, "slice_id": 256, "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_groups_risk_perceived_spread](id:23)
Schema Perm [UNICEF Cambodia].[kap]
Dashboards [UNICEF Cambodia Covid-19 Awareness Survey (English)]
Email Schedules []