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

    2795283

      Hello,

       

      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

      total

       

      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 ???

       

      thanks!