Dynamic date slicer
The new date slicer is awesome, but it would be so nice if you could set a dynamic date selection instead of a static. With a static filter the user will always have to set the dates before the saved report makes sense - especially as the report gets older.
Dynamic options could be
YTD, QTD, MTD, WTD, Today, This Year, This Quarter, This Month, This Week and so on.
sdjensen
shared this idea
12 comments
-
Ian Bennett
commented
@ previous commenter - your solution would not be helpful when querying from large datasets. Trying that against something like Azure DocumentDB with billions of documents would prove to be a slow, very expensive experience.
Date is a common way to filter large historical datasets to more manageable size. Date is a universally recognised and well defined construct and therefore a good candidate for standard functionality.
-
Anonymous
commented
This is easily achievable with custom report date attributes. For example, add a column to your date table named ReportMonth. When processing your date table always make ReportMonth equal to MonthName, except for the current month which has a value of "Current". Then save your reports with "Current" in the ReportMonth filter. Every time you refresh your report will be pointing to the current month.
You can use this same method for other types of reporting periods.
-
zootsuitryan
commented
This would be great, especially if automated report exports are rolled out.
-
Anonymous
commented
PLEASE make this happen!!
-
Dan Day
commented
This would definitely be a good addition to the slicer
-
Anonymous
commented
also TTM (Trailing Twelve Months) and similar common "trailing" periods …
-
sdjensen
commented
Perhaps it would be great if it was possible to define your own dynamic selection options?
-
nick
commented
Last Month as well please
-
Ian Bennett
commented
Amuses me that BI reports are consistently built with From and To date prompts even when the report is titled something like "xxx Monthly Report". 99.9% of the time users always put in the first of the month to the last day of the month, and run the report at 9am on the ?th day of the subsequent month.
Relative date filters make life a lot easier for everyone. I would add previous periods to the list of options.
-
Thomas Bolon
commented
I agree. Last 30 days could be also useful.
-
Anders Dahlin
commented
I agree
-
Anonymous
commented
Additionally, dynamic dates based on the data would be great too. For instance: most recent day of data