I want to create a view that will have multiple time bucketing options available for the end user, such as YTD, rolling 3 months, rolling 12 months, monthly, full year, etc. To make this process dynamic, so that it doesn’t have to manually be recoded as new data rolls in, I want to structure this around the global maximum date.
I’ve created a max date function but it only shows the max date for the column, not the global maximum. Is there anyway to do this?