Show Chart

Owners [AdminUser AdminUser]
Created By AdminUser AdminUser
Changed By AdminUser AdminUser
Created On 2020-06-17 15:58:29
Changed On 2020-06-17 15:58:29
Name Total : Lead Structure
Datasource Id 523
Datasource Type table
Datasource Name null.AdminUser AdminUser-Query dbo.appinstalldata-YU37gEZ55
Visualization Type table
Parameters { "adhoc_filters": [], "align_pn": false, "all_columns": [], "color_pn": true, "datasource": "523__table", "granularity_sqla": "Date", "groupby": [ "Total" ], "include_search": false, "include_time": false, "metrics": [ { "aggregate": "COUNT_DISTINCT", "column": { "column_name": "lead_Cd", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 8341, "is_dttm": false, "optionName": "_col_lead_Cd", "python_date_format": null, "type": "STRING", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "Contacted", "optionName": "metric_j69cl1472s_96chyw3dnkp", "sqlExpression": null }, { "aggregate": "COUNT_DISTINCT", "column": { "column_name": "interrested_career_Lead_cd", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 8343, "is_dttm": false, "optionName": "_col_interrested_career_Lead_cd", "python_date_format": null, "type": "OBJECT", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "Interested Career", "optionName": "metric_onh34kd27ag_xr25ie4q1ip", "sqlExpression": null }, { "aggregate": "COUNT_DISTINCT", "column": { "column_name": "interrested_Modular_Lead_cd", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 8344, "is_dttm": false, "optionName": "_col_interrested_Modular_Lead_cd", "python_date_format": null, "type": "OBJECT", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "Interested Modular", "optionName": "metric_8x1kjxlx2ju_r49t99uvv5c", "sqlExpression": null }, { "aggregate": "COUNT_DISTINCT", "column": { "column_name": "Interested_Lead_cd", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 8342, "is_dttm": false, "optionName": "_col_Interested_Lead_cd", "python_date_format": null, "type": "OBJECT", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "Interested Others", "optionName": "metric_6rb7tft2p4c_3pymed270qz", "sqlExpression": null } ], "order_by_cols": [], "order_desc": false, "page_length": 0, "percent_metrics": [], "row_limit": 1000, "table_filter": false, "table_timestamp_format": "%Y-%m-%d %H:%M:%S", "time_grain_sqla": "P1D", "time_range": "100 years ago : ", "timeseries_limit_metric": { "aggregate": "MAX", "column": { "column_name": "PA_Name", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 8332, "is_dttm": false, "optionName": "_col_PA_Name", "python_date_format": null, "type": "STRING", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": false, "hasCustomLabel": false, "label": "MAX(PA_Name)", "optionName": "metric_ac62oraes6t_0w8isdl0cvyn", "sqlExpression": null }, "url_params": {}, "viz_type": "table" }
Description None
Cache Timeout None
Perm [None].[AdminUser AdminUser-Query dbo.appinstalldata-YU37gEZ55](id:523)
Dashboards [PA Leaderboard Teamview IT (Modular) ]
Email Schedules []