Re: [D] Feature Request: Add last business day option to time range filter [superset]

["bt-88 (via GitHub)" <gi...@apache.org>]

GitHub user bt-88 added a comment to the discussion: Feature Request: Add last business day option to time range filter

You can use a custom SQL expression in your time filter. It also works in the 'Advanced' filter.

For my MaraDb queries, I use an expression like this.

sql```
measured_at > IF(DAYOFWEEK(CURDATE()) = 2, DATE_SUB(CURDATE(), INTERVAL 3 DAY),IF(DAYOFWEEK(CURDATE()) = 1, DATE_SUB(CURDATE(), INTERVAL 2 DAY),DATE_SUB(CURDATE(), INTERVAL 1 DAY)))
```

GitHub link: https://github.com/apache/superset/discussions/22427#discussioncomment-13047283

----
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