topic Re: if statement to reduce dimensions in App Development

if statement to reduce dimensions

Anonymous — Mon, 18 Dec 2017 12:07:03 GMT

I have an expression which calculates a % of coverage. I would like to limit the dimensions to where the coverage is 10% or more. The dimension is 'Insight' and the following is the expression for coverage (which i know works)

=count(if(isnull(Category) and ExcludeWord<>'Yes' and not(isnull(Topic)),Topic))/(sum(if(not(isnull(Category)),TopicFlag))+count(if(isnull(Category) and ExcludeWord<>'Yes' and not(isnull(Topic)),Topic)))

adding the expression into the if statement doesnt seem to be working

if(count(if(isnull(Category) and ExcludeWord<>'Yes' and not(isnull(Topic)),Topic))/(sum(if(not(isnull(Category)),TopicFlag))+count(if(isnull(Category) and ExcludeWord<>'Yes' and not(isnull(Topic)),Topic)))>0.1, Insight)

Re: if statement to reduce dimensions

YoussefBelloum — Mon, 18 Dec 2017 12:50:30 GMT

Hi,

what type of objects are you using to dispay the reduced dimensions?

Re: if statement to reduce dimensions

Anonymous — Mon, 18 Dec 2017 12:53:51 GMT

Just a bar chart

Re: if statement to reduce dimensions

YoussefBelloum — Mon, 18 Dec 2017 13:07:38 GMT

you can simply add the condition on the expression. did you try it ?

Re: if statement to reduce dimensions

sunny_talwar — Mon, 18 Dec 2017 13:17:05 GMT

May be try this

Aggr(if(count(if(isnull(Category) and ExcludeWord<>'Yes' and not(isnull(Topic)),Topic))/(sum(if(not(isnull(Category)),TopicFlag))+count(if(isnull(Category) and ExcludeWord<>'Yes' and not(isnull(Topic)),Topic)))>0.1, Insight), Insight)