Parameters |
{"adhoc_filters": [{"clause": "WHERE", "comparator": "STH Programs", "expressionType": "SIMPLE", "filterOptionName": "filter_t0y3fgl0el_dy9u7aiokqo", "fromFormData": true, "operator": "!=", "sqlExpression": null, "subject": "CourseType"}], "bar_stacked": false, "bottom_margin": "auto", "color_scheme": "bnbColors", "columns": ["CourseType"], "contribution": false, "datasource": "178__table", "granularity_sqla": "SessionDate", "groupby": ["Region"], "label_colors": {"Average Rating": "#8ce071", "BP": "#ff5a5f", "OWN": "#7b0051", "Session Marked By App": "#007A87", "Session Rating(in%)": "#ffb400", "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": 409, "datasource_name": "sessionratingdata", "schema": null, "database_name": "app_and_channel_analytics_db", "import_time": 1584701568}
|