Hi Hans,
Unfortunately, there is no easy or out of box solution how to achieve something similar. If you are loading your data every day, it might be best to set the schedule email to some time of the day when you’re certain that the data-load has already finished.
If that option isn’t suitable for you, there is also a possibility to create a KPI widget (key performance indicator) which would be showing MAX (last) date of you current data.
The problem is, that in that case you would be able to use only a PDF export as this would be a visualisation which is not exportable via xlxs or csv.
In case you would like to go that way, there is another thing which should be considered. As our documentation explains, any result of date arithmetic is a number:
https://help.gooddata.com/doc/enterprise/en/dashboards-and-insights/maql-analytical-q[…]d-tutorials/finding-min-and-max-dates-using-date-arithmetic/.
In order to display the result number as a date format, you would need to use the below hack to convert it into `yyyy-mm-dd`:
SELECT MAX ((SELECT (10000 * MAX(Year (Date))) + (100 * MAX(Month (Date))) + (MAX(Day of Month (Date))) BY <connection point>))
WHERE (SELECT COUNT(Date (Date), <connection point>) BY Year (Date), ALL OTHER) > 0
(see the section
Identifying the First (earliest) Date)