Show Chart

Owners [Spyros Savvidis]
Table data.mv_prop_prices_areahash
Created By Spyros Savvidis
Changed By Spyros Savvidis
Created On 2022-01-29 12:14:23.628144
Changed On 2022-01-29 12:32:12.991094
Name Trendline- Apartment/For Sale
Datasource Id 17
Datasource Type table
Datasource Name data.mv_prop_prices_areahash
Visualization Type big_number
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" }
Description None
Cache Timeout None
Perm [beton].[mv_prop_prices_areahash](id:17)
Schema Perm [beton].[data]
Alerts []
Dashboards [Areahash Dashboard]
Email Schedules []