Show Chart

Owners [XiaoChen Zhang]
Created By XiaoChen Zhang
Changed By XiaoChen Zhang
Created On 2019-07-22 06:13:28
Changed On 2019-07-22 06:13:28
Name UpLoad Devices (Spent)
Datasource Id 15
Datasource Type table
Datasource Name tap_dw.dw_spend_group
Visualization Type area
Parameters {"datasource": "15__table", "viz_type": "area", "url_params": {}, "granularity_sqla": "dt", "time_grain_sqla": "P1D", "time_range": "Last month", "metrics": [{"expressionType": "SIMPLE", "column": {"id": 473, "column_name": "uids", "verbose_name": "Num of Device ID", "description": "", "expression": "", "filterable": false, "groupby": false, "is_dttm": false, "type": "BIGINT", "database_expression": "", "python_date_format": "", "optionName": "_col_uids"}, "aggregate": "SUM", "sqlExpression": null, "hasCustomLabel": false, "fromFormData": false, "label": "SUM(uids)", "optionName": "metric_j3vt1awzqq_iz6eivlk7c"}], "adhoc_filters": [{"expressionType": "SIMPLE", "subject": "loc", "operator": "!=", "comparator": "CN", "clause": "WHERE", "sqlExpression": null, "fromFormData": true, "filterOptionName": "filter_q7ba81lefbk_8hgcpr6h27x"}], "groupby": ["loc"], "limit": 10, "timeseries_limit_metric": {"expressionType": "SIMPLE", "column": {"id": 473, "column_name": "uids", "verbose_name": "Num of Device ID", "description": "", "expression": "", "filterable": false, "groupby": false, "is_dttm": false, "type": "BIGINT", "database_expression": "", "python_date_format": ""}, "aggregate": "SUM", "sqlExpression": null, "hasCustomLabel": false, "fromFormData": true, "label": "SUM(uids)", "optionName": "metric_zj4q4bo65tg_w834jkuyisc"}, "order_desc": true, "contribution": false, "row_limit": 50000, "show_brush": "auto", "show_legend": true, "line_interpolation": "linear", "stacked_style": "stack", "color_scheme": "bnbColors", "rich_tooltip": true, "show_controls": false, "x_axis_label": "", "bottom_margin": "auto", "x_ticks_layout": "auto", "x_axis_format": "smart_date", "x_axis_showminmax": false, "y_axis_format": ".3s", "y_axis_bounds": [null, null], "y_log_scale": false, "rolling_type": "None", "comparison_type": "values", "resample_how": null, "resample_rule": null, "resample_fillmethod": null, "annotation_layers": []}
Description None
Cache Timeout None
Perm [Presto].[dw_spend_group](id:15)
Dashboards [Time Spent on Game (in Minutes) ]