How to create a filter to capture the end of month

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

Tagged:

Comments

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🔴

    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.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"