5 Replies Latest reply: Aug 16, 2013 5:03 PM by Celambarasan Adhimulam RSS

    Calculating a percentage

      Hi,

       

      I’m attempting to display the percentage of processing time for various jobs.  I initially created a straight table chart with the following:

       

      Dimensions:

      Effective Date

      Job Group

       

      Expression

      Sum([Duration In Minutes])

       

      Relative is checked.

       

      I have about 25 job groups.  The problem is that when I select a few job groups instead of displaying all job groups my expression displays numbers that increase so that the total is 100%.  That’s not accurate.

       

      What I need is for the correct percentages to be displayed whether displaying all the job groups or only looking at a few.

       

      Any help would be greatly appreciated.