Last Modified Date: 22 Mar 2018
- Tableau Online
- Tableau Server 10.5+
ResolutionFollow one of the options outlined below:
Option 1Use a different Sort by order other than Data source order for the string field.
- Right click the field used in the view and select Sort.
- In the Sort dialog window change the Sort by order to either Alphabetic, Field, or Manual and click Apply.
Option 2Convert the string field data type into a number.
- Right clicking the field used in the view and select Change Data Type.
- Choose Number and click Apply.
Option 3Create a calculated field.
- Go to Analysis > Create Calculated Field.
- Use the Int() function to convert the string field into an integer.
- Replace the string field used in the view with the new calculated field.
The Hyper data engine does not guarantee the order stability of unordered strings. Hyper may dynamically change the sort order of unordered strings for performance reasons. For example, a broken table calculation will materialize, if the string sort order changes from [0,1,2] to [1,2,0].
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials