Show Chart

Owners [AdminUser AdminUser]
Created By AdminUser AdminUser
Changed By AdminUser AdminUser
Created On 2020-03-03 11:36:32
Changed On 2020-03-03 11:36:32
Name Activity Wise Avg. Ratings
Datasource Id 218
Datasource Type table
Datasource Name activity_lead_datamart_1
Visualization Type dist_bar
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": "" }
Description None
Cache Timeout None
Perm [app_analytics_db].[activity_lead_datamart_1](id:218)
Dashboards []
Email Schedules []