GitHub user dosubot[bot] added a comment to the discussion: Drill by functionality not keeping the selected value
<!-- Answer --> To check how your chart is configured for groupby and filters in Superset, open the chart in Explore mode and look at the "Data" or "Query" section in the control panel. Here, you should see controls for "Group By" (or "Dimensions") and "Filters" (or "Adhoc Filters"). Make sure your "Region" column appears in the "Group By" field and that any filters you expect are listed under "Filters" or "Adhoc Filters". Only columns marked as groupable in your dataset will show up in "Group By", and only filterable columns will show up in "Filters"—these are controlled by your dataset settings. If you want to see exactly what is being sent, you can use your browser's network inspector to look at the chart's API request payload (look for the "form_data" object). This will show you the current groupby and filter configuration being used for the query. Superset manages these controls using shared components like `dndGroupByControl` for groupby and `dndAdhocFilterControl` for filters, which filter available columns based on their groupby/filterable properties in the dataset. The backend then uses these fields to build the query and apply filters as defined in the chart's configuration. For more details, you can check the relevant control panel code and schema definitions ([example](https://github.com/apache/superset/blob/3256008a59d99b979bf5fd783919de451e13a60a/superset-frontend/src/explore/controlPanels/sections.tsx), [shared controls](https://github.com/apache/superset/blob/3256008a59d99b979bf5fd783919de451e13a60a/superset-frontend/packages/superset-ui-chart-controls/src/shared-controls/dndControls.tsx), [schemas](https://github.com/apache/superset/blob/3256008a59d99b979bf5fd783919de451e13a60a/superset/charts/schemas.py)). If your "Drill by" still isn't applying the expected filter, double-check that the column is both groupable and filterable in the dataset, and that the chart's form data reflects the expected groupby and filter values. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/5d011306-b20c-4ead-ad87-99eed7b205e3?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/5d011306-b20c-4ead-ad87-99eed7b205e3?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/5d011306-b20c-4ead-ad87-99eed7b205e3?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/5d011306-b20c-4ead-ad87-99eed7b205e3?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/5d011306-b20c-4ead-ad87-99eed7b205e3?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/5d011306-b20c-4ead-ad87-99eed7b205e3?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/5d011306-b20c-4ead-ad87-99eed7b205e3?feedback_type=other)</sup> [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/discussions/33718) GitHub link: https://github.com/apache/superset/discussions/33718#discussioncomment-13399420 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
