KNOWLEDGE BASE

Format of Values in Filter Changes From hh:mm:ss to Integer Upon Publishing


Published: 16 Sep 2021
Last Modified Date: 20 Sep 2021

Issue

When publishing a visualization with a custom number format that changes integer of days to hh:mm:ss and a filter card for the custom formatted field, Tableau Server changes the filter format from hh:mm:ss back to a number value.

Environment

  • Tableau Server

Resolution

To resolve the issue, do the following in Tableau Desktop:
  1. Change the data type of the field to be a Date & Time field rather than a number field.
  2. Reapply the filter.
  3. Republish the visualization to Tableau Server. Tableau Server will then accept the custom hh:mm:ss format.
Did this article resolve the issue?