GitHub user dosubot[bot] added a comment to the discussion: Drill by functionality not keeping the selected value
<!-- Answer --> The issue with multiple columns and null values happens because Superset treats each appearance of "Region" (even with a custom label) as a separate groupby, which leads to duplicate columns in the query and unexpected results. This is a known limitationāusing the same physical column in both X-axis and Dimensions (or Group By) fields will cause this behavior, even if you rename one of them. The "Region column doesn't exist" error in Drill by is almost always due to a metadata sync problem: the backend dataset metadata does not match the actual table schema, so the frontend offers "Region" as an option, but the backend rejects it. Superset only syncs columns automatically when you change the dataset's SQL query; other changes (like adding metrics or editing descriptions) do not trigger a sync. To fix this, go to the dataset editor and use "Sync columns from source" or the dataset refresh endpoint to update the column list. Make sure "Region" is marked as groupable and filterable after the sync. This should resolve the Drill by error and ensure the column is recognized by both frontend and backend ([source](https://github.com/apache/superset/issues/33591), [source](https://github.com/apache/superset/blob/3256008a59d99b979bf5fd783919de451e13a60a/superset/connectors/sqla/models.py)). If you recently upgraded or changed dataset structure, a restart can sometimes help clear out stale UI state ([source](https://github.com/apache/superset/issues/31650)). Let me know if you need help with the exact steps for syncing metadata or checking your dataset config. <!-- 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/714dfb15-4f6d-4877-a54d-9affe3cd806a?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/714dfb15-4f6d-4877-a54d-9affe3cd806a?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/714dfb15-4f6d-4877-a54d-9affe3cd806a?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/714dfb15-4f6d-4877-a54d-9affe3cd806a?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/714dfb15-4f6d-4877-a54d-9affe3cd806a?feedback_type=hallucination) | [Report š](https://app.dosu.dev/response-feedback/714dfb15-4f6d-4877-a54d-9affe3cd806a?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/714dfb15-4f6d-4877-a54d-9affe3cd806a?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-13401518 ---- 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]
