Show Chart

Owners [Su Myat Lwin]
Created By Su Myat Lwin
Changed By Su Myat Lwin
Created On 2020-08-24 08:00:08.091322
Changed On 2020-08-24 08:00:26.699249
Name SML stacked bar chart
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_7wyh7li1vs_a7aeqilnsc7", "fromFormData": true, "isExtra": false, "operator": "==", "sqlExpression": null, "subject": "proceed" }, { "clause": "WHERE", "comparator": "", "expressionType": "SIMPLE", "filterOptionName": "filter_lua4l7o2nt8_j21umxpvb6k", "fromFormData": true, "isExtra": false, "operator": "IS NOT NULL", "sqlExpression": null, "subject": "sex" } ], "bar_stacked": true, "bottom_margin": "auto", "color_scheme": "bnbColors", "columns": [], "contribution": false, "datasource": "18__table", "granularity_sqla": "metadata_today", "groupby": [ "sex", "proceed" ], "label_colors": {}, "metrics": [ { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Male", "optionName": "metric_h8kdplo5wc_ewzruyxj7h4", "sqlExpression": "\r\nCOUNT(*) FILTER (WHERE sex='male')" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Female", "optionName": "metric_iqjwqaghgj_opxv3oi7ylc", "sqlExpression": "\r\nCOUNT(*) FILTER (WHERE sex='female')" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Other", "optionName": "metric_duddc90ky0h_8iivfyzu5je", "sqlExpression": "\r\nCOUNT(*) FILTER (WHERE sex='other')" } ], "order_bars": false, "reduce_x_ticks": false, "row_limit": 10000, "show_bar_value": false, "show_controls": false, "show_legend": true, "time_range": "No filter", "time_range_endpoints": [ "inclusive", "exclusive" ], "url_params": {}, "viz_type": "dist_bar", "x_axis_label": "", "x_ticks_layout": "auto", "y_axis_format": "SMART_NUMBER", "y_axis_label": "" }
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[covid_survey_complete](id:18)
Schema Perm [UNICEF Cambodia].[kap]
Dashboards []
Email Schedules []