Parameters |
{"adhoc_filters": [], "color_scheme": "bnbColors", "datasource": "149__table", "granularity_sqla": null, "groupby": ["AgeYears", "SUB_PRF_DS"], "label_colors": {"1st Year of Graduation": "#b4a76c", "2nd Year of Graduation": "#8ce071", "3rd Year of Graduation": "#00d1c1", "After Office Hour": "#00d1c1", "Age 18": "#8ce071", "Age 19": "#00d1c1", "Age 20": "#007A87", "Age 21": "#ff5a5f", "Age 22": "#988b4e", "Age 23": "#b37e00", "Age 24": "#55d12e", "Age 25": "#00b3a5", "Age 26": "#7b0051", "Age 27": "#ffb400", "Age 29": "#b4a76c", "Arts": "#cbc29a", "BFSI": "#7b0051", "Banners & Posters": "#ff8083", "Class I-XI": "#ffb400", "Commerce": "#bbedab", "Completed Graduation": "#ff8083", "Completed XII": "#cc0086", "Customers": "#ffb400", "Delhi": "#8ce071", "Display Ads": "#b4a76c", "EAST ZONE": "#bbedab", "Engineering: Computer Science/IT": "#ffd266", "Female": "#005c66", "Google Search": "#7b0051", "Haryana": "#00b3a5", "IT": "#ff5a5f", "Job Opportunity": "#00ffeb", "Kerala": "#988b4e", "Knowledge Enhancement": "#cbc29a", "Leads": "#ffd266", "Madhya Pradesh": "#ff1ab1", "Maharashtra": "#ff3339", "Male": "#ff3339", "Management: MBA (Marketing)": "#00a1b3", "NORTH ZONE": "#cc0086", "Newspapers and Magazines": "#00a1b3", "None": "#ff1ab1", "Others": "#007A87", "Pursue Degree": "#ffd266", "Rajasthan": "#005c66", "SMS": "#007A87", "SOUTH ZONE": "#00a1b3", "Science: IT/Computer Application": "#00ffeb", "Social Media Ads": "#cc0086", "Tamil Nadu": "#b37e00", "Total Customers": "#ff8083", "Upgrade Skills": "#bbedab", "WEST ZONE": "#00ffeb", "Websites": "#ff5a5f", "West Bengal": "#55d12e", "root": "#cbc29a"}, "metric": {"aggregate": "SUM", "column": {"column_name": "Leads", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 1504, "is_dttm": false, "optionName": "_col_Leads", "python_date_format": null, "type": "INT", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "Customers", "optionName": "metric_4xg8a4k0rja_bsd8gwhepf", "sqlExpression": null}, "row_limit": 1000, "secondary_metric": null, "slice_id": 120, "time_grain_sqla": "P1D", "time_range": "100 years ago : ", "url_params": {}, "viz_type": "sunburst", "remote_id": 120, "datasource_name": "Untitled Query 3-NLiW6DBpW", "schema": null, "database_name": "encorestg_carm_db", "import_time": 1571809576}
|