topic Set analysis - excluded issue in App Development

Set analysis - excluded issue

Mon, 04 Apr 2016 08:43:40 GMT

Hi all,

I'm fairly new to set analysis.

I am trying to calculate all references where it took less than 30 days, ignoring the selection in the filter.

I have created an expression using set analysis but it doesn't return the correct values. ie.

COUNT({$<Reviewer=>} if([Days Taken] < 30,1,0)), instead it returns all of the References for a Reviewer.

For AF it should be a total of 21 references which took less than 30 days - < 30 days taken.

25 is the total, which it is returning instead.

Furthermore, I want the to ignore the Reviewer selected in the filter, so that is shows all Reviewers.

I've attached a sample .qvf to see how I'm calculating this.

Many thanks!

Any tips would be appreciated.

kaushiknsolanki — Mon, 04 Apr 2016 12:40:38 GMT

Hi,

Use this expression.

COUNT({<Reviewer = , [Days Taken] = {"<30"}>} Reference)

Regards,

Kaushik Solanki

sunny_talwar — Mon, 04 Apr 2016 13:09:44 GMT

I prefer Kaushik Solanki‌ solution, but if you want to stick with if condition, you need a Sum, instead of count:

Sum({$<Reviewer=>} if([Days Taken] < 30,1,0))

Because Count of 0 and 1 are end up being the total. or you can try this:

Count({$<Reviewer=>} if([Days Taken] < 30,1))

Chanty4u — Tue, 05 Apr 2016 05:58:06 GMT

chk dis