No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Mechanical Engineer dabbling in software
- Interests
- anything outdoors
- PC Specs
- windows 7
Hi, I am currently creating 'Routines' to speed up the analysis of the quiz data my database stores. One of the queries I have been using which I would like to turn into a Routine looks like this. SELECT Candidate, QuizName, PercentageScore, PassFail FROM Results WHERE Candidate ='Joe Bloggs' This … |
|
I am using MySQL to plot data about a quiz into graphs for analysis reasons. I have created a series of queries (with the help of the members of this forum!) I am now saving them as routines so I can call them for efficiency. For some reason with a … |
|
I am running analyses on a quiz and am trying to manipulate querys in order to produce bar charts. I am trying to display a graph which shows the percentages of candidates passing a particular quiz. The query I am trying to run is as follows: SELECT QuizName, (100*(COUNT(PassFail))/(COUNT(XXXXXX))) AS … |
|
Hi, I have been using MySQL to analyze quiz results. I have created a series of queries which yield particular graphs which help me in my analysis. For some reason, unknown to me, when I turn these queries into a 'Routine' the option to 'display chart' is taken away in … |
|
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' FROM resultsets GROUP BY PercentageScore I than want to take the IndividualScores and use them again in this Query. SELECT PercentageScore,CONCAT(100*(IndividualFrequency/32),"%") AS … |
|
Hi, I am a complete novice with MySQL but have been persevering with it for a project I am doing at work. I have created a results server to analyse and collect data I receive from quizzes I have created using QuestionWriter HTML5. I have figured out how to run … |