Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
How to create differnce bar chart
siraj_farooq
<p>i want to make a bar chart which shows difference between results of two quizes..i am attching a screenshot i want to make such bar chart...........but file uploading problem...any one tell me what is this??????????/</p>
Find more posts tagged with
Comments
micajblock
<p>No screenshot. Use more reply options to upload a file.</p>
siraj_farooq
<p>yes i did use it but max file sixe is 28 kb.....i dont now why....</p>
micajblock
<p>Why not create a computed column which is one result minus the other and then use that in the bar chart?</p>
siraj_farooq
<p>i think of that but cant figure it out what query to be written as both of quizes are in same field....what expression should i built to delete quiz 2 from quiz 3</p>
micajblock
<p>Here is some pseudo SQL code.</p><p> </p><p>select student, sum(case when quiz = 1 then quizresult1 else 0 end), sum(case when quiz = 2 then quizresult1 else 0 end)</p><p>from quizzes</p><p>group by student</p>
siraj_farooq
<p>thanks</p>