Complete dynamic date filter

Hi,


I am currently working on a marketing dashboard, where the business user will be able to dynamically aggregate the data daily, weekly and monthly.

I have also added a filter that compares the current timeframe with the previous one such as:
current date vs previous
current week vs previous
current month vs previous

My problem is that when the aggregation is on week or month, the current data might not be complete. 
for example if today is Wednesday then  at the aggregation my report will compare the previous week with this week until wednesday.


I would like to create a yesno filter that filters on full week/month/quarter.

Could someone tell how could I achieve this?

Thanks in advance!

1 2 3,532
2 REPLIES 2
Top Labels in this Space
Top Solution Authors