You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "neeagl (via GitHub)" <gi...@apache.org> on 2025/06/07 21:13:50 UTC
[D] Drill by functionality not keeping the selected value [superset]
GitHub user neeagl created a discussion: Drill by functionality not keeping the selected value
Hi all,
We recently developed a dashboard containing a bar chart with X-axis as Region and some metrics on the Y.
When we try to do "Drill by" using branch column (already marked as a dimension & filterable in data source), the chart shows up without the region filter applied (based on the bar that was clicked).
Is there something we're missing out?
Thanks
GitHub link: https://github.com/apache/superset/discussions/33718
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Drill by functionality not keeping the selected value [superset]
Posted by "neeagl (via GitHub)" <gi...@apache.org>.
GitHub user neeagl edited a discussion: Drill by functionality not keeping the selected value
Hi all,
We recently developed a dashboard containing a bar chart with X-axis as Region and some metrics on the Y.
When we try to do "Drill by" using branch column (already marked as a dimension & filterable in data source), the chart shows up without the region filter applied (based on the bar that was clicked).
When I try to do it with another dimension using pie chart - it works.
Is there something we're missing out?
Thanks
GitHub link: https://github.com/apache/superset/discussions/33718
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Drill by functionality not keeping the selected value [superset]
Posted by "neeagl (via GitHub)" <gi...@apache.org>.
GitHub user neeagl added a comment to the discussion: Drill by functionality not keeping the selected value
@dosu it is related to #25334 where the issue is bar chart is unable to use X-axis as a filter and pass it to drill by.
Is there a way to fix it?
GitHub link: https://github.com/apache/superset/discussions/33718#discussioncomment-13402178
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Drill by functionality not keeping the selected value [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
GitHub user dosubot[bot] added a comment to the discussion: Drill by functionality not keeping the selected value
<!-- Answer -->
This error happens because Superset requires all column and metric labels in a chart to be unique. If you use "Region" as both the X-Axis and a Dimension, you'll get a duplicate label conflict.
To work around this, give one of the "Region" fields a custom label. For example, when adding "Region" under "Dimensions", edit its label to something like "Region (Dim)" or any unique name. This will let you use "Region" in both places without hitting the error.
This is a known behaviorāSuperset doesn't enforce label uniqueness automatically, so it's up to you to make sure each label is unique in your chart config. Using custom labels is the standard way to resolve this in complex setups.
<!-- 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/f66a708d-849c-4599-8864-d067caab66cf?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/f66a708d-849c-4599-8864-d067caab66cf?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/f66a708d-849c-4599-8864-d067caab66cf?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/f66a708d-849c-4599-8864-d067caab66cf?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/f66a708d-849c-4599-8864-d067caab66cf?feedback_type=hallucination) | [Report š](https://app.dosu.dev/response-feedback/f66a708d-849c-4599-8864-d067caab66cf?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/f66a708d-849c-4599-8864-d067caab66cf?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-13399459
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Drill by functionality not keeping the selected value [superset]
Posted by "neeagl (via GitHub)" <gi...@apache.org>.
GitHub user neeagl added a comment to the discussion: Drill by functionality not keeping the selected value
@dosu when we give it another custom label, it groups by the same column 2 times hence resulting in multiple columns with null values.
also, the drill by still doesn't work and shows region column doesn't exist
GitHub link: https://github.com/apache/superset/discussions/33718#discussioncomment-13401474
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Drill by functionality not keeping the selected value [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
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 notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Drill by functionality not keeping the selected value [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
GitHub user dosubot[bot] edited a comment on the discussion: Drill by functionality not keeping the selected value
<!-- Answer -->
This issue often happens if the "Region" column isn't set up as a groupby-enabled column in your dataset, or if there's a mismatch in column naming between your chart and the dataset. The "Drill by" feature relies on constructing filters using the clicked value and passing them as adhoc filters in the chart's form data. If the region filter isn't being applied, double-check that:
- The "Region" column is marked as groupable in your dataset.
- The column name matches exactly between your dataset and the chart configuration.
- You're using a supported chart type for "Drill by" (not all chart types support it).
- If you recently upgraded Superset, try restarting the application, as sometimes feature flags or UI state can get stuck after an upgrade. In recent versions (4.1.1+), "Drill by" is enabled by default and doesn't require extra configurationĀ ([source](https://github.com/apache/superset/issues/31650)).
If all of the above look correct, it's worth checking if the filter is being constructed and sent in the chart's form data when you drill. If not, there may be an issue with how the chart or dataset is configured to handle groupby and filters. Let me know if you need help checking any of these details.
<!-- Dosu Comment Footer -->
*To reply, just mention [@dosu](https://go.dosu.dev/dosubot?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=reply-with-mention&utm_term=apache%2Fsuperset).*
---
Docs are dead. Just use [Dosu](https://dosu.dev?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-tagline&utm_term=apache%2Fsuperset).
[](https://app.dosu.dev/response-feedback?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-feedback&utm_term=apache%2Fsuperset&message_id=f09ab0f0-a4d2-48d4-85d2-965c59671de9) [](https://github.dosu.com/apache/superset?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-ask-repo&utm_term=apache%2Fsuperset) [](https://app.dosu.dev/signup?referrer=openSource&source=github-footer&utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-share-team&utm_term=apache%2Fsuperset)
GitHub link: https://github.com/apache/superset/discussions/33718#discussioncomment-13399410
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Drill by functionality not keeping the selected value [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
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 notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Drill by functionality not keeping the selected value [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
GitHub user dosubot[bot] edited a comment on 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?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=reply-with-mention&utm_term=apache%2Fsuperset).*
---
Share context across your team and agents. Try [Dosu](https://dosu.dev?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-tagline&utm_term=apache%2Fsuperset).
[](https://app.dosu.dev/response-feedback?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-feedback&utm_term=apache%2Fsuperset&message_id=714dfb15-4f6d-4877-a54d-9affe3cd806a) [](https://github.dosu.com/apache/superset?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-learn-repo&utm_term=apache%2Fsuperset) [](https://app.dosu.dev/signup?referrer=openSource&source=github-footer&utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-add-team&utm_term=apache%2Fsuperset)
GitHub link: https://github.com/apache/superset/discussions/33718#discussioncomment-13401518
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Drill by functionality not keeping the selected value [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
GitHub user dosubot[bot] added a comment to the discussion: Drill by functionality not keeping the selected value
<!-- Answer -->
This issue often happens if the "Region" column isn't set up as a groupby-enabled column in your dataset, or if there's a mismatch in column naming between your chart and the dataset. The "Drill by" feature relies on constructing filters using the clicked value and passing them as adhoc filters in the chart's form data. If the region filter isn't being applied, double-check that:
- The "Region" column is marked as groupable in your dataset.
- The column name matches exactly between your dataset and the chart configuration.
- You're using a supported chart type for "Drill by" (not all chart types support it).
- If you recently upgraded Superset, try restarting the application, as sometimes feature flags or UI state can get stuck after an upgrade. In recent versions (4.1.1+), "Drill by" is enabled by default and doesn't require extra configurationĀ ([source](https://github.com/apache/superset/issues/31650)).
If all of the above look correct, it's worth checking if the filter is being constructed and sent in the chart's form data when you drill. If not, there may be an issue with how the chart or dataset is configured to handle groupby and filters. Let me know if you need help checking any of these details.
<!-- 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/f09ab0f0-a4d2-48d4-85d2-965c59671de9?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/f09ab0f0-a4d2-48d4-85d2-965c59671de9?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/f09ab0f0-a4d2-48d4-85d2-965c59671de9?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/f09ab0f0-a4d2-48d4-85d2-965c59671de9?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/f09ab0f0-a4d2-48d4-85d2-965c59671de9?feedback_type=hallucination) | [Report š](https://app.dosu.dev/response-feedback/f09ab0f0-a4d2-48d4-85d2-965c59671de9?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/f09ab0f0-a4d2-48d4-85d2-965c59671de9?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-13399410
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Drill by functionality not keeping the selected value [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
GitHub user dosubot[bot] edited a comment on 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?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=reply-with-mention&utm_term=apache%2Fsuperset).*
---
Docs are dead. Just use [Dosu](https://dosu.dev?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-tagline&utm_term=apache%2Fsuperset).
[](https://app.dosu.dev/response-feedback?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-feedback&utm_term=apache%2Fsuperset&message_id=5d011306-b20c-4ead-ad87-99eed7b205e3) [](https://github.dosu.com/apache/superset?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-ask-repo&utm_term=apache%2Fsuperset) [](https://app.dosu.dev/signup?referrer=openSource&source=github-footer&utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-share-team&utm_term=apache%2Fsuperset)
GitHub link: https://github.com/apache/superset/discussions/33718#discussioncomment-13399420
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Drill by functionality not keeping the selected value [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
GitHub user dosubot[bot] edited a comment on the discussion: Drill by functionality not keeping the selected value
<!-- Answer -->
This error happens because Superset requires all column and metric labels in a chart to be unique. If you use "Region" as both the X-Axis and a Dimension, you'll get a duplicate label conflict.
To work around this, give one of the "Region" fields a custom label. For example, when adding "Region" under "Dimensions", edit its label to something like "Region (Dim)" or any unique name. This will let you use "Region" in both places without hitting the error.
This is a known behaviorāSuperset doesn't enforce label uniqueness automatically, so it's up to you to make sure each label is unique in your chart config. Using custom labels is the standard way to resolve this in complex setups.
<!-- Dosu Comment Footer -->
*To reply, just mention [@dosu](https://go.dosu.dev/dosubot?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=reply-with-mention&utm_term=apache%2Fsuperset).*
---
Docs are dead. Just use [Dosu](https://dosu.dev?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-tagline&utm_term=apache%2Fsuperset).
[](https://app.dosu.dev/response-feedback?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-feedback&utm_term=apache%2Fsuperset&message_id=f66a708d-849c-4599-8864-d067caab66cf) [](https://github.dosu.com/apache/superset?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-ask-repo&utm_term=apache%2Fsuperset) [](https://app.dosu.dev/signup?referrer=openSource&source=github-footer&utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-share-team&utm_term=apache%2Fsuperset)
GitHub link: https://github.com/apache/superset/discussions/33718#discussioncomment-13399459
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Drill by functionality not keeping the selected value [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
GitHub user dosubot[bot] added a comment to the discussion: Drill by functionality not keeping the selected value
<!-- Answer -->
There isn't a documented fix or workaround for the specific issue in #25334, but based on the code and recent updates, bar charts are designed to support "Drill by" and should pass the X-axis value as a filter when drilling. The most common cause for your symptoms is a metadata sync problemāif the backend dataset metadata doesn't match the actual table schema, the filter can't be applied correctly. Make sure to refresh your dataset metadata in Superset and confirm that "Region" is marked as groupable and filterable after the sync. This usually resolves issues where the X-axis value isn't passed as a filter during "Drill by" in bar charts. If you've already done this and the problem persists, it may be a deeper bug not yet addressed in the codebase, as the implementation appears robust and well-tested for generic cases.
If you need step-by-step help with syncing metadata or checking dataset config, let me know.
<!-- 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/f8bc6045-17a1-44a5-8b36-9ba106ff9140?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/f8bc6045-17a1-44a5-8b36-9ba106ff9140?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/f8bc6045-17a1-44a5-8b36-9ba106ff9140?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/f8bc6045-17a1-44a5-8b36-9ba106ff9140?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/f8bc6045-17a1-44a5-8b36-9ba106ff9140?feedback_type=hallucination) | [Report š](https://app.dosu.dev/response-feedback/f8bc6045-17a1-44a5-8b36-9ba106ff9140?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/f8bc6045-17a1-44a5-8b36-9ba106ff9140?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-13402193
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Drill by functionality not keeping the selected value [superset]
Posted by "neeagl (via GitHub)" <gi...@apache.org>.
GitHub user neeagl added a comment to the discussion: Drill by functionality not keeping the selected value
@dosu I'm unable to add Region under the "Dimensions" since it's already added as X-Axis.
Here's the error:
Unexpected error
Duplicate column/metric labels: "Region". Please make sure all columns and metrics have a unique label.
GitHub link: https://github.com/apache/superset/discussions/33718#discussioncomment-13399442
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Drill by functionality not keeping the selected value [superset]
Posted by "neeagl (via GitHub)" <gi...@apache.org>.
GitHub user neeagl added a comment to the discussion: Drill by functionality not keeping the selected value
@dosu all the pointers have been taken care of. how can i check on how the chart is configured to handle groupby & filters?
GitHub link: https://github.com/apache/superset/discussions/33718#discussioncomment-13399419
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Drill by functionality not keeping the selected value [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
GitHub user dosubot[bot] edited a comment on the discussion: Drill by functionality not keeping the selected value
<!-- Answer -->
There isn't a documented fix or workaround for the specific issue in #25334, but based on the code and recent updates, bar charts are designed to support "Drill by" and should pass the X-axis value as a filter when drilling. The most common cause for your symptoms is a metadata sync problemāif the backend dataset metadata doesn't match the actual table schema, the filter can't be applied correctly. Make sure to refresh your dataset metadata in Superset and confirm that "Region" is marked as groupable and filterable after the sync. This usually resolves issues where the X-axis value isn't passed as a filter during "Drill by" in bar charts. If you've already done this and the problem persists, it may be a deeper bug not yet addressed in the codebase, as the implementation appears robust and well-tested for generic cases.
If you need step-by-step help with syncing metadata or checking dataset config, let me know.
<!-- Dosu Comment Footer -->
*To reply, just mention [@dosu](https://go.dosu.dev/dosubot?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=reply-with-mention&utm_term=apache%2Fsuperset).*
---
Share context across your team and agents. Try [Dosu](https://dosu.dev?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-tagline&utm_term=apache%2Fsuperset).
[](https://app.dosu.dev/response-feedback?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-feedback&utm_term=apache%2Fsuperset&message_id=f8bc6045-17a1-44a5-8b36-9ba106ff9140) [](https://github.dosu.com/apache/superset?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-learn-repo&utm_term=apache%2Fsuperset) [](https://app.dosu.dev/signup?referrer=openSource&source=github-footer&utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-add-team&utm_term=apache%2Fsuperset)
GitHub link: https://github.com/apache/superset/discussions/33718#discussioncomment-13402193
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org