| Parameters |
{"adhoc_filters": [{"clause": "WHERE", "comparator": "NULL", "expressionType": "SIMPLE", "filterOptionName": "filter_6yqnskc0jr8_jsj39n4zt7", "fromFormData": true, "operator": "!=", "sqlExpression": null, "subject": "thematic_objective"}, {"clause": "WHERE", "comparator": "NULL", "expressionType": "SIMPLE", "filterOptionName": "filter_dzrozbf0xsn_b7pz19nd0yu", "fromFormData": true, "operator": "!=", "sqlExpression": null, "subject": "investment_priority"}], "color_scheme": "bnbColors", "comparison_type": "values", "contribution": true, "datasource": "1__table", "date_time_format": null, "equal_date_size": true, "granularity_sqla": "project_start", "groupby": ["thematic_objective", "investment_priority"], "log_scale": false, "metrics": ["Number of Projects"], "number_format": ".3s", "order_desc": false, "partition_limit": "", "partition_threshold": 0.618033988749895, "rich_tooltip": true, "rolling_type": "None", "row_limit": null, "slice_id": 54, "time_range": "No filter", "time_series_option": "not_time", "timeseries_limit_metric": {"aggregate": "MAX", "column": {"column_name": "thematic_objective", "database_expression": null, "description": null, "expression": "", "filterable": true, "groupby": true, "id": 15, "is_dttm": false, "optionName": "_col_thematic_objective", "python_date_format": null, "type": "VARCHAR(653) COLLATE UTF8MB4_UNI", "verbose_name": "Thematic Objective (only 2014-2020 projects)"}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": false, "label": "MAX(thematic_objective)", "optionName": "metric_ew2lcfynxlp_axgu0zumtxn", "sqlExpression": null}, "url_params": {}, "viz_type": "partition"}
|
