Forum Discussion
arc14
2 years agoNew Member
Filter All Visuals to Previous Business Day
I have a table called dataload_tracking_xto_added with a column called date_released (each row in this table has a date_released value). I would like to add a "yesterday" button and when the user cli...
lbendlin
Super User
2 years ago"Yesterday" and "previous business day" can be very different things. The safest approach is to mark your business days (excluding weekends and holidays) in your calendar table, and then employ the "Penultimate" pattern (prefeably via the new window functions).