Last Modified Date: 20 Jul 2023
Environment
- Tableau Cloud
- Tableau Server 10.5+
Resolution
Follow one of the options outlined below:Option 1
Use 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 2
Convert 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 3
Create 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.
Cause
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].
Additional Information
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials