Bug Report: Editable dataset always sorting as text

Options
crunis
crunis Registered Posts: 5

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

Answers

  • Miguel Angel
    Miguel Angel Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 118 Dataiker
    Options

    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.

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,702 Neuron
    Options

    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.

  • crunis
    crunis Registered Posts: 5
    Options

    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?

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,702 Neuron
    Options

    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.

Setup Info
    Tags
      Help me…