| Parameters |
{"datasource": "1758__table", "viz_type": "line", "url_params": {}, "granularity_sqla": "date_column", "time_grain_sqla": "P1D", "time_range": "No filter", "metrics": [{"expressionType": "SQL", "sqlExpression": "SUM(children_not_living_with_a_biological_parent)/100", "column": null, "aggregate": null, "hasCustomLabel": true, "fromFormData": true, "label": "Children", "optionName": "metric_d8hm70pxghn_8k7u4hzindx"}], "adhoc_filters": [{"expressionType": "SIMPLE", "subject": "category", "operator": "==", "comparator": "Sex", "clause": "WHERE", "sqlExpression": null, "fromFormData": true, "filterOptionName": "filter_nkhg606l9q_v9yv8wijwl"}], "groupby": ["category_value"], "timeseries_limit_metric": null, "order_desc": true, "contribution": false, "row_limit": 10000, "color_scheme": "bnbColors", "show_brush": "auto", "send_time_range": false, "show_legend": true, "rich_tooltip": true, "show_markers": false, "line_interpolation": "linear", "x_axis_label": "", "bottom_margin": "auto", "x_ticks_layout": "auto", "x_axis_format": "smart_date", "x_axis_showminmax": false, "y_axis_label": "", "left_margin": "auto", "y_axis_showminmax": false, "y_log_scale": false, "y_axis_format": ",.1%", "y_axis_bounds": [null, null], "rolling_type": "None", "comparison_type": "values", "resample_how": null, "resample_rule": null, "resample_fillmethod": null, "annotation_layers": [], "remote_id": 709, "datasource_name": "indicator5_6_cdhs_data_updated", "schema": null, "database_name": "UNICEF Cambodia", "import_time": 1642578313}
|
| Query Context |
{"datasource":{"id":65,"type":"table"},"force":false,"queries":[{"time_range":"No filter","granularity":"date_column","filters":[{"col":"category","op":"==","val":"Sex"}],"extras":{"time_grain_sqla":"P1D","having":"","where":""},"applied_time_extras":{},"columns":["category_value"],"metrics":[{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Children","optionName":"metric_d8hm70pxghn_8k7u4hzindx","sqlExpression":"SUM(children_not_living_with_a_biological_parent)/100"}],"annotation_layers":[],"row_limit":10000,"series_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{}}],"form_data":{"adhoc_filters":[{"clause":"WHERE","comparator":"Sex","expressionType":"SIMPLE","filterOptionName":"filter_nkhg606l9q_v9yv8wijwl","fromFormData":true,"operator":"==","sqlExpression":null,"subject":"category"}],"annotation_layers":[],"bottom_margin":"auto","color_scheme":"bnbColors","comparison_type":"values","contribution":false,"database_name":"UNICEF Cambodia","datasource":"65__table","datasource_name":"indicator5_6_cdhs_data_updated","granularity_sqla":"date_column","groupby":["category_value"],"import_time":1642578313,"left_margin":"auto","line_interpolation":"linear","metrics":[{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Children","optionName":"metric_d8hm70pxghn_8k7u4hzindx","sqlExpression":"SUM(children_not_living_with_a_biological_parent)/100"}],"order_desc":true,"remote_id":709,"resample_fillmethod":null,"resample_how":null,"resample_rule":null,"rich_tooltip":true,"rolling_type":"None","row_limit":10000,"schema":null,"send_time_range":false,"show_brush":"auto","show_legend":true,"show_markers":false,"slice_id":2267,"time_grain_sqla":"P1D","time_range":"No filter","timeseries_limit_metric":null,"url_params":{},"viz_type":"line","x_axis_format":"smart_date","x_axis_label":"","x_axis_showminmax":false,"x_ticks_layout":"auto","y_axis_bounds":[null,null],"y_axis_format":",.1%","y_axis_label":"","y_axis_showminmax":false,"y_log_scale":false,"force":false,"result_format":"json","result_type":"full"},"result_format":"json","result_type":"full"}
|
