Parameters |
{
"adhoc_filters": [
{
"clause": "WHERE",
"comparator": "Apartment",
"expressionType": "SIMPLE",
"filterOptionName": "filter_yshsazhbed_6e6gz0zde0r",
"isExtra": false,
"isNew": false,
"operator": "==",
"sqlExpression": null,
"subject": "category"
},
{
"clause": "WHERE",
"comparator": "buy",
"expressionType": "SIMPLE",
"filterOptionName": "filter_g37i4lnxkqj_xpi1cyrcaen",
"isExtra": false,
"isNew": false,
"operator": "==",
"sqlExpression": null,
"subject": "transaction"
}
],
"color_picker": {
"a": 1,
"b": 135,
"g": 122,
"r": 0
},
"datasource": "17__table",
"granularity_sqla": "quarter",
"header_font_size": 0.4,
"metric": {
"aggregate": "SUM",
"column": {
"column_name": "count",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 637,
"is_dttm": false,
"optionName": "_col_count",
"python_date_format": null,
"type": "BIGINT",
"verbose_name": null
},
"expressionType": "SIMPLE",
"hasCustomLabel": false,
"isNew": false,
"label": "SUM(count)",
"optionName": "metric_rk1ork6q8ri_afi8ozfsexj",
"sqlExpression": null
},
"queryFields": {
"metric": "metrics"
},
"rolling_type": "None",
"show_trend_line": true,
"slice_id": 163,
"start_y_axis_at_zero": true,
"subheader_font_size": 0.15,
"time_grain_sqla": "P1D",
"time_range": "Last 3 years",
"time_range_endpoints": [
"inclusive",
"exclusive"
],
"url_params": {},
"viz_type": "big_number",
"y_axis_format": "SMART_NUMBER"
}
|