Exception for certain day

[Anonymous]

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.

[tresesco]

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.

[its_anandrjs]

In a table or chart you want to get this out put let me know.

Regards

Aannd

[anbu1984]

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
];

[avinashelite]

in dimension try like this:

If(  WeekDay(Date)<> 'Sat' or WeekDay(Date)<>'Sun', Date)

and then suppress null in the dimension

[its_anandrjs]

Hi,

In front end you can try this way

Dim:- Date

Expre:- =If( Not Match( WeekDay(Date), 'Sat', 'Sun'), Only(Task))

Regards

Anand

[kamielrajaram]

Hi,

With date as dimension, in your expression add

Only(if(num(WeekDay(Date)) < 5,Task))

Regards

Kamiel