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 [email protected].
To unsubscribe, please send an email to: 
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to