Forum Discussion

Augustin's avatar
Augustin
Regular Visitor
10 years ago
Solved

Tri à la main

Bonjour,    Je vous contact car j'aimerai savoir s'il est possible de faire un tri à la main. Je m'explique, j'ai les valeurs suivantes : -très rapidement -supérieur à 5 ans  -dans les 3ans -3 à 5...
Need Help
  • waltheed's avatar
    waltheed
    10 years ago

    Hi, Augustin,

     

    My French is not that good, But I think I understand your question. Here is the answer in English.

     

    I think you need to enhance your table.

     

    Create an extra column to indicate the sort order, in some way:

    - either in the source table or view (which is the best option),

    - or in your query (add calculated column based on the text, e.g. if "très... "; 1; if ("dans..."; 2; ... etc)

    - or create this calculated column in your data model

     

    Then use that column to sort the text columns by.

waltheed's avatar
waltheed
Icon for Impactful Individual rankImpactful Individual
10 years ago

Hi, Augustin,

 

My French is not that good, But I think I understand your question. Here is the answer in English.

 

I think you need to enhance your table.

 

Create an extra column to indicate the sort order, in some way:

- either in the source table or view (which is the best option),

- or in your query (add calculated column based on the text, e.g. if "très... "; 1; if ("dans..."; 2; ... etc)

- or create this calculated column in your data model

 

Then use that column to sort the text columns by.

  • Augustin's avatar
    Augustin
    Regular Visitor
    10 years ago

    Thank you !

    I should write in English sorry...

    You totally understood my issue but I would like to see "tres rapidement" "3 à 5 ans".... and not 1 2 3...,

    Do you know if that is possible ?

     

    Sorry for the mistakes

     

    Cheers,

    Augustin

    • waltheed's avatar
      waltheed
      Icon for Impactful Individual rankImpactful Individual
      10 years ago

      Yes, you can use the text columns with "tres rapidement" and "3 à 5 ans" etc...

      But by adding the extra column, you make sure that they are sorted by the order of the numeric column.

      • apetitjean1's avatar
        apetitjean1
        New Member
        8 years ago

        Hello,

         

        I think I have the same issue. In my matrix, I want to filter the data of weeks in ascending order.
        This allows me to see the turnover achieved by week more easily.

         

        I try with the ''sort by collums'' but its not working, as you can see below.

         

        Thank you for your help !