Saturday, June 25, 2016

Adding Data Refresh Time Stamp to a View in a Dashboard

Published: 25 Jan 2013
Last Modified Date: 09 Sep 2014
Question
How to add a time of the last data refresh (a time stamp) to a view in a dashboard.
Environment
Tableau Desktop
Answer
Option 1: Add the time stamp to the top of the view
  1. Open the workbook that contains the dashboard in Tableau Desktop, and then navigate to the sheet for which you want to display the time of the last data refresh.
  2. Select Worksheet > Show Title.
  3. Double-click the title.
  4. In the Edit Title dialog box, select Insert > Data Update Time, and then click OK.
Option 2: Add the time stamp to the bottom of the view
  1. Open the workbook that contains the dashboard in Tableau Desktop, and then navigate to the sheet for which you want to display the time of the last data refresh.
  2. Select Worksheet > Show Caption.
  3. Double-click the caption.
  4. In the Edit Caption dialog box, select Insert > Data Update Time, and then click OK.
Additional Information
The Data Update Time value depends on the type of connection:

  • Extract-based connections display the last time the extract was refreshed.
  • Live database connections display the last time the data source was refreshed.
  • Live file-based connections display the last time the file was updated.

1 comment: