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!
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.