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": ""
}
|