| Parameters |
{
"adhoc_filters": [
{
"clause": "WHERE",
"comparator": null,
"expressionType": "SQL",
"filterOptionName": "filter_pg3j7maa0i_b8fb0kdu13q",
"fromFormData": true,
"operator": null,
"sqlExpression": "centername <> ''",
"subject": null
}
],
"datasource": "374__table",
"granularity_sqla": "CreatedOn",
"header_font_size": 0.5,
"metric": {
"aggregate": null,
"column": null,
"expressionType": "SQL",
"fromFormData": true,
"hasCustomLabel": false,
"label": "CAST(SUM(Rating) AS FLOAT)/SUM(CASE WHEN...",
"optionName": "metric_uk1ucu6565c_0psxzso74nc",
"sqlExpression": "CAST(SUM(Rating) AS FLOAT)/SUM(CASE WHEN [STATUS] = 'C' THEN 1 else 0 end)"
},
"slice_id": 696,
"subheader_font_size": 0.125,
"time_grain_sqla": "P1D",
"time_range": "100 years ago : ",
"url_params": {},
"viz_type": "big_number_total",
"y_axis_format": "SMART_NUMBER"
}
|
