Parameters |
{
"adhoc_filters": [
{
"clause": "WHERE",
"comparator": [
"2019"
],
"expressionType": "SIMPLE",
"filterOptionName": "6f07dfb5-37ba-4a1b-a1f0-f76c71eed705",
"operator": "in",
"subject": "LEAD_YEAR"
},
{
"clause": "WHERE",
"comparator": [
"April",
"May",
"June",
"July",
"August",
"September",
"October",
"November"
],
"expressionType": "SIMPLE",
"filterOptionName": "a2e930b7-c1f1-4438-bc9e-479ff2635c27",
"operator": "in",
"subject": "LEAD_MONTH"
}
],
"color_scheme": "bnbColors",
"datasource": "144__table",
"granularity_sqla": null,
"label_colors": {
"": "#7f7f7f",
"18-20": "#e377c2",
"1st Year of Graduation": "#17becf",
"21-23": "#8c564b",
"24-26": "#7f7f7f",
"27-29": "#1f77b4",
"2nd Year of Graduation": "#bcbd22",
"30 or more": "#bcbd22",
"3rd Year of Graduation": "#7f7f7f",
"4th Year of Graduation": "#d62728",
"After Call Center Working Hours": "#1f77b4",
"After Office Hour": "#7f7f7f",
"Andhra Pradesh": "#d62728",
"Arts": "#17becf",
"Assam": "#bcbd22",
"BFSI": "#ff7f0e",
"Banner": "#1f77b4",
"Below 18": "#17becf",
"Bihar": "#e377c2",
"Chandigarh (Ut)": "#2ca02c",
"Chattisgarh": "#8c564b",
"Class I-XI": "#1f77b4",
"Commerce": "#bcbd22",
"Commerce + CA/ICWAI/Other Certifications": "#17becf",
"Completed Graduation": "#2ca02c",
"Completed XII": "#9467bd",
"Delhi": "#bcbd22",
"Diploma Holder": "#2ca02c",
"Diploma: Other Streams": "#1f77b4",
"EAST ZONE": "#e377c2",
"Email": "#e377c2",
"Engineering: Computer Science/IT": "#d62728",
"Engineering: Electrical/ Electronics and Communication": "#8c564b",
"Engineering: Mechanical": "#9467bd",
"Engineering: Other Streams": "#bcbd22",
"Facebook": "#9467bd",
"Female": "#2ca02c",
"Friends and Relatives": "#ff7f0e",
"Google Search": "#1f77b4",
"Gujarat": "#17becf",
"Haryana": "#1f77b4",
"Himachal Pradesh": "#7f7f7f",
"Hoarding": "#bcbd22",
"IT": "#1f77b4",
"Internet Advertisement": "#17becf",
"Jammu And Kashmir": "#9467bd",
"Jharkhand": "#8c564b",
"Just Dial": "#9467bd",
"Karnataka": "#1f77b4",
"Kerala": "#8c564b",
"Madhya Pradesh": "#ff7f0e",
"Maharashtra": "#bcbd22",
"Male": "#ff7f0e",
"NIIT Centers": "#ff7f0e",
"NIIT Contact Center": "#d62728",
"NIIT Kiosk/Seminar/Presentation": "#7f7f7f",
"NORTH ZONE": "#d62728",
"Newspaper Advertisement": "#d62728",
"Newspaper Insert/Pamphlet": "#2ca02c",
"None": "#7f7f7f",
"OLBS": "#2ca02c",
"Orissa": "#7f7f7f",
"Others": "#2ca02c",
"Post Graduate": "#8c564b",
"Poster": "#8c564b",
"Punjab": "#d62728",
"Pursuing Graduation": "#d62728",
"Pursuing Post Graduation": "#ff7f0e",
"Radio": "#17becf",
"Rajasthan": "#e377c2",
"Recommendation from a friend/relative": "#2ca02c",
"SMS": "#ff7f0e",
"SOUTH ZONE": "#8c564b",
"Science: IT/Computer Application": "#ff7f0e",
"Science: Other Streams": "#1f77b4",
"TV Ads": "#e377c2",
"Tamil Nadu": "#2ca02c",
"Telangana": "#ff7f0e",
"Uttar Pradesh": "#17becf",
"Volume": "#2ca02c",
"WEST ZONE": "#9467bd",
"Web banner": "#ff7f0e",
"Websites": "#e377c2",
"West Bengal": "#9467bd",
"Working Professional": "#e377c2",
"root": "#9467bd"
},
"metric": {
"aggregate": "SUM",
"column": {
"column_name": "Leads",
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"id": 1710,
"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_432s5vfqapb_5d6wo5relxq",
"sqlExpression": null
},
"rotation": "flat",
"row_limit": "6",
"series": "Awareness_Source",
"size_from": 20,
"size_to": 70,
"slice_id": 250,
"time_grain_sqla": "P1D",
"time_range": "100 years ago : ",
"url_params": {},
"viz_type": "word_cloud"
}
|