Hello, I have a table that display the id of an it...
# gooddata-platform
t
Hello, I have a table that display the id of an item. I would like to sort it from the lowest to higher number. The problem is that Goodddata consider it is an attribute, so a varchar, and it does not order it in the right way (see screenshot). All the numbers starting with 1 will be together, then all the numbers starting with 2, etc... Is there a way to fix that ?
j
Hi Thibault, Data Types for attribute labels can be defined as Text, Integer, Large Integer. More information can be found here: https://help.gooddata.com/pages/viewpage.action?pageId=86795696 So I would suggest add a numeric label to the attribute in the Logical Data Model (LDM) and use it for sorting. This ensures proper numerical order.
👍 1
t
Great ! I will try that