Add to filter

[soniasweety]

Hi

Antonio Mancini

Can you look into this?   

[antoniotiman]

Hi,

I'm sorry,I am not authorized to access the Link.

Regards,

Antonio

[antoniotiman]

Why Rows 16 and 18 must have shown since duration is less than 5 ?

[soniasweety]

yes ,that day logic shpuld apply to particular taskname =9day only  rest all show and it doesn't depends on day nd duration

[antoniotiman]

Try this for Dimension Name

=If(Name='9day',If(Match(Num(WeekDay(TimeStamp#(Opendate,'YYYY-MM-DD hh:mm:ss'))),1,2,3,7),Name),Name)

Uncheck Include Null Values

[soniasweety]

Hi,

its not working still its showing the data  duration below 5days  .

it should show above 5days of task duration  for this particular taskname

[antoniotiman]

In Your App I see Dimension

=if(match(Assignedgroup,'A','B') and [Duration(in Days)]>=limit, ID)

and this filters itself Duration >= 5 since limit is 5.

However You add condition in my above Dimension like this

=If(Name='9day',If(Match(Num(WeekDay(TimeStamp#(Opendate,'YYYY-MM-DD hh:mm:ss'))),1,2,3,7) and [Duration(inDays)] >= 5,Name),Name)

Have You unchecked 'Include Null Values' ?