Have you tried using 'Latest Date' preset? Filter Data from Your Views
If your data has dates into the future, the approach above might not work as it will pick the largest date available. In that case, since you are subscribing users, maybe you could create a view that you'll only use for subscriptions. This view can use a calculated field to always default to today, something like:
[Is Today?] : [Date] = TODAY()
And you'd drop that into the filters shelf.
Hope this helps!
My report will be refreshed daily . So, everyday I will have a new date as the latest date . Will the first approach work ??
1 of 1 people found this helpful
Yes, I would expect that to work, but it's always a good idea to test it. It shouldn't be too hard for you to try it by creating a subscription for you with that option selected, you would know first thing tomorrow
The first approach worked for me . Is there a way to get the report with the previous date (yesterday's date) in a mail ??
Hmmm, good question. That dialog will only allow you to pick the latest value in the data set, so you'll need to be able to exclude today's date. A couple of things I can think of:
1. Send the subscription at the end of the day before, maybe late at night, so the last date available is actually 'yesterday' when users see the e-mail in the morning.
2. Create a calculated field that filters out today's data at the data source level and keep using the latest date preset. If you do it this way, keep in mind today's data won't show up on the live version of the dashboard: