sort weekday based on todays date

[qliklizzy]

Hi

I have a table of counts over the last 7 days, sorted mon tues wed...etc

is there a way of sorting by today onwards, So today is Thursday - start the sort on Friday

thanks

[StarinieriG]

Hi

you could try in this way

Expression:

If(weekdayn>=$(DayToday), weekdayn-$(DayToday),$(DayToday)+1+weekdayn)

you need to

1) create the variable 

DayToday = Num(Weekday(Today()))

2) create a field (or you could use the expression instead of weekdayn)

Num(WeekDay(date)) as weekdayn