topic Re: Add to filter in Visualization and Usability

Add to filter

soniasweety — Wed, 30 Aug 2017 09:02:38 GMT

Can you look into this?

antoniotiman — Wed, 30 Aug 2017 09:06:31 GMT

Hi,

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

Regards,

Antonio

antoniotiman — Wed, 30 Aug 2017 09:46:20 GMT

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

soniasweety — Wed, 30 Aug 2017 09:51:10 GMT

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

antoniotiman — Wed, 30 Aug 2017 10:16:56 GMT

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 — Wed, 30 Aug 2017 10:34:55 GMT

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 — Wed, 30 Aug 2017 10:42:38 GMT

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' ?