1 Reply Latest reply on Mar 30, 2015 9:55 AM by asim cholas

    How a can get the sum of the average calculation in analytics




      in the analysis I have two columns, the task and the average time of the task (the average of the task it's a messure calculated on rpd avg(task_time)). So the analysis looks like:


      task.     Average time

      t1.          10

      t2.           15

      t3.          20

      grand.   12



      the grand total it's the average of all the records but what I need is the grand total be the sum all average time (10+15+20 = 45) .


      how I can do the above ???