sorting in a different order

[antonrus]

Hello! Please help to solve one problem. I have a table of revenue on weekdays. It displays the days of the week in order, starting from Monday. And should that be showed with the environment, ie sort in a different order, such as not allowing it (sorry, do not speak in English)

[tresesco]

Take a straight table-> Sort tab-> Allow interactive sort

[antonrus]

Yes, this has put a tick. But now sort random string? When I try to drag them - they just do not want me to impose a filter on the day of the week.

[kangaroomac]

Hiya,

Or if you want your table sorted in a specefic way, i.e. Ascending (small to big),

• Right Click the table
• Properties
• Go to the Sort Tab

[kangaroomac]

Try sorting it on Load Order

and in your script, load the field with the dates as:

..

ORDER BY myDate ASC;

This way it will load days in ascending order, and with load order chosen in your Sort tab, should give you the days of the week in the desired order.

[tresesco]

You mean, users would define their won sort order? No, that won't be possible that way. Iteractive sort only allows asc or desc sort. If you want a specific order which is predefined, you can do that in an expression of sort tab.

[antonrus]

Thank you. But now I have shows in the following order: Monday; Tuesday; Wednesday; Thuesday; Friday; Saturday; Sunday

And that should be started with the environment:

Wednesday; Thuesday; Friday; Saturday; Sunday; Monday; Tuesday

[tresesco · Accepted solution]

In the expression of sort tab, try something like:

Match(YourWeekField, 'Wednesday','Thuesday', 'Friday', 'Saturday', 'Sunday', 'Monday', 'Tuesday')

Or,

Dual(YourWeekField, Match(YourWeekField, 'Wednesday','Thuesday', 'Friday', 'Saturday', 'Sunday', 'Monday', 'Tuesday'))

[kangaroomac]

Load an inline table, with something like:

* INLINE [
    Sort_Day, WeekDay
         1, 3

         2, 4
         3, 5
         4, 6
         5, 7
         6, 1
         7, 2
];

and link it to your loaded field, with the date field having something like

...

WeekDay(myDate) AS WeekDay

and in your front-end sort by Sort_Day Ascending.

[antonrus]

Hooray! It works! Thank you and all who responded to my question!

(Two weeks of work - but because of this problem, the whole project was in jeopardy, but you saved it)