Show Chart

Owners [Bella Okiddy]
Created By Bella Okiddy
Changed By Bella Okiddy
Created On 2020-07-01 18:29:46.207016
Changed On 2020-07-01 18:32:50.777979
Name If you want to raise your concern and feedback on COVID-19 related matters, what kind of mechanism you would you prefer most? (disability)
Datasource Id 19
Datasource Type table
Datasource Name kap.covid_survey_arrays_rows
Visualization Type dist_bar
Parameters {"datasource": "2782__table", "viz_type": "dist_bar", "slice_id": 15797, "url_params": {}, "granularity_sqla": "metadata_today", "time_grain_sqla": "P1D", "time_range": "No filter", "metrics": [{"expressionType": "SQL", "sqlExpression": "Cast(COUNT(*) FILTER (WHERE elementfound='y_preferred_give' AND disability='yes') as float)/ NULLIF(COUNT(*) FILTER (WHERE disability='yes'), 0)\n", "column": null, "aggregate": null, "hasCustomLabel": true, "fromFormData": true, "label": "Disability", "optionName": "metric_4c543loz7a_v8wfd9ymf4"}, {"expressionType": "SQL", "sqlExpression": "Cast(COUNT(*) FILTER (WHERE elementfound='y_preferred_give' AND disability='no') as float)/ CAST(NULLIF(COUNT(*) FILTER (WHERE disability='no'), 0) AS float)", "column": null, "aggregate": null, "hasCustomLabel": true, "fromFormData": true, "label": "No disability", "optionName": "metric_a03otwz7e2_a2xmt7ae2eh"}, {"expressionType": "SQL", "sqlExpression": "Cast(COUNT(*) FILTER (WHERE elementfound='y_preferred_give' AND disability='i_prefer_not_t') as float)/ NULLIF(COUNT(*) FILTER (WHERE disability='i_prefer_not_t'), 0)", "column": null, "aggregate": null, "hasCustomLabel": true, "fromFormData": true, "label": "I prefer not to say", "optionName": "metric_n9ul3drw8i_85kql36ltbu"}], "adhoc_filters": [{"expressionType": "SIMPLE", "subject": "arrayname", "operator": "==", "comparator": "preferred_channels_give_feedback", "clause": "WHERE", "sqlExpression": null, "fromFormData": true, "filterOptionName": "filter_ths4lt9t1x_kjepc577zx"}], "groupby": ["option_label"], "columns": [], "row_limit": 10000, "contribution": false, "color_scheme": "", "show_legend": true, "show_bar_value": true, "bar_stacked": false, "order_bars": true, "y_axis_format": ",.0%", "y_axis_label": "", "show_controls": false, "x_axis_label": "", "bottom_margin": "auto", "x_ticks_layout": "auto", "reduce_x_ticks": false, "remote_id": 15797, "datasource_name": "covid_survey_arrays_rows", "schema": "kap", "database_name": "UNICEF Cambodia", "import_time": 1593628360}
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[covid_survey_arrays_rows](id:19)
Schema Perm [UNICEF Cambodia].[kap]
Dashboards []
Email Schedules []