Sort weekday with specific date last

[#1]

Hi all,

I have a problem with sorting weekday. I want to sort the days of the week with a specific day as the first day to see.

For instance if i want to show the last 7 days and today would be a wednesday i want the sort order to be like:

Weekday
tuesday
monday
sunday
saterday
friday
thursday
wednesday

this makes it easier to read a chart that shows the workload from the last 7 days.

Could anybody help me with this?

My thanks in advance for the help!

[jonathandienst]

I suggest that you post a sample with some representative data and the chart under discussion. That way we can all stop guessing....

[#3 · Accepted solution]

Thanks Tresesco, with your help i managed to fix it! Your document helpt me very much!

It works now with the following stats:

Dimension:

Weekday

Expression 1:

count({1}DISTINCT if(Date>=Date('13-03-2014')-7 and Date<Date('13-03-2014'), OrderID))

Expression 2:

num(count(OrderID) / count( distinct if(OrderID>0, Weeknumber & Year)),'#.###,##')

Sort Expression:

If(Weekdaynr<WeekDay(date('13-03-2014')+1),Weekdaynr,Weekdaynr-7)