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?