KNOWLEDGE BASE

Range of Values Filter Does Not Show New Data After Refresh


Published: 18 Apr 2013
Last Modified Date: 05 Sep 2018

Issue

When the data is refreshed, the Range of Dates or Range of Values slider does not expand to include the new 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

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 dummy values in the data set for future dates or the expected largest/smallest measure value.

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

Option 3:

Use Non-null values in the filter. When this special value is selected, then the range of dates or range of values filtered will bring in new dates or values 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
  4. Open the filter options from filter in the view (click drop down)
  5. Select 'Only Relevant Values'
  6. Reopen options and select Customize > Show Null Controls
  7. Select 'Non-Null Values Only' from new option on filter
Note: The end values of the range will only update if the drop down says "Non-Null Values Only". Once the range of the filter has been changed, the drop down will default to "Values in Range" and it will be necessary to change the drop down back to "Non-Null Values Only" before saving the workbook. Steps 6-7 allow a way in the interface for the user to quickly change the filter back to "Non-Null Values Only"
 

    Cause

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