| Parameters |
{
"adhoc_filters": [
{
"clause": "WHERE",
"comparator": "After Office Hour",
"expressionType": "SIMPLE",
"filterOptionName": "filter_vnco3pq9pep_mnjvdka2bye",
"fromFormData": true,
"operator": "!=",
"sqlExpression": null,
"subject": "SUB_PRF_DS"
}
],
"color_scheme": "bnbColors",
"datasource": "92__table",
"granularity_sqla": null,
"label_colors": {
"": "#007A87",
"1st Year of Graduation": "#8ce071",
"2nd Year of Graduation": "#00d1c1",
"3rd Year of Graduation": "#7b0051",
"4th Year of Graduation": "#ffb400",
"After Call Center Working Hours": "#b4a76c",
"After Office Hour": "#ff8083",
"Age 0": "#ffd266",
"Age 1": "#cc0086",
"Age 13": "#b4a76c",
"Age 14": "#005c66",
"Age 15": "#988b4e",
"Age 16": "#cbc29a",
"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",
"Age 26": "#00a1b3",
"Age 27": "#ff3339",
"Age 28": "#bbedab",
"Age 29": "#00ffeb",
"Age 30": "#00b3a5",
"Age 31": "#ffd266",
"Age 32": "#8ce071",
"Age 33": "#00ffeb",
"Age 34": "#ff1ab1",
"Age 35": "#00a1b3",
"Age 36": "#7b0051",
"Age 38": "#55d12e",
"Age 39": "#00d1c1",
"Age 42": "#ffb400",
"Age 45": "#007A87",
"Age 47": "#bbedab",
"Age 48": "#ff5a5f",
"Age 7": "#ff8083",
"Age 72": "#b37e00",
"Andhra Pradesh": "#00a1b3",
"Arts": "#988b4e",
"Assam": "#cbc29a",
"BFSI": "#ff3339",
"Banner": "#988b4e",
"Bihar": "#ffd266",
"Chandigarh (Ut)": "#00d1c1",
"Class I-XI": "#ffd266",
"Commerce": "#00b3a5",
"Commerce + CA/ICWAI/Other Certifications": "#00d1c1",
"Completed Graduation": "#ff5a5f",
"Completed XII": "#b4a76c",
"Customers": "#cc0086",
"Delhi": "#005c66",
"Diploma Holder": "#bbedab",
"Diploma: Other Streams": "#007A87",
"EAST ZONE": "#7b0051",
"Email": "#cbc29a",
"Engineering: Computer Science/IT": "#ff1ab1",
"Engineering: Electrical/ Electronics and Communication": "#005c66",
"Engineering: Mechanical": "#7b0051",
"Engineering: Other Streams": "#ff5a5f",
"Facebook": "#ff3339",
"Female": "#ff8083",
"Friends and Relatives": "#b4a76c",
"Google Search": "#ff8083",
"Gujarat": "#ffb400",
"Haryana": "#55d12e",
"Himachal Pradesh": "#007A87",
"Hoarding": "#ff5a5f",
"IT": "#cbc29a",
"Internet Advertisement": "#ffb400",
"Jammu And Kashmir": "#ff5a5f",
"Jharkhand": "#ff1ab1",
"Just Dial": "#00b3a5",
"Karnataka": "#cc0086",
"Kerala": "#00ffeb",
"Leads": "#00d1c1",
"Madhya Pradesh": "#7b0051",
"Maharashtra": "#8ce071",
"Male": "#b4a76c",
"Management: MBA": "#ffb400",
"NIIT Centers": "#ff1ab1",
"NIIT Contact Center": "#ffd266",
"NIIT Kiosk/Seminar/Presentation": "#00d1c1",
"NORTH ZONE": "#b37e00",
"Newspaper Advertisement": "#00ffeb",
"Newspaper Insert/Pamphlet": "#55d12e",
"No Response": "#8ce071",
"None": "#cc0086",
"Orissa": "#ff3339",
"Others": "#007A87",
"Post Graduate": "#ff8083",
"Poster": "#7b0051",
"Punjab": "#988b4e",
"Pursuing Graduation": "#00ffeb",
"Pursuing Post Graduation": "#cc0086",
"Radio": "#007A87",
"Rajasthan": "#b37e00",
"Recommendation from a friend/relative": "#bbedab",
"SMS": "#cc0086",
"SOUTH ZONE": "#988b4e",
"Science: IT/Computer Application": "#55d12e",
"Science: Other Streams": "#b37e00",
"TV Ads": "#b37e00",
"Tamil Nadu": "#b4a76c",
"Telangana": "#ff8083",
"Total Customers": "#55d12e",
"Tripura": "#005c66",
"Uttar Pradesh": "#00b3a5",
"WEST ZONE": "#ff5a5f",
"Web banner": "#00a1b3",
"Websites": "#8ce071",
"West Bengal": "#bbedab",
"Working Professional": "#00a1b3",
"count": "#ffb400",
"root": "#8ce071"
},
"metric": {
"aggregate": "SUM",
"column": {
"column_name": "Leads",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 1478,
"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_ti0d047vaj_a3bdn0b7sw6",
"sqlExpression": null
},
"rotation": "flat",
"row_limit": "5",
"series": "SUB_PRF_DS",
"size_from": 20,
"size_to": 35,
"slice_id": 70,
"time_grain_sqla": "P1D",
"time_range": "100 years ago : ",
"viz_type": "word_cloud"
}
|
