I am trying to add a feature to record test scores then show these as a radar chart for an individual.
I need to record the score for each question (the answer is a number between 0-9), the date of the test and the person taking the test. So far that seem easy.
However, I want to show the scores as a radar chart and show improvement. Alas this is where I come unstuck.
How do I show the question (they're always the same questions) to create the categories in the radar chart? Which table do I record these in?
My results table includes fields for ID, name, date, Q1, Q2...Q9.