Parameters |
{"adhoc_filters": [{"clause": "WHERE", "comparator": "NCS", "expressionType": "SIMPLE", "filterOptionName": "filter_1uhg1ihzfj6_3e3x80npfp9", "fromFormData": true, "operator": "==", "sqlExpression": null, "subject": "CourseType"}], "bar_stacked": false, "bottom_margin": "auto", "color_scheme": "bnbColors", "columns": [], "contribution": false, "datasource": "178__table", "granularity_sqla": "SessionDate", "groupby": ["courseCode"], "label_colors": {"Average Rating": "#8ce071", "BP": "#ff5a5f", "OWN": "#7b0051", "Session Marked By App": "#007A87", "Total Session to be Marked": "#00d1c1"}, "metrics": [{"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Session Rating(in%)", "optionName": "metric_ne61e3wcl5j_tnqtwmp5vdh", "sqlExpression": "CAST(SUM(TotalNoOfStudentGivenFeedback)/SUM(TotalNoOfStudentInBatch) 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": "", "remote_id": 408, "datasource_name": "sessionratingdata", "schema": null, "database_name": "app_and_channel_analytics_db", "import_time": 1584701568}
|