Parameters |
{"adhoc_filters": [{"clause": "WHERE", "comparator": "0", "expressionType": "SIMPLE", "filterOptionName": "filter_tsgyn2x5me_9dvjocqi38b", "fromFormData": true, "isExtra": false, "operator": "!=", "sqlExpression": null, "subject": "number"}], "align_pn": false, "all_columns": [], "color_pn": true, "datasource": "56__table", "granularity_sqla": null, "groupby": ["province"], "include_search": false, "include_time": false, "metrics": [{"aggregate": "SUM", "column": {"column_name": "number", "description": null, "expression": "", "filterable": true, "groupby": false, "id": 1358, "is_dttm": false, "optionName": "_col_number", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "care_facilities", "optionName": "metric_6jotnwm125x_urhes70icfc", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "number_meeting_the_standards", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1359, "is_dttm": false, "optionName": "_col_number_meeting_the_standards", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "meeting_standards", "optionName": "metric_ak89ji95u1_jkwisqmcodj", "sqlExpression": null}, {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "percentage_meeting_stds", "optionName": "metric_8r4lmo6ho3m_b493201mitg", "sqlExpression": "ROUND((SUM(number_meeting_the_standards)/SUM(number))*100)"}], "order_by_cols": [], "order_desc": true, "page_length": 0, "percent_metrics": [], "row_limit": 10000, "slice_id": 1151, "table_filter": false, "table_timestamp_format": "%Y-%m-%d %H:%M:%S", "time_grain_sqla": "P1D", "time_range": "Last week", "timeseries_limit_metric": null, "url_params": {}, "viz_type": "table"}
|