| Parameters |
{"adhoc_filters": [{"clause": "WHERE", "comparator": null, "expressionType": "SQL", "filterOptionName": "filter_mtxdk0ehnb_uwe2yaq2qag", "fromFormData": true, "operator": null, "sqlExpression": "createdon >= '2019-12-01'", "subject": null}, {"clause": "WHERE", "comparator": "Automated", "expressionType": "SIMPLE", "filterOptionName": "filter_v766svwfmv9_bvg7iwyzarr", "fromFormData": true, "operator": "==", "sqlExpression": null, "subject": "QuizType"}], "annotation_layers": [], "bar_stacked": false, "bottom_margin": "auto", "color_scheme": "bnbColors", "comparison_type": "values", "contribution": false, "datasource": "175__table", "granularity_sqla": "createdon", "groupby": ["RegionName"], "label_colors": {"Ahmedabad": "#ff3339", "App Installs": "#8ce071", "Automated": "#005c66", "Average Rating": "#7b0051", "BP": "#007A87", "Bangalore": "#ffb400", "Career Programs": "#ff5a5f", "CareerSeries": "#55d12e", "Chennai": "#cc0086", "Delhi & NCR": "#00a1b3", "Delhi Networks": "#ffd266", "Faculty": "#ff1ab1", "Hyderabad": "#ff8083", "Kolkata": "#bbedab", "Mumbai": "#00ffeb", "NCS": "#988b4e", "North Networks II": "#cbc29a", "OWN": "#00d1c1", "Other Courses": "#00b3a5", "Pune": "#b4a76c", "Session Marked By App": "#ff5a5f", "Session Rating(in%)": "#007A87", "TPAAS": "#b37e00", "Total Session to be Marked": "#7b0051"}, "left_margin": "auto", "line_interpolation": "linear", "metrics": [{"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Quiz Published", "optionName": "metric_8gf6ibsh2n5_t0lpk2dy26", "sqlExpression": "ROUND(CAST(sum(responded) AS FLOAT)/CAST(COUNT(pollid) AS FLOAT)*100,1)"}], "order_desc": true, "reduce_x_ticks": false, "resample_method": null, "resample_rule": null, "rich_tooltip": true, "rolling_type": "None", "row_limit": 10000, "show_bar_value": true, "show_brush": "auto", "show_controls": false, "show_legend": true, "slice_id": 419, "time_grain_sqla": "P1M", "time_range": "No filter", "timeseries_limit_metric": null, "url_params": {}, "viz_type": "bar", "x_axis_format": "smart_date", "x_axis_label": "", "x_axis_showminmax": false, "x_ticks_layout": "45u00b0", "y_axis_bounds": [null, null], "y_axis_format": "SMART_NUMBER", "y_axis_label": "", "y_axis_showminmax": false, "y_log_scale": false, "remote_id": 419, "datasource_name": "quizdata", "schema": null, "database_name": "app_and_channel_analytics_db", "import_time": 1584701568}
|
