| Parameters |
{
"adhoc_filters": [
{
"clause": "WHERE",
"comparator": null,
"expressionType": "SQL",
"filterOptionName": "filter_05tljh87jeli_imfydo2sklq",
"fromFormData": true,
"operator": null,
"sqlExpression": "VC_Zone != '' ",
"subject": null
}
],
"color_scheme": "d3Category20",
"comparison_type": "values",
"contribution": true,
"datasource": "99__table",
"date_time_format": "smart_date",
"equal_date_size": true,
"granularity_sqla": null,
"groupby": [
"VC_Zone",
"SUB_PRF_DS"
],
"label_colors": {
"": "#007A87",
"1st Year of Graduation": "#b4a76c",
"2nd Year of Graduation": "#ffb400",
"3rd Year of Graduation": "#00d1c1",
"4th Year of Graduation": "#ff8083",
"Age 17": "#005c66",
"Age 18": "#cbc29a",
"Age 19": "#00ffeb",
"Age 20": "#00a1b3",
"Age 21": "#bbedab",
"Age 22": "#ffd266",
"Age 23": "#ff3339",
"Age 24": "#ff1ab1",
"Age 25": "#00b3a5",
"Arts": "#988b4e",
"BFSI": "#7b0051",
"Class I-XI": "#ff3339",
"Commerce": "#00b3a5",
"Commerce + CA/ICWAI/Other Certifications": "#00d1c1",
"Completed Graduation": "#007A87",
"Completed XII": "#cc0086",
"Diploma Holder": "#cbc29a",
"Diploma: Other Streams": "#007A87",
"EAST ZONE": "#7b0051",
"Engineering: Computer Science/IT": "#ff1ab1",
"Engineering: Electrical/ Electronics and Communication": "#005c66",
"Engineering: Mechanical": "#7b0051",
"Engineering: Other Streams": "#ff5a5f",
"Female": "#b4a76c",
"IT": "#ff5a5f",
"Leads": "#8ce071",
"Male": "#ffb400",
"Management: MBA": "#cc0086",
"NORTH ZONE": "#b37e00",
"No Response": "#8ce071",
"None": "#ff8083",
"Others": "#8ce071",
"Post Graduate": "#00a1b3",
"Pursuing Graduation": "#ffd266",
"Pursuing Post Graduation": "#00ffeb",
"SOUTH ZONE": "#988b4e",
"Science: IT/Computer Application": "#55d12e",
"Science: Other Streams": "#b37e00",
"Total Customers": "#55d12e",
"WEST ZONE": "#ff5a5f",
"Working Professional": "#bbedab",
"root": "#00d1c1"
},
"log_scale": true,
"metrics": [
{
"aggregate": "SUM",
"column": {
"column_name": "Leads",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 1430,
"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_x0x5z2k4ci_e1tgm2ivwbs",
"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": 37,
"time_grain_sqla": "P1D",
"time_range": "100 years ago : ",
"time_series_option": "not_time",
"timeseries_limit_metric": null,
"viz_type": "partition"
}
|
