5 Replies Latest reply: Jan 29, 2015 8:24 AM by Dermot mcgoldrick RSS

    Stumped By Average Expression?

    Dermot mcgoldrick

      OK I have the following Expression :


      =Avg({< CURR_STATUS = {'CLOSED'} >}  AGEDAYS )


      To show the average age of closed tickets in a chart.  AGEDAYS is Today() - Closedate, but the chart is showing the average as 54Hrs,  and if background table extracted into Excel and the average hours checked the figure is correct, 7.8 Hrs.


      What am I missing here?