| Parameters |
{
"adhoc_filters": [
{
"clause": "WHERE",
"comparator": "N",
"expressionType": "SIMPLE",
"filterOptionName": "filter_e428hc1848b_3qmpj9i9s1l",
"fromFormData": true,
"operator": "==",
"sqlExpression": null,
"subject": "intrstd_flg"
},
{
"clause": "WHERE",
"comparator": null,
"expressionType": "SQL",
"filterOptionName": "filter_8f7og6s8ssr_lyiy6xt53f",
"fromFormData": true,
"operator": null,
"sqlExpression": "not_intrstd_dspostn in ('Product Fee Too High','Program Not Available','Product Duration Not Suitable','Center Too Far','Looking For Online Program','Curriculum Not As Expected','Already Placed','Joined Alternate Course','Looking For Job Not A Course','Batch Schedule Not Suitable')",
"subject": null
}
],
"bar_stacked": false,
"bottom_margin": "auto",
"color_scheme": "bnbColors",
"columns": [],
"contribution": false,
"datasource": "215__table",
"granularity_sqla": "Activity_Created_Date",
"groupby": [
"not_intrstd_dspostn"
],
"label_colors": {
"Activities": "#7b0051",
"BDE's": "#8ce071",
"Leads": "#007A87",
"Not Interested Leads": "#ff5a5f",
"R/L": "#ffb400",
"Registered": "#00d1c1"
},
"metrics": [
{
"aggregate": null,
"column": null,
"expressionType": "SQL",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Not Interested Leads",
"optionName": "metric_ivx317h564_snpu4hjt708",
"sqlExpression": "ROUND(CAST(COUNT(distinct lead_cd) AS FLOAT)/MAX(lead_total)*100,1)"
}
],
"order_bars": false,
"reduce_x_ticks": false,
"row_limit": 1000,
"show_bar_value": true,
"show_controls": false,
"show_legend": true,
"slice_id": 482,
"time_grain_sqla": "P1D",
"time_range": "No filter",
"url_params": {},
"viz_type": "dist_bar",
"x_axis_label": "",
"x_ticks_layout": "auto",
"y_axis_format": "SMART_NUMBER",
"y_axis_label": ""
}
|
