KNOWLEDGE BASE

Range of Dates Filter Does Not Show New Data After Extract Refresh


Published: 18 Apr 2013
Last Modified Date: 13 Nov 2017

Issue

When the extract refreshes, the Range of Dates slider does not expand to the new day's data. For example, if your workbook includes data from 1/1/13 to 1/20/13, and you refresh the extract on 1/22/13, the date slider remains fixed at 1/20/13.

Environment

  • Tableau Desktop
  • Tableau Server
  • Extracts

Resolution

To resolve this issue, use one of the following workarounds:

Option 1:

Use a relative date filter. For more information, see Quick Start: Relative Dates in Tableau Help.

Option 2:

Include future dates in your data.

When future dates are included in the data, Range of dates filter will show those dates, even if they don't have values associated with them. Then, as the data is added for those dates, the filter will automatically pick up the data for those dates.

Option 3:

Use Non-null dates in the date filter. When this special value is selected, then the range of dates filtered will bring in new dates when the underlying data is updated

1. Right-click the filter on the Filters shelf and select Edit Filter…

2. In the Filter dialog, click the Special tab

3. For Special, select Non-null dates and click OK

Cause

The Range of dates filter is designed to leave the dates at the last date selected when the workbook is reopened regardless of changes in the underlying data.
Did this article resolve the issue?