2 Replies Latest reply: Oct 30, 2017 4:48 AM by Josh Pinfold RSS

    FirstSortedValue with an if statement or set analysis

    Josh Pinfold

      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