Parameters |
{"adhoc_filters": [], "color_scheme": "bnbColors", "comparison_type": "values", "contribution": false, "datasource": "149__table", "date_time_format": "smart_date", "equal_date_size": true, "granularity_sqla": null, "groupby": ["VC_Zone", "SUB_PRF_DS", "AgeYears"], "label_colors": {"1st Year of Graduation": "#b4a76c", "2nd Year of Graduation": "#8ce071", "3rd Year of Graduation": "#00d1c1", "After Office Hour": "#00ffeb", "Age 20": "#b37e00", "Age 21": "#ff8083", "Age 23": "#cc0086", "Age 24": "#00ffeb", "Age 25": "#00a1b3", "Age 27": "#55d12e", "BFSI": "#7b0051", "Banners & Posters": "#cbc29a", "Class I-XI": "#ffb400", "Completed Graduation": "#ff8083", "Completed XII": "#cc0086", "Customers": "#bbedab", "Delhi": "#8ce071", "Display Ads": "#ffd266", "EAST ZONE": "#005c66", "Google Search": "#bbedab", "Haryana": "#ff5a5f", "IT": "#ff5a5f", "Job Opportunity": "#005c66", "Kerala": "#00d1c1", "Knowledge Enhancement": "#ff5a5f", "Madhya Pradesh": "#b37e00", "Maharashtra": "#55d12e", "Male": "#7b0051", "NORTH ZONE": "#ff1ab1", "Newspapers and Magazines": "#ff1ab1", "None": "#b4a76c", "Others": "#007A87", "Pursue Degree": "#988b4e", "Rajasthan": "#988b4e", "SMS": "#ffd266", "SOUTH ZONE": "#00b3a5", "Social Media Ads": "#ff3339", "Tamil Nadu": "#007A87", "Total Customers": "#cbc29a", "Upgrade Skills": "#00b3a5", "WEST ZONE": "#ff3339", "Websites": "#00a1b3", "West Bengal": "#7b0051", "root": "#ffb400"}, "log_scale": true, "metrics": [{"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": "Total Customers", "optionName": "metric_l79wpsqh8q_lu19rmffqt", "sqlExpression": null}], "number_format": "SMART_NUMBER", "order_desc": true, "partition_limit": "", "partition_threshold": "0.05", "resample_method": null, "resample_rule": null, "rich_tooltip": true, "rolling_type": "None", "row_limit": 1000, "slice_id": 119, "time_grain_sqla": "P1D", "time_range": "100 years ago : ", "time_series_option": "not_time", "timeseries_limit_metric": null, "viz_type": "partition", "remote_id": 119, "datasource_name": "Untitled Query 3-NLiW6DBpW", "schema": null, "database_name": "encorestg_carm_db", "import_time": 1571809576}
|