I am looking to add a data refresh date and time to my dashboard. I understand how to add this to the title of a worksheet. This would work if I was using an extract.
In my current situation, I am using a published data source that is derived via a Tableau Prep Flow. As I understand best practices, one should not extract a published data source. So my data source is live. Therefore, anytime you access the dashboard the date and time is updated to the current date/time not the time the data is refreshed which is currently 3am each morning.
Any ideas or suggestions on a solution?
Thanks in advance!
Scott
@Scott Carman I believe to get the data extract time you might want to pull information from one of the postgres data base repository tables of Tableau server. So here is what I will do.
1) Query your postgres table (_background_tasks)
select max(completed_at) as Last_Refresh_Date from public._background_tasks
where job_name like 'Refresh Extracts'
AND title = 'Yourdatasourcenamehere'
So connect to this postgres from your workbook as a new data source and do a custom sql. Once you have this in your workbook you can use this Last_Refresh_Date anywhere in the views.
Check and let us know if this is what you are looking for.
