Filter a report by average of multiple answers to numerical questions
I'm trying to create an individualized report in Qualtrics where participants would receive a text description based on the averages of responses to a number of questions. For example, using a 1-7 scale on questions related to different traits, participants would see a "High" description if they averaged >= 4, or a "Low" description if they averaged < 4. When creating reports, I know there's a way to add filters based on responses to individual questions, but 1) is there a way to filter based on averages to multiple questions, and 2) is there a way to create individualized reports in Qualtrics. If not, is there another language that would be easier to do this in?