We discussed this in the Data Engineering office hours. We understand the the filter issue is still not fixed, but that using a Superset template might be a workaround. See T312134: Request for SQL Templating to be enabled in Superset for when templating was enabled.

See also: https://superset.apache.org/docs/installation/sql-templating/

I will not be able to try this workaround this quarter.
@Iflorez would you like to give it a try? I could assign this task to you OR we can move it to the backlog.

So, when SQL templating was enabled I played around with it to try it out. I do not recommend it as a workaround – it will be difficult to implement.

@BTullis : assigning to you. As discussed during the DE office hours - "Need to check the CHANGELOG and upgrade to 1.5.2 to see if it fixes things" , Can we try upgrading Superset ?

As mentioned by mpopov above, we (Product Analytics) don't want to try SQL templating.

Confirmed! Superset will be upgraded to v2.0. @BTullis will create a new task and DE will try to prioritize it to be done by end of Q2.
Request to DE: Please let Product-Analytics know for any testing support and communicate these changes well in advance.

Moving to Blocked until the upgrade is completed and until we confirm if this issue is fixed after the upgrade.

Correction, Superset is being upgraded to v1.5.3 T323458
I will test the date filter box and report on any issues.

Change 881510 had a related patch set uploaded (by Btullis; author: Btullis):

[operations/puppet@production] Enable dashboard native filtering in Superset

https://gerrit.wikimedia.org/r/881510

Change 881510 merged by Btullis:

[operations/puppet@production] Enable dashboard native filtering in Superset

https://gerrit.wikimedia.org/r/881510

Mentioned in SAL (#wikimedia-analytics) [2023-01-19T10:25:38Z] <btullis> enabled dashboard native filtering in superset https://gerrit.wikimedia.org/r/c/operations/puppet/+/881510 for T318299

Change 881596 had a related patch set uploaded (by Btullis; author: Btullis):

[operations/puppet@production] Enable filterbox migration tool for superset

https://gerrit.wikimedia.org/r/881596

Change 881596 merged by Btullis:

[operations/puppet@production] Enable filterbox migration tool for superset

https://gerrit.wikimedia.org/r/881596

Adding this update retrospectively. it was first mentioned in the Product-Analytics channel on Slack.

I have enabled two new features in superset ( and also in superset-next ) so I'm hoping that you will be able to try them out and provide a little feedback, please. These features are:

• dashboard native filters (This feature may actually be enabled by default in our version)
• filter box migration

I've enabled them as a way of trying to find a solution for a long-standing issue with filtering dashboards by date.

Essentially, the authors of Superset have decided to deprecate the use of the filter box on dashboards, instead replacing it with native dashboard filtering. Native filtering provides a new pane on the left-hand side of the dashboard where your filters can be defined, whereas the filterbox mechanism is actually a chart in itself, which needs to be added to the dashboard. The screenshots below are intended to illustrate this.
A tool has been created, which aims to help users migrate from filterbox to native filters. I have enabled this feature, so when a dashboard containing a filterbox is loaded, and you are an owner of that dashboard, an option to review and migrate or defer, is shown.

Hopefully this will help to address the deficiencies identified in this ticket.

Please do let me know if this is sufficient, or if you have any other queries.