Show Chart

Owners [superset admin]
Created By superset admin
Changed By superset admin
Created On 2019-10-25 09:19:21
Changed On 2019-10-30 16:13:41
Name Registered : By Zone & Age
Datasource Id 95
Datasource Type table
Datasource Name superset admin-Untitled Query 3-aUwH7LNo2
Visualization Type partition
Parameters { "adhoc_filters": [], "color_scheme": "SUPERSET_DEFAULT", "comparison_type": "values", "contribution": false, "datasource": "95__table", "date_time_format": "smart_date", "equal_date_size": true, "granularity_sqla": null, "groupby": [ "VC_Zone", "AgeYears" ], "label_colors": { "": "#bcbd22", "18-20": "#d62728", "1st Year of Graduation": "#1f77b4", "21-23": "#9467bd", "24-26": "#8c564b", "27-29": "#2ca02c", "2nd Year of Graduation": "#7f7f7f", "30 or more": "#ff7f0e", "3rd Year of Graduation": "#e377c2", "4th Year of Graduation": "#bcbd22", "After Call Center Working Hours": "#8c564b", "After Office Hour": "#8c564b", "Age 0": "#9467bd", "Age 1": "#9467bd", "Age 15": "#7f7f7f", "Age 16": "#2ca02c", "Age 17": "#8c564b", "Age 18": "#e377c2", "Age 19": "#1f77b4", "Age 20": "#7f7f7f", "Age 21": "#17becf", "Age 22": "#8c564b", "Age 23": "#e377c2", "Age 24": "#bcbd22", "Age 25": "#ff7f0e", "Age 26": "#2ca02c", "Age 27": "#7f7f7f", "Age 28": "#17becf", "Age 29": "#d62728", "Age 30": "#bcbd22", "Age 31": "#9467bd", "Age 32": "#bcbd22", "Age 33": "#17becf", "Age 34": "#1f77b4", "Age 35": "#d62728", "Age 38": "#8c564b", "Age 45": "#d62728", "Age 47": "#1f77b4", "Age 7": "#e377c2", "Age 72": "#ff7f0e", "Andhra Pradesh": "#e377c2", "Arts": "#7f7f7f", "Assam": "#1f77b4", "BFSI": "#ff7f0e", "Banner": "#7f7f7f", "Below 18": "#e377c2", "Bihar": "#17becf", "Chandigarh (Ut)": "#1f77b4", "Class I-XI": "#e377c2", "Commerce": "#e377c2", "Commerce + CA/ICWAI/Other Certifications": "#17becf", "Completed Graduation": "#8c564b", "Completed XII": "#ff7f0e", "Delhi": "#2ca02c", "Diploma Holder": "#9467bd", "Diploma: Other Streams": "#bcbd22", "EAST ZONE": "#9467bd", "Email": "#ff7f0e", "Engineering: Computer Science/IT": "#2ca02c", "Engineering: Electrical/ Electronics and Communication": "#d62728", "Engineering: Mechanical": "#7f7f7f", "Engineering: Other Streams": "#17becf", "Facebook": "#2ca02c", "Female": "#ff7f0e", "Friends and Relatives": "#2ca02c", "Google Search": "#9467bd", "Gujarat": "#2ca02c", "Haryana": "#9467bd", "Himachal Pradesh": "#17becf", "Hoarding": "#1f77b4", "IT": "#1f77b4", "Internet Advertisement": "#d62728", "Jammu And Kashmir": "#7f7f7f", "Jharkhand": "#2ca02c", "Just Dial": "#9467bd", "Karnataka": "#8c564b", "Kerala": "#7f7f7f", "Madhya Pradesh": "#bcbd22", "Maharashtra": "#ff7f0e", "Male": "#1f77b4", "Management: MBA": "#1f77b4", "NIIT Centers": "#d62728", "NIIT Contact Center": "#1f77b4", "NIIT Kiosk/Seminar/Presentation": "#ff7f0e", "NORTH ZONE": "#2ca02c", "Newspaper Advertisement": "#bcbd22", "Newspaper Insert/Pamphlet": "#8c564b", "No Response": "#bcbd22", "None": "#2ca02c", "Orissa": "#ff7f0e", "Others": "#17becf", "Post Graduate": "#d62728", "Poster": "#bcbd22", "Punjab": "#e377c2", "Pursuing Graduation": "#7f7f7f", "Pursuing Post Graduation": "#8c564b", "Radio": "#17becf", "Rajasthan": "#8c564b", "Recommendation from a friend/relative": "#17becf", "SMS": "#e377c2", "SOUTH ZONE": "#ff7f0e", "Science: IT/Computer Application": "#9467bd", "Science: Other Streams": "#8c564b", "TV Ads": "#e377c2", "Tamil Nadu": "#d62728", "Telangana": "#9467bd", "Tripura": "#d62728", "Uttar Pradesh": "#d62728", "Volume": "#1f77b4", "WEST ZONE": "#d62728", "Web banner": "#7f7f7f", "Websites": "#9467bd", "West Bengal": "#bcbd22", "Working Professional": "#2ca02c", "count": "#ff7f0e", "root": "#17becf" }, "log_scale": true, "metrics": [ { "aggregate": "SUM", "column": { "column_name": "Leads", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 1467, "is_dttm": false, "optionName": "_col_Leads", "python_date_format": null, "type": "INT", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "Volume", "optionName": "metric_py7ayrvw6x_u3mxqjargs", "sqlExpression": null } ], "number_format": "SMART_NUMBER", "order_desc": true, "partition_limit": "5", "partition_threshold": "0.05", "resample_method": null, "resample_rule": null, "rich_tooltip": true, "rolling_type": "None", "row_limit": 10, "slice_id": 152, "time_grain_sqla": "P1D", "time_range": "100 years ago : ", "time_series_option": "not_time", "timeseries_limit_metric": null, "url_params": {}, "viz_type": "partition" }
Description None
Cache Timeout None
Perm [encorestg_carm_db].[superset admin-Untitled Query 3-aUwH7LNo2](id:95)
Dashboards []
Email Schedules []