KNOWLEDGE BASE

Adding Data Refresh Time Stamp to a View in a Dashboard


Published: 25 Jan 2013
Last Modified Date: 02 Mar 2017

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.
  5. Save the modifications.

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.
  5. Save the modifications.

To view these steps in action, see the video below: 

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 file-based and live database connections display the last time the data source was refreshed in Tableau.
NOTE: The worksheet being used to display the data refresh time will display "Unknown Update Time" unless there is at least one dimension or measure in the view.
Did this article resolve the issue?