Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Date Task
30/1/2015 A
31/1/2015 B
1/2/2015 C
2/2/2015 D
3/2/2015 E
Expected result should exclude the saturday and sunday date.
Date Task
30/1/2015 A
2/2/2015 D
3/2/2015 E
Kindly help. Thanks.
You could try calculated dimension like:
If( Not Match( WeekDay(Date), 'Sat', 'Sun'), Date)
Then enable supress when value is null in the dimensions tab.
In a table or chart you want to get this out put let me know.
Regards
Aannd
Set DayNames = 'Monday;Tuesday;Wednesday;..'
Load * Where Not Match(Weekday(Date),'Saturday','Sunday'));
Load Date#(Date,'DD/MM/YYYY') As Date,Task Inline [
Date,Task
30/1/2015,A
31/1/2015,B
1/2/2015,C
2/2/2015,D
3/2/2015,E
];
in dimension try like this:
If( WeekDay(Date)<> 'Sat' or WeekDay(Date)<>'Sun', Date)
and then suppress null in the dimension
Hi,
In front end you can try this way
Dim:- Date
Expre:- =If( Not Match( WeekDay(Date), 'Sat', 'Sun'), Only(Task))
Regards
Anand
Hi,
With date as dimension, in your expression add
Only(if(num(WeekDay(Date)) < 5,Task))
Regards
Kamiel