Bug Report: Editable dataset always sorting as text

crunis
Level 2
Bug Report: Editable dataset always sorting as text

I think Ive found a bug on how the editable dataset sorts integer columns:

 
 

Screenshot 2024-02-27 125147.png

Im trying to sort descending and its doing alphabetically, which is not desired.


Operating system used: MacOS and Windows

0 Kudos
4 Replies
MiguelangelC
Dataiker

Hi,

If you go to the explore view after saving the dataset, what meaning does the data have? In my case I have 'integer', and the data gets sorted as expected:

int.PNG

In the case where the meaning is 'text' I get the behaviour you mention.

If you are doing the sorting on the Edit tab, this is expected as the schema has not been applied to the data yet and everything is a string.

 

0 Kudos

I agree with Miguel, this works fine if you Explore the dataset. In the Edit tab it's all a piece of text so it's final if sorted alphabetically. 

0 Kudos
crunis
Level 2
Author

In my opinion, is inconvenient and slightly confusing since the Edit tab already displays "int" type so I am expecting to be able to sort integers.

But I understand what you say, feel free to close the bug or should I?

0 Kudos
Turribeach

I don't think this is a bug since it's behaving as designed. You may argue that it's inconvenient and slightly confusing but given the solution is to use the Explore tab it might be one of those where it's best to move on as there is an easy workaround.

0 Kudos