Hi, In order to be able to display the graph I want I have to run two queries. The first query looks like this.
SELECT PercentageScore,COUNT(*) AS 'IndividualFrequency'
GROUP BY PercentageScore
I than want to take the IndividualScores and use them again in this Query.
SELECT PercentageScore,CONCAT(100*(IndividualFrequency/32),"%") AS 'PercentageFrequency'
GROUP BY PercentageScores.
I am confident this will result in me getting a table with the percentage of people achieving the scores and the scores. Something like this.
I know the percentagescores will look like that as there is only 5 questions. Please could anyone explain to me how I save the 'individualfrequency' to use again!?