Show Chart

Owners [XiaoYong Yu]
Created By XiaoYong Yu
Changed By XiaoYong Yu
Created On 2019-08-07 03:57:26
Changed On 2019-08-08 09:21:35
Name Oversea_Statistic_Week_Comparsion
Datasource Id 23
Datasource Type table
Datasource Name tap_dw.dw_full_statistics
Visualization Type line
Parameters {"datasource": "23__table", "viz_type": "line", "slice_id": 112, "cache_timeout": 9999, "url_params": {}, "granularity_sqla": "dt", "time_grain_sqla": "P1D", "time_range": "Last month", "metrics": [{"expressionType": "SIMPLE", "column": {"id": 578, "column_name": "uids_cnt", "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_cnt"}, "aggregate": "SUM", "sqlExpression": null, "hasCustomLabel": true, "fromFormData": true, "label": "\u8bbe\u5907\u603b\u6570", "optionName": "metric_uhes2u557oi_xqq1vz02v8"}, {"expressionType": "SIMPLE", "column": {"id": 580, "column_name": "uids_download", "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_download"}, "aggregate": "SUM", "sqlExpression": null, "hasCustomLabel": true, "fromFormData": true, "label": "\u4e0b\u8f7d\u884c\u4e3a\u8bbe\u5907\u603b\u6570", "optionName": "metric_lcnxpdo9n8d_oi7yc20i9t"}, {"expressionType": "SIMPLE", "column": {"id": 581, "column_name": "download_cnt_all", "verbose_name": null, "description": null, "expression": "", "filterable": false, "groupby": false, "is_dttm": false, "type": "BIGINT", "database_expression": null, "python_date_format": null, "optionName": "_col_download_cnt_all"}, "aggregate": "SUM", "sqlExpression": null, "hasCustomLabel": true, "fromFormData": true, "label": "\u4e0b\u8f7d\u603b\u91cf", "optionName": "metric_rux370qkpoe_4l8e6l7j7p"}, {"expressionType": "SIMPLE", "column": {"id": 584, "column_name": "topic_pv_cnt_uid", "verbose_name": null, "description": null, "expression": "", "filterable": false, "groupby": false, "is_dttm": false, "type": "BIGINT", "database_expression": null, "python_date_format": null, "optionName": "_col_topic_pv_cnt_uid"}, "aggregate": "SUM", "sqlExpression": null, "hasCustomLabel": true, "fromFormData": true, "label": "\u5e16\u5b50 PV", "optionName": "metric_tua6qz9pb9_gwrhygnzn75"}, {"expressionType": "SIMPLE", "column": {"id": 586, "column_name": "app_pv_cnt_uid", "verbose_name": null, "description": null, "expression": "", "filterable": false, "groupby": false, "is_dttm": false, "type": "BIGINT", "database_expression": null, "python_date_format": null, "optionName": "_col_app_pv_cnt_uid"}, "aggregate": "SUM", "sqlExpression": null, "hasCustomLabel": true, "fromFormData": true, "label": "PV", "optionName": "metric_lhnc3rx2bgk_a4e2kk1b7t"}, {"expressionType": "SIMPLE", "column": {"id": 588, "column_name": "app_reserve_cnt_uid", "verbose_name": null, "description": null, "expression": "", "filterable": false, "groupby": false, "is_dttm": false, "type": "BIGINT", "database_expression": null, "python_date_format": null, "optionName": "_col_app_reserve_cnt_uid"}, "aggregate": "SUM", "sqlExpression": null, "hasCustomLabel": true, "fromFormData": true, "label": "\u9884\u7ea6\u603b\u6570", "optionName": "metric_q5e8wt3pamg_us63v34e5qa"}, {"expressionType": "SIMPLE", "column": {"id": 592, "column_name": "arpu", "verbose_name": "arpu_pct", "description": null, "expression": "cast(uids_download as double)/uids_cnt", "filterable": true, "groupby": true, "is_dttm": null, "type": "NUMBER", "database_expression": null, "python_date_format": null, "optionName": "_col_arpu"}, "aggregate": "SUM", "sqlExpression": null, "hasCustomLabel": true, "fromFormData": true, "label": "\u4ed8\u8d39(ARPU)", "optionName": "metric_p7uo71pjs8c_kcs8q5jqccf"}, {"expressionType": "SIMPLE", "column": {"id": null, "column_name": "arpu_pct", "verbose_name": "arpu_pct", "description": null, "expression": "cast(uids_download as double)/uids_cnt", "filterable": true, "groupby": true, "is_dttm": null, "type": "NUMBER", "database_expression": null, "python_date_format": null, "optionName": "_col_arpu_pct"}, "aggregate": "SUM", "sqlExpression": null, "hasCustomLabel": true, "fromFormData": true, "label": "\u4ed8\u8d39\u7387", "optionName": "metric_3uo0qkh9jhw_rir1nyz3dkp"}, {"expressionType": "SIMPLE", "column": {"id": 594, "column_name": "conversion", "verbose_name": "conversion", "description": null, "expression": "download_cnt_all/cast(app_pv_cnt_uid as double)", "filterable": true, "groupby": true, "is_dttm": false, "type": "NUMBER", "database_expression": null, "python_date_format": null, "optionName": "_col_conversion"}, "aggregate": "SUM", "sqlExpression": null, "hasCustomLabel": true, "fromFormData": true, "label": "\u8f6c\u5316\u7387", "optionName": "metric_reva5lphxpe_frwcs3t342r"}, {"expressionType": "SIMPLE", "column": {"id": 613, "column_name": "uids_new", "verbose_name": "uids_new", "description": null, "expression": "uids_new", "filterable": true, "groupby": true, "is_dttm": false, "type": "NUMBER", "database_expression": null, "python_date_format": null, "optionName": "_col_uids_new"}, "aggregate": "SUM", "sqlExpression": null, "hasCustomLabel": true, "fromFormData": true, "label": "\u65b0\u589e\u8bbe\u5907\u6570", "optionName": "metric_0o9dxw0kp74d_p6zekln1onk"}], "adhoc_filters": [], "groupby": [], "timeseries_limit_metric": [], "order_desc": true, "contribution": false, "row_limit": 10000, "color_scheme": "bnbColors", "show_brush": "yes", "send_time_range": true, "show_legend": true, "rich_tooltip": true, "show_markers": true, "line_interpolation": "linear", "x_axis_label": "", "bottom_margin": "auto", "x_ticks_layout": "auto", "x_axis_format": "smart_date", "x_axis_showminmax": true, "y_axis_label": "", "left_margin": "auto", "y_axis_showminmax": false, "y_log_scale": false, "y_axis_format": ".4r", "y_axis_bounds": [null, null], "rolling_type": "None", "time_compare": ["1 week"], "comparison_type": "percentage", "resample_how": null, "resample_rule": null, "resample_fillmethod": null, "annotation_layers": []}
Description
Cache Timeout 9999
Perm [Presto_Public].[dw_full_statistics](id:23)
Dashboards [Oversea_Analysis]