5 Replies Latest reply: Jul 5, 2012 4:56 AM by Kiran Rokkam RSS

    Labels / Percentage Errors

      Hey all,

      So basically I've created a the following pie chart with the code within the expressions section (each being a seperate expression)

       

      Good       =count({<Q2LastYearScore = {1}, Year = {2011}>} responseid)/ count({<Year = {2011}>} Q2LastYearScore)

      Same      =count({<Q2LastYearScore = {2}, Year = {2011}>} responseid)/ count({<Year = {2011}>} Q2LastYearScore)

      Worse     =count({<Q2LastYearScore = {3}, Year = {2011}>} responseid)/ count({<Year = {2011}>} Q2LastYearScore)

       

      and the result i get is :

      Screenshot_1.png

      It shows all the percentages for each section, why is this and how can i change it so it only shows the correct percentage for each section?