Bug description
When we try to create a date period filter, only the default temporal column is getting filtered. We are not able to create date period filters on any other columns of our choice.
Screenshots/recordings
No response
Superset version
master / latest-dev
Python version
3.9
Node version
16
Browser
Chrome
Additional context
No response
Checklist
- [ ] I have searched Superset docs and Slack and didn't find a solution to my problem.
- [ ] I have searched the GitHub issue tracker and didn't find a similar bug report.
- [ ] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.
Comment From: dosubot[bot]
I couldn't find any existing tickets or discussions that match this issue. Based on the latest code, Superset's dashboard native filter system is designed to let you pick which temporal column a date filter applies to, and the FiltersConfigForm uses a column selector for this purpose. The code also includes logic to reset the column when the dataset changes, which could affect filter behavior if not set up as expected. Recent changelogs show ongoing improvements and support for multiple temporal filters, so the ability to filter on non-default temporal columns should be present and stable in recent versions (source, source).
If you're unable to select other date columns, double-check that your dataset has multiple temporal columns marked as such and that you're configuring the filter at the dashboard level (not just in Explore). If the UI doesn't let you pick another column, there may be a regression or a UI state issue—try reloading the dashboard or clearing the filter config and re-adding it. If the problem persists, it could be a new bug in the latest-dev branch.
To reply, just mention @dosu.
How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other 
Comment From: rusackas
I thought the temporal filter applies to all temporal columns, not just the default. We've also had requests to be able to add multiple time range filters, (e.g. one for shipped_on and one for received_on) but this has not yet been implemented. Someone like @sadpandajoe or @Vitor-Avila might be able to correct me on either count :)
Comment From: Vitor-Avila
When you create a chart, you'll see a temporal column added to the filters section (by default, it would say No filter). That's just a placeholder indicating the column that would get the dashboard filter applied to. That said, you can click on this and change the column to something else, but you can't have multiple distinct temporal filters
