Hi, hoping to get help figuring this out.
- I have 5 categories, 5 columns for each category (A,B,C,D,E).
- I have a form (from the same table as 5 category columns table) with 42 Y/N questions. Each question scores a 1 if answered Y for the category it belongs to. I have this part working well, but don’t have to go with this method if there’s a better option.
What I’m try to achieve: After a user answers all 42 questions, I would like to know which three categories scored the highest and I then want to take that result to a filtered view based on the result (another table with a description of the 5 categories).