Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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'))
Take a straight table-> Sort tab-> Allow interactive sort
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.
Hiya,
Or if you want your table sorted in a specefic way, i.e. Ascending (small to big),
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.
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.
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
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'))
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.
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)