Show Chart

Owners [admin superset, superset admin, AdminUser AdminUser]
Created By admin superset
Changed By admin superset
Created On 2019-11-06 11:45:15
Changed On 2020-01-09 16:02:30
Name Campaign List
Datasource Id 143
Datasource Type table
Datasource Name admin superset-Untitled Query 2-yGS56DEnF
Visualization Type table
Parameters { "adhoc_filters": [], "align_pn": false, "all_columns": [], "color_pn": false, "datasource": "143__table", "granularity_sqla": "lead_dt", "groupby": [ "Campaign" ], "include_search": false, "include_time": false, "metrics": [ { "aggregate": "SUM", "column": { "column_name": "leads", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 1703, "is_dttm": false, "optionName": "_col_leads", "python_date_format": null, "type": "INT", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "Leads", "optionName": "metric_ijnlfl6hq5g_k4nnj6seqj", "sqlExpression": null }, { "aggregate": "SUM", "column": { "column_name": "converts", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 1704, "is_dttm": false, "python_date_format": null, "type": "INT", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "Registration", "optionName": "metric_nw7z50kbhws_8b9xhec4yv9", "sqlExpression": null } ], "order_by_cols": [], "order_desc": true, "page_length": 0, "percent_metrics": [ { "aggregate": "SUM", "column": { "column_name": "leads", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 1703, "is_dttm": false, "optionName": "_col_leads", "python_date_format": null, "type": "INT", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "Lead", "optionName": "metric_vfvpgcs110r_igwblira4bi", "sqlExpression": null }, { "aggregate": "SUM", "column": { "column_name": "converts", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 1704, "is_dttm": false, "optionName": "_col_converts", "python_date_format": null, "type": "INT", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "Registration", "optionName": "metric_3gsjv7phkfv_dx6jdw8pzt", "sqlExpression": null } ], "row_limit": 1000, "slice_id": 249, "table_filter": true, "table_timestamp_format": "%Y-%m-%d %H:%M:%S", "time_grain_sqla": "P1D", "time_range": "No filter", "timeseries_limit_metric": null, "viz_type": "table" }
Description None
Cache Timeout None
Perm [encorestg_carm_db].[admin superset-Untitled Query 2-yGS56DEnF](id:143)
Dashboards [Digital Leads Dashboard (FY April 2019-Till Date) -- Bkp, Datamart Dashboard]
Email Schedules []