ObservabilityTeam opened a new issue, #30582: URL: https://github.com/apache/superset/issues/30582
### Bug description Hi everyone, I have found a bug regarding adhoc_filters_b for mixed time series chart. Following are the details. Please let me know if you require more information. **Description:** The bug occurs when you have a mixed time series chart inside a dashboard and the time range filter from the dashboard does not apply to both queries of the mixed time series chart. **Reproduction:** 1. Create a dashboard. 2. From the dashboard, create a mixed time series chart using the cleaned_sales_data example dataset. 3. Name the chart what you want. 4. Add order_date to x axis. Max(sales) for Query A metric and Avg(sales) for Query B metric. Also add a filter for dealsize with all the options to both queries. 5. Save the chart and go back to the dashboard. 6. Create a time range filter in the dashboard. I used last 30 years as default value since the data is old. 7. Go to edit chart from the dashboard. 8. Change time grain and save the chart. 9. Go back to the dashboard and view the query on the chart. 10. The second query will not have the time range filter from the dashboard i.e. no order_date filter in the WHERE clause. **Expected behavior** The time range filter from the dashboard should apply to both queries of the mixed time series chart. Here is the pull request for the fix. **PR:** https://github.com/apache/superset/pull/30581 ### Screenshots/recordings <img width="1407" alt="image" src="https://github.com/user-attachments/assets/931c7733-4d5f-405a-872a-e0d54f6eb7b6";> ### Superset version master / latest-dev ### Python version 3.10 ### Node version 18 or greater ### 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. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
