topic FirstSortedValue with an if statement or set analysis in App Development

FirstSortedValue with an if statement or set analysis

Anonymous — Fri, 27 Oct 2017 13:25:16 GMT

I have an expression which correctly calculates the survey location with the highest average score (see below). Some of the survey locations have very small volumes of feedback and these are often the highest/lowest ranking locations. Is there a way of using an if statement or set analysis to remove those locations from the calculation. Any survey location with less than 10 items of feedback shouldn't be considered. Each completed survey has a feedback_id and volumes are calculated by doing a count of these unique feedback id's

=FirstSortedValue(distinct SurveyLocation, -aggr(avg(Score),SurveyLocation))

Thanks

Re: FirstSortedValue with an if statement or set analysis

sunny_talwar — Fri, 27 Oct 2017 15:43:42 GMT

May be this

=FirstSortedValue(DISTINCT {<SurveyLocation = {"=Count(Score) >= 10"}>} SurveyLocation, -Aggr(Avg({<SurveyLocation = {"=Count(Score) >= 10"}>} Score), SurveyLocation))

Re: FirstSortedValue with an if statement or set analysis

Anonymous — Mon, 30 Oct 2017 08:48:19 GMT

Thanks Sunny. Works perfectly.