KNOWLEDGE BASE

Incorrect Data Displayed on View After using Date Range Slider


Published: 31 May 2019
Last Modified Date: 02 Oct 2020

Issue

When using a slider on a range date filter in Tableau Destop and Tableau Server, the data does not reflect the correct information. 

Environment

  • Tableau Server
  • Tableau Desktop

Resolution

Option 1
Upgrade to Tableau Server 2018.1.14, 2018.2.11, 2018.3.8, 2019.1.5, 2019.2.1 or later.

Option 2
As a temporary workaround, create a calculation filed using the MAKETIME expression to date slider filter. 
  1. Create a calculated field using a formular similar to: MAKEDATE(YEAR([Order Date]), MONTH([Order Date]), DAY([Order Date]))
  2.  Add this newly created calculation to Filter shelf and select the Range of Date option.
The above calculated field can be found in the attached sample workbook called Maketime Calculation.twbx.

Cause

This is a known issue that is fixed in the recent versions of Tableau Server.
Did this article resolve the issue?