Getting Month Start Date from Month Year
I have a dashboard with a presentation variable of Month Year called my_pv and want to filter by Month Start Date based on the selected Month Year.
I have explored the use of session variables but couldn't get there with that approach since I cannot reference a presentation variable within a session variable.
I have tried using lookup(), but it only returns an error.
I am sure you must have figured it by now. Posting these videos for the folks who may need to do something similar:
Filter by first business day of the month - part 1
This video shows how to filter by date = first business day of the month (does not use lookup function)
Filter by first business day of the month - part 2
This video shows how to filter by date >= first business day of the month (use lookup function)