Parameters |
{
"adhoc_filters": [],
"bar_stacked": false,
"bottom_margin": "auto",
"color_scheme": "bnbColors",
"columns": [],
"contribution": false,
"datasource": "218__table",
"granularity_sqla": "actvty_dt",
"groupby": [
"actvty_nm"
],
"label_colors": {
"APSE": "#005c66",
"Activities": "#00b3a5",
"B/R": "#ff5a5f",
"CSMSP": "#ffd266",
"Cash": "#b4a76c",
"Collection": "#988b4e",
"Credit Card": "#ff8083",
"GNTSE": "#cbc29a",
"HIGH": "#7b0051",
"LOW": "#00d1c1",
"Lead Ratings": "#ff5a5f",
"MEDIUM": "#007A87",
"Not Interested Leads": "#ffb400",
"Order Intake": "#b37e00",
"PGBF": "#ff3339",
"PGDBO": "#bbedab",
"PGPAG": "#ff1ab1",
"PIJ7V": "#00a1b3",
"Registration": "#55d12e",
"VERY LOW": "#8ce071",
"WAX31": "#00ffeb",
"WOM31": "#cc0086"
},
"metrics": [
{
"aggregate": null,
"column": null,
"expressionType": "SQL",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Activities",
"optionName": "metric_zrbw3p8nq4_earxjf9uex",
"sqlExpression": "CAST(CAST(SUM(given_actvty_rtngs) AS FLOAT)/SUM(ttl_actvty_rtngs) AS FLOAT)"
}
],
"order_bars": false,
"reduce_x_ticks": false,
"row_limit": 10000,
"show_bar_value": true,
"show_controls": false,
"show_legend": true,
"time_grain_sqla": "P1D",
"time_range": "No filter",
"url_params": {},
"viz_type": "dist_bar",
"x_axis_label": "",
"x_ticks_layout": "auto",
"y_axis_format": ",.1%",
"y_axis_label": ""
}
|