I have a generated master calendar over a date range. On different graphs I want to show different date ranges. I attempted to restrict the dimension with an If statement but in doing so no data is displayed. For example I tried this for the dimension:
If(start_of_week < project1_end_date, start_of_week)
For a particular graph only want to show the date (i.e. start_of_week) if it is less than the project1's end date. Any ideas on how to accomplish this?