Dear Team, A customer complained that their daily ...
# gooddata-platform
h
Dear Team, A customer complained that their daily refresh of data is not available. I decided to schedule send their dashboard to myself, to verify the content. The dashboard PDF and xlxs I received on Saturday (31/08) that were scheduled at 8:30, show the date of Friday (30/08). I now understood that the data was not refreshed yet at 8:30, hence showing the date of Friday. Is that assumption correct? For clarity to our users I would like to show that refresh date on each dashboard. Something like: "Last Refreshed: Saturday 31/08 at 9:00 AM CET" Can this be achieved? Thanks, Hans
j
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`:
Copy code
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)
In any case - If you wish, please let me know and I can also submit a product feedback on your behalf so our product team can consider some possible out of the box solution.
h
I will try your suggestion above, to get the max date of a transaction. Please yes, consider an out of the box solution Maybe start with just a metric, that can be shown on screen without being restricted by the Date Filter.
1
p
🎉 New note created.