Show Chart

Owners [XiaoYong Yu]
Created By XiaoYong Yu
Changed By XiaoYong Yu
Created On 2019-08-07 02:08:52
Changed On 2019-08-08 09:19:15
Name Oversea_Statistic_Chart
Datasource Id 22
Datasource Type table
Datasource Name tap_ods.XiaoYong Yu-Oversea_Statistic_Chart
Visualization Type line
Parameters {"datasource": "22__table", "viz_type": "line", "slice_id": 111, "url_params": {}, "granularity_sqla": "dt", "time_grain_sqla": "P1D", "time_range": "Last month", "metrics": [{"expressionType": "SIMPLE", "column": {"id": 565, "column_name": "uids_cnt", "verbose_name": null, "description": null, "expression": "", "filterable": true, "groupby": true, "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_oa609prgxri_fcfbiyui4sr"}, {"expressionType": "SIMPLE", "column": {"id": 566, "column_name": "uids_download", "verbose_name": null, "description": null, "expression": "", "filterable": true, "groupby": true, "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_gbk671i9b4_a5zgmu2fl9f"}, {"expressionType": "SIMPLE", "column": {"id": 567, "column_name": "download_cnt_all", "verbose_name": null, "description": null, "expression": "", "filterable": true, "groupby": true, "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_dllt55rywkb_xlhxwv3stel"}, {"expressionType": "SIMPLE", "column": {"id": 569, "column_name": "topic_pv_cnt_uid", "verbose_name": null, "description": null, "expression": "", "filterable": true, "groupby": true, "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_lz4zxbvful_x2sas0941m8"}, {"expressionType": "SIMPLE", "column": {"id": 570, "column_name": "app_pv_cnt_uid", "verbose_name": null, "description": null, "expression": "", "filterable": true, "groupby": true, "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_b4zsl6xtmg9_4y84tnbw1b7"}, {"expressionType": "SIMPLE", "column": {"id": 571, "column_name": "app_reserve_cnt_uid", "verbose_name": null, "description": null, "expression": "", "filterable": true, "groupby": true, "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_1koexfnbgkj_racwiv6ocbs"}, {"expressionType": "SIMPLE", "column": {"id": 572, "column_name": "arpu", "verbose_name": null, "description": null, "expression": "", "filterable": true, "groupby": true, "is_dttm": false, "type": "DOUBLE", "database_expression": null, "python_date_format": null, "optionName": "_col_arpu"}, "aggregate": "SUM", "sqlExpression": null, "hasCustomLabel": true, "fromFormData": true, "label": "\u4ed8\u8d39(ARPU)", "optionName": "metric_v36kygdxr_ocrr51npzup"}, {"expressionType": "SIMPLE", "column": {"id": 573, "column_name": "arpu_pct", "verbose_name": null, "description": null, "expression": "", "filterable": true, "groupby": true, "is_dttm": false, "type": "DOUBLE", "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_5brckflmbs2_to1enixe45b"}, {"expressionType": "SIMPLE", "column": {"id": 575, "column_name": "Conversion", "verbose_name": "conversion", "description": null, "expression": "cast(app_pv_cnt_uid as double)/download_cnt_all", "filterable": true, "groupby": true, "is_dttm": null, "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_cbz9z69wayf_n2ctu51d7ig"}, {"expressionType": "SIMPLE", "column": {"id": 612, "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_2nrhxc5qoqa_st9b74eo4bn"}], "adhoc_filters": [], "groupby": [], "timeseries_limit_metric": null, "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": "flat", "x_axis_format": "%Y-%m-%d", "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": [0, null], "rolling_type": null, "rolling_periods": "", "min_periods": "", "time_compare": [], "comparison_type": null, "resample_how": null, "resample_rule": "1D", "resample_fillmethod": null, "annotation_layers": []}
Description
Cache Timeout None
Perm [Presto_Public].[XiaoYong Yu-Oversea_Statistic_Chart](id:22)
Dashboards [Oversea_Analysis]