7.3+ Enhancement Request: Allow MAX(value) to be an option for query defined values filters
We have quite a number of reports that show data based on a date driven snapshot. In other words, we have agg tables that have a snapshot of a number of statistics for each customer for each date (hundreds of thousands of records daily). Ideally, we would want to only bother to allow the last x days of the data in the table to be seen by end user, ordered by most recent to oldest based on a filter. We were unable to achieve this desire in 7.2, and unable to achieve it in 7.3+. We have suggested it as an enhancement in the past. Our desire would be to have an option for the "first" item in the list (which would be the max(date)) to be default selected even if the filter is a query defining the filter values.