| Parameters |
{"adhoc_filters": [{"clause": "WHERE", "comparator": "STH Programs", "expressionType": "SIMPLE", "filterOptionName": "filter_t0y3fgl0el_dy9u7aiokqo", "fromFormData": true, "operator": "!=", "sqlExpression": null, "subject": "CourseType"}, {"clause": "WHERE", "comparator": null, "expressionType": "SQL", "filterOptionName": "filter_a4o9f4j0fu4_udese095qio", "fromFormData": true, "operator": null, "sqlExpression": "SessionDate >= '2019-01-01'", "subject": null}], "annotation_layers": [], "bar_stacked": false, "bottom_margin": "auto", "color_scheme": "bnbColors", "comparison_type": "values", "contribution": false, "datasource": "178__table", "granularity_sqla": "SessionDate", "groupby": ["CourseType"], "label_colors": {"Average Rating": "#8ce071", "BP": "#ff5a5f", "Career Programs": "#b4a76c", "NCS": "#ff8083", "OWN": "#7b0051", "Session Marked By App": "#007A87", "Session Rating(in%)": "#ffb400", "Total Session to be Marked": "#00d1c1"}, "left_margin": "auto", "line_interpolation": "linear", "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_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, "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": "auto", "y_axis_bounds": [null, null], "y_axis_format": ",.1%", "y_axis_label": "", "y_axis_showminmax": false, "y_log_scale": false, "remote_id": 411, "datasource_name": "sessionratingdata", "schema": null, "database_name": "app_and_channel_analytics_db", "import_time": 1584701568}
|
