| Parameters |
{"adhoc_filters": [{"clause": "WHERE", "comparator": "Province", "expressionType": "SIMPLE", "filterOptionName": "filter_aqfzb5640jl_fmqbag5smb", "fromFormData": true, "isExtra": false, "operator": "==", "sqlExpression": null, "subject": "category"}, {"clause": "WHERE", "comparator": "2014", "expressionType": "SIMPLE", "filterOptionName": "filter_1s70o85vy35_u42jrbn4uj", "fromFormData": true, "isExtra": false, "operator": "==", "sqlExpression": null, "subject": "year"}], "align_pn": false, "all_columns": [], "color_pn": true, "datasource": "66__table", "granularity_sqla": "date_column", "groupby": ["category_value"], "include_search": false, "include_time": false, "metrics": [{"aggregate": "SUM", "column": {"column_name": "wife_beating_justified_for_at_least_one_specific_reason_men", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1436, "is_dttm": false, "optionName": "_col_wife_beating_justified_for_at_least_one_specific_reason_men", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "men", "optionName": "metric_mmoo2bgtxy_vsqqovnsl7b", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "wife_beating_justified_for_at_least_one_specific_reason_women", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1437, "is_dttm": false, "optionName": "_col_wife_beating_justified_for_at_least_one_specific_reason_women", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "women", "optionName": "metric_2bs9c2lg5qb_dbpzyhschog", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "wife_beating_justified_if_she_burns_the_food_men", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1440, "is_dttm": false, "optionName": "_col_wife_beating_justified_if_she_burns_the_food_men", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "burns_men", "optionName": "metric_q59sh6qxfis_z2md8e2udn", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "wife_beating_justified_if_she_burns_the_food_women", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1441, "is_dttm": false, "optionName": "_col_wife_beating_justified_if_she_burns_the_food_women", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "burns_women", "optionName": "metric_k6p0e463kfa_aozo74tjocb", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "wife_beating_justified_if_she_argues_with_him_men", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1438, "is_dttm": false, "optionName": "_col_wife_beating_justified_if_she_argues_with_him_men", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "argues_men", "optionName": "metric_1bsi0m29184_dndb9zvnz2", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "wife_beating_justified_if_she_argues_with_him_women", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1439, "is_dttm": false, "optionName": "_col_wife_beating_justified_if_she_argues_with_him_women", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "argues_women", "optionName": "metric_7j2bw9rfjc2_fjf7khjfa78", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "wife_beating_justified_if_she_goes_out_without_telling_him_men", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1442, "is_dttm": false, "optionName": "_col_wife_beating_justified_if_she_goes_out_without_telling_him_men", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "out_men", "optionName": "metric_589w3sc7sde_z4c11vosih", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "wife_beating_justified_if_she_goes_out_without_telling_him_wome", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1443, "is_dttm": false, "optionName": "_col_wife_beating_justified_if_she_goes_out_without_telling_him_wome", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "out_women", "optionName": "metric_bzx4nojc1om_pd27o0nx9ot", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "wife_beating_justified_if_she_neglects_the_children_men", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1444, "is_dttm": false, "optionName": "_col_wife_beating_justified_if_she_neglects_the_children_men", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "neglects_men", "optionName": "metric_qrl8zcci55_914r421um1t", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "wife_beating_justified_if_she_neglects_the_children_women", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1445, "is_dttm": false, "optionName": "_col_wife_beating_justified_if_she_neglects_the_children_women", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "neglects_women", "optionName": "metric_7q06bo9uzpx_9diesh58p6m", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "wife_beating_justified_if_she_refuses_to_have_sex_with_him_men", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1449, "is_dttm": false, "optionName": "_col_wife_beating_justified_if_she_refuses_to_have_sex_with_him_men", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "sex_men", "optionName": "metric_11pn7qxbdw3b_06dudwd8445", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "wife_beating_justified_if_she_refuses_to_have_sex_with_him_wome", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1450, "is_dttm": false, "optionName": "_col_wife_beating_justified_if_she_refuses_to_have_sex_with_him_wome", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "sex_women", "optionName": "metric_1hatbjjx12o_u4v7ycudah", "sqlExpression": null}], "order_by_cols": [], "order_desc": true, "page_length": 0, "percent_metrics": [], "row_limit": 10000, "slice_id": 1128, "table_filter": false, "table_timestamp_format": "%Y-%m-%d %H:%M:%S", "time_grain_sqla": "P1D", "time_range": "No filter", "timeseries_limit_metric": null, "url_params": {}, "viz_type": "table"}
|
| Query Context |
{"datasource":{"id":66,"type":"table"},"force":false,"queries":[{"time_range":"No filter","granularity":"date_column","filters":[{"col":"category","op":"==","val":"Province"},{"col":"year","op":"==","val":"2014"}],"extras":{"time_grain_sqla":"P1D","having":"","where":""},"applied_time_extras":{},"columns":["category_value"],"metrics":[{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_for_at_least_one_specific_reason_men","description":null,"expression":"","filterable":false,"groupby":false,"id":1436,"is_dttm":false,"optionName":"_col_wife_beating_justified_for_at_least_one_specific_reason_men","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"men","optionName":"metric_mmoo2bgtxy_vsqqovnsl7b","sqlExpression":null},{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_for_at_least_one_specific_reason_women","description":null,"expression":"","filterable":false,"groupby":false,"id":1437,"is_dttm":false,"optionName":"_col_wife_beating_justified_for_at_least_one_specific_reason_women","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"women","optionName":"metric_2bs9c2lg5qb_dbpzyhschog","sqlExpression":null},{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_if_she_burns_the_food_men","description":null,"expression":"","filterable":false,"groupby":false,"id":1440,"is_dttm":false,"optionName":"_col_wife_beating_justified_if_she_burns_the_food_men","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"burns_men","optionName":"metric_q59sh6qxfis_z2md8e2udn","sqlExpression":null},{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_if_she_burns_the_food_women","description":null,"expression":"","filterable":false,"groupby":false,"id":1441,"is_dttm":false,"optionName":"_col_wife_beating_justified_if_she_burns_the_food_women","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"burns_women","optionName":"metric_k6p0e463kfa_aozo74tjocb","sqlExpression":null},{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_if_she_argues_with_him_men","description":null,"expression":"","filterable":false,"groupby":false,"id":1438,"is_dttm":false,"optionName":"_col_wife_beating_justified_if_she_argues_with_him_men","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"argues_men","optionName":"metric_1bsi0m29184_dndb9zvnz2","sqlExpression":null},{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_if_she_argues_with_him_women","description":null,"expression":"","filterable":false,"groupby":false,"id":1439,"is_dttm":false,"optionName":"_col_wife_beating_justified_if_she_argues_with_him_women","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"argues_women","optionName":"metric_7j2bw9rfjc2_fjf7khjfa78","sqlExpression":null},{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_if_she_goes_out_without_telling_him_men","description":null,"expression":"","filterable":false,"groupby":false,"id":1442,"is_dttm":false,"optionName":"_col_wife_beating_justified_if_she_goes_out_without_telling_him_men","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"out_men","optionName":"metric_589w3sc7sde_z4c11vosih","sqlExpression":null},{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_if_she_goes_out_without_telling_him_wome","description":null,"expression":"","filterable":false,"groupby":false,"id":1443,"is_dttm":false,"optionName":"_col_wife_beating_justified_if_she_goes_out_without_telling_him_wome","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"out_women","optionName":"metric_bzx4nojc1om_pd27o0nx9ot","sqlExpression":null},{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_if_she_neglects_the_children_men","description":null,"expression":"","filterable":false,"groupby":false,"id":1444,"is_dttm":false,"optionName":"_col_wife_beating_justified_if_she_neglects_the_children_men","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"neglects_men","optionName":"metric_qrl8zcci55_914r421um1t","sqlExpression":null},{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_if_she_neglects_the_children_women","description":null,"expression":"","filterable":false,"groupby":false,"id":1445,"is_dttm":false,"optionName":"_col_wife_beating_justified_if_she_neglects_the_children_women","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"neglects_women","optionName":"metric_7q06bo9uzpx_9diesh58p6m","sqlExpression":null},{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_if_she_refuses_to_have_sex_with_him_men","description":null,"expression":"","filterable":false,"groupby":false,"id":1449,"is_dttm":false,"optionName":"_col_wife_beating_justified_if_she_refuses_to_have_sex_with_him_men","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"sex_men","optionName":"metric_11pn7qxbdw3b_06dudwd8445","sqlExpression":null},{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_if_she_refuses_to_have_sex_with_him_wome","description":null,"expression":"","filterable":false,"groupby":false,"id":1450,"is_dttm":false,"optionName":"_col_wife_beating_justified_if_she_refuses_to_have_sex_with_him_wome","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"sex_women","optionName":"metric_1hatbjjx12o_u4v7ycudah","sqlExpression":null}],"orderby":[[{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_for_at_least_one_specific_reason_men","description":null,"expression":"","filterable":false,"groupby":false,"id":1436,"is_dttm":false,"optionName":"_col_wife_beating_justified_for_at_least_one_specific_reason_men","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"men","optionName":"metric_mmoo2bgtxy_vsqqovnsl7b","sqlExpression":null},false]],"annotation_layers":[],"row_limit":10000,"series_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{},"post_processing":[]}],"form_data":{"adhoc_filters":[{"clause":"WHERE","comparator":"Province","expressionType":"SIMPLE","filterOptionName":"filter_aqfzb5640jl_fmqbag5smb","fromFormData":true,"isExtra":false,"operator":"==","sqlExpression":null,"subject":"category"},{"clause":"WHERE","comparator":"2014","expressionType":"SIMPLE","filterOptionName":"filter_1s70o85vy35_u42jrbn4uj","fromFormData":true,"isExtra":false,"operator":"==","sqlExpression":null,"subject":"year"}],"align_pn":false,"all_columns":[],"color_pn":true,"datasource":"66__table","granularity_sqla":"date_column","groupby":["category_value"],"include_search":false,"include_time":false,"metrics":[{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_for_at_least_one_specific_reason_men","description":null,"expression":"","filterable":false,"groupby":false,"id":1436,"is_dttm":false,"optionName":"_col_wife_beating_justified_for_at_least_one_specific_reason_men","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"men","optionName":"metric_mmoo2bgtxy_vsqqovnsl7b","sqlExpression":null},{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_for_at_least_one_specific_reason_women","description":null,"expression":"","filterable":false,"groupby":false,"id":1437,"is_dttm":false,"optionName":"_col_wife_beating_justified_for_at_least_one_specific_reason_women","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"women","optionName":"metric_2bs9c2lg5qb_dbpzyhschog","sqlExpression":null},{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_if_she_burns_the_food_men","description":null,"expression":"","filterable":false,"groupby":false,"id":1440,"is_dttm":false,"optionName":"_col_wife_beating_justified_if_she_burns_the_food_men","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"burns_men","optionName":"metric_q59sh6qxfis_z2md8e2udn","sqlExpression":null},{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_if_she_burns_the_food_women","description":null,"expression":"","filterable":false,"groupby":false,"id":1441,"is_dttm":false,"optionName":"_col_wife_beating_justified_if_she_burns_the_food_women","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"burns_women","optionName":"metric_k6p0e463kfa_aozo74tjocb","sqlExpression":null},{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_if_she_argues_with_him_men","description":null,"expression":"","filterable":false,"groupby":false,"id":1438,"is_dttm":false,"optionName":"_col_wife_beating_justified_if_she_argues_with_him_men","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"argues_men","optionName":"metric_1bsi0m29184_dndb9zvnz2","sqlExpression":null},{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_if_she_argues_with_him_women","description":null,"expression":"","filterable":false,"groupby":false,"id":1439,"is_dttm":false,"optionName":"_col_wife_beating_justified_if_she_argues_with_him_women","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"argues_women","optionName":"metric_7j2bw9rfjc2_fjf7khjfa78","sqlExpression":null},{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_if_she_goes_out_without_telling_him_men","description":null,"expression":"","filterable":false,"groupby":false,"id":1442,"is_dttm":false,"optionName":"_col_wife_beating_justified_if_she_goes_out_without_telling_him_men","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"out_men","optionName":"metric_589w3sc7sde_z4c11vosih","sqlExpression":null},{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_if_she_goes_out_without_telling_him_wome","description":null,"expression":"","filterable":false,"groupby":false,"id":1443,"is_dttm":false,"optionName":"_col_wife_beating_justified_if_she_goes_out_without_telling_him_wome","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"out_women","optionName":"metric_bzx4nojc1om_pd27o0nx9ot","sqlExpression":null},{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_if_she_neglects_the_children_men","description":null,"expression":"","filterable":false,"groupby":false,"id":1444,"is_dttm":false,"optionName":"_col_wife_beating_justified_if_she_neglects_the_children_men","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"neglects_men","optionName":"metric_qrl8zcci55_914r421um1t","sqlExpression":null},{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_if_she_neglects_the_children_women","description":null,"expression":"","filterable":false,"groupby":false,"id":1445,"is_dttm":false,"optionName":"_col_wife_beating_justified_if_she_neglects_the_children_women","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"neglects_women","optionName":"metric_7q06bo9uzpx_9diesh58p6m","sqlExpression":null},{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_if_she_refuses_to_have_sex_with_him_men","description":null,"expression":"","filterable":false,"groupby":false,"id":1449,"is_dttm":false,"optionName":"_col_wife_beating_justified_if_she_refuses_to_have_sex_with_him_men","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"sex_men","optionName":"metric_11pn7qxbdw3b_06dudwd8445","sqlExpression":null},{"aggregate":"SUM","column":{"column_name":"wife_beating_justified_if_she_refuses_to_have_sex_with_him_wome","description":null,"expression":"","filterable":false,"groupby":false,"id":1450,"is_dttm":false,"optionName":"_col_wife_beating_justified_if_she_refuses_to_have_sex_with_him_wome","type":"DOUBLE PRECISION","verbose_name":null},"expressionType":"SIMPLE","fromFormData":true,"hasCustomLabel":true,"label":"sex_women","optionName":"metric_1hatbjjx12o_u4v7ycudah","sqlExpression":null}],"order_by_cols":[],"order_desc":true,"page_length":0,"percent_metrics":[],"row_limit":10000,"slice_id":1128,"table_filter":false,"table_timestamp_format":"%Y-%m-%d %H:%M:%S","time_grain_sqla":"P1D","time_range":"No filter","timeseries_limit_metric":null,"url_params":{},"viz_type":"table","force":false,"result_format":"json","result_type":"full"},"result_format":"json","result_type":"full"}
|
