Allow Dynamic, Rolling Between Date Filtering in Charts

Idea:

Allow either the 'between' date range filter for charts to also allow selection of 'X months ago' to '2 months ago' (see second screenshot for current version), or have the 'Last' filter allow an "Exclude" last 'X" months option. (see first screenshot below)

Problem:

Needing to do date centered visualizations with some form of a cure period (Ex: I want to show the last year of data by month, but exclude the last 3 months. )

Currently you can only do that by :


1. Create a dynamic beast mode for every cure date use case using datediff from current date, and then use that to filter out the last 'x' months of data, and set the date range to the timeframe desired outside of that filter range. (Ex: Filter the chart to 1 year, but create a beast mode that assigns something as 'Less than 3 Months old' and '3+ Months Old", and then filter out data less that 3 months old)


2. select a fixed date range using between, requiring it to be manually updated if I want to have the up to date date after the cure period has passed:

2
2 votes