How to create a filter to capture the end of month

WorldWarHulk

Hello Domo community -

Good Day!

Basically, we want to capture the data from the previous month on the current week.

for example, the start of the week is 8/28 and the end of the week is 9/3.

we want to capture all data up to 8/31 only. and then data for 9/1 to 9/3

using the start date 8/28 or end date 9/3.

Thanks

jaeW_at_Onyx

build a date dimension where you have one row for each day of the year. then assign the week_of_year to each date. then it'll be easier to make these comparisons.

"build a date dimension" in SQL is a google-able term, so you should be able to implement that using MySQL dataflows.