Show Chart

Owners [XiaoChen Zhang]
Created By XiaoChen Zhang
Changed By XiaoChen Zhang
Created On 2019-07-22 03:56:53
Changed On 2019-07-22 03:56:53
Name Spent Time On Game CN
Datasource Id 15
Datasource Type table
Datasource Name tap_dw.dw_spend_group
Visualization Type table
Parameters {"datasource": "15__table", "viz_type": "table", "url_params": {}, "granularity_sqla": null, "time_grain_sqla": "P1D", "time_range": "Last day", "groupby": ["title", "loc"], "metrics": [{"expressionType": "SIMPLE", "column": {"id": 472, "column_name": "spent", "verbose_name": null, "description": null, "expression": "", "filterable": false, "groupby": false, "is_dttm": false, "type": "BIGINT", "database_expression": null, "python_date_format": null, "optionName": "_col_spent"}, "aggregate": "SUM", "sqlExpression": null, "hasCustomLabel": false, "fromFormData": false, "label": "SUM(spent)", "optionName": "metric_hr95mkm6lc7_xb2raeb7dg"}, {"expressionType": "SIMPLE", "column": {"id": 473, "column_name": "uids", "verbose_name": null, "description": null, "expression": "", "filterable": false, "groupby": false, "is_dttm": false, "type": "BIGINT", "database_expression": null, "python_date_format": null, "optionName": "_col_uids"}, "aggregate": "SUM", "sqlExpression": null, "hasCustomLabel": false, "fromFormData": false, "label": "SUM(uids)", "optionName": "metric_9cgeyxrl4xt_ngqmzj4xuj"}], "percent_metrics": [], "timeseries_limit_metric": {"expressionType": "SIMPLE", "column": {"id": 472, "column_name": "spent", "verbose_name": null, "description": null, "expression": "", "filterable": false, "groupby": false, "is_dttm": false, "type": "BIGINT", "database_expression": null, "python_date_format": null, "optionName": "_col_spent"}, "aggregate": "SUM", "sqlExpression": null, "hasCustomLabel": false, "fromFormData": false, "label": "SUM(spent)", "optionName": "metric_8qc48uclqb_ep5xvsqtygj"}, "row_limit": 500, "include_time": false, "order_desc": true, "all_columns": [], "order_by_cols": [], "adhoc_filters": [{"expressionType": "SIMPLE", "subject": "loc", "operator": "==", "comparator": "CN", "clause": "WHERE", "sqlExpression": null, "fromFormData": true, "filterOptionName": "filter_f49ba07s6s_mvah9r0nqnt"}], "table_timestamp_format": "%Y-%m-%d %H:%M:%S", "page_length": 0, "include_search": false, "table_filter": false, "align_pn": false, "color_pn": true}
Description None
Cache Timeout None
Perm [Presto].[dw_spend_group](id:15)
Dashboards [Time Spent on Game (in Minutes) ]