| Parameters |
{"datasource": "1788__table", "viz_type": "line", "url_params": {}, "granularity_sqla": "date_column", "time_grain_sqla": "P1D", "time_range": "No filter", "metrics": [{"expressionType": "SQL", "sqlExpression": "SUM(\"registered \" )/100", "column": null, "aggregate": null, "hasCustomLabel": true, "fromFormData": true, "label": "Registred", "optionName": "metric_u2gefiod5l_dcwxu2cp8ol"}, {"expressionType": "SQL", "sqlExpression": "SUM(with_bc)/100", "column": null, "aggregate": null, "hasCustomLabel": true, "fromFormData": true, "label": "With Birth Certificate", "optionName": "metric_58k95voeds_fx0m7cc46o8"}, {"expressionType": "SQL", "sqlExpression": "SUM(without_bc)/100", "column": null, "aggregate": null, "hasCustomLabel": true, "fromFormData": true, "label": "Without Birth Certificate", "optionName": "metric_0v3ab7c2ryd8_vfhrgu7wbj"}], "adhoc_filters": [], "groupby": [], "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": 5703, "datasource_name": "indicator3_1_trend_updated", "schema": "", "database_name": "UNICEF Cambodia", "import_time": 1637581598}
|
| Query Context |
{"datasource":{"id":51,"type":"table"},"force":false,"queries":[{"time_range":"No filter","granularity":"date_column","filters":[],"extras":{"time_grain_sqla":"P1D","having":"","where":""},"applied_time_extras":{},"columns":[],"metrics":[{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Registred","optionName":"metric_u2gefiod5l_dcwxu2cp8ol","sqlExpression":"SUM(\"registered \" )/100"},{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"With Birth Certificate","optionName":"metric_58k95voeds_fx0m7cc46o8","sqlExpression":"SUM(with_bc)/100"},{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Without Birth Certificate","optionName":"metric_0v3ab7c2ryd8_vfhrgu7wbj","sqlExpression":"SUM(without_bc)/100"}],"annotation_layers":[],"row_limit":10000,"series_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{}}],"form_data":{"adhoc_filters":[],"annotation_layers":[],"bottom_margin":"auto","color_scheme":"bnbColors","comparison_type":"values","contribution":false,"database_name":"UNICEF Cambodia","datasource":"51__table","datasource_name":"indicator3_1_trend_updated","granularity_sqla":"date_column","groupby":[],"import_time":1637581598,"left_margin":"auto","line_interpolation":"linear","metrics":[{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Registred","optionName":"metric_u2gefiod5l_dcwxu2cp8ol","sqlExpression":"SUM(\"registered \" )/100"},{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"With Birth Certificate","optionName":"metric_58k95voeds_fx0m7cc46o8","sqlExpression":"SUM(with_bc)/100"},{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Without Birth Certificate","optionName":"metric_0v3ab7c2ryd8_vfhrgu7wbj","sqlExpression":"SUM(without_bc)/100"}],"order_desc":true,"remote_id":5703,"resample_fillmethod":null,"resample_how":null,"resample_rule":null,"rich_tooltip":true,"rolling_type":"None","row_limit":10000,"schema":"","send_time_range":false,"show_brush":"auto","show_legend":true,"show_markers":false,"slice_id":726,"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"}
|
