Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
Want to sort Weekday in a given chart should be driven by Today() function:
For example:
If Today() is Wednesday the Chart "Week Day" Dimension should start with 'Thu', 'Fri', and so on.
If Today() is Thursday the chart "Week Day" Dimension should start with 'Fri', 'Sat', and so on.
Thanks in advance.
try like this:
Load *, Mod(Nr -(Day(Today(1))+2),7)+1 as Test;
TEST:
LOAD * Inline [
Day, Nr
Mon, 1
Tue, 2
Wed, 3
Thu, 4
Fri, 5
Sat, 6
Sun, 7
];
and then use "Test" for sorting.
hope this helps
try like this:
Load *, Mod(Nr -(Day(Today(1))+2),7)+1 as Test;
TEST:
LOAD * Inline [
Day, Nr
Mon, 1
Tue, 2
Wed, 3
Thu, 4
Fri, 5
Sat, 6
Sun, 7
];
and then use "Test" for sorting.
hope this helps
Thanks Frank. Worked pretty well.