1 Reply Latest reply: Nov 2, 2009 8:51 PM by FHoeglund RSS

    Averaging within a time period

    jking1975

      Hello

      Simple query , I have a € value which is captured daiily on each business day of the month, I want to average that number for each month rather than ovver the entire data range . Any Ideas .

       

      Thanks

        • Averaging within a time period

          Use month as dimension in your graph/table. Then it should give you your average per month.

           


          =avg(EUROAMT)


           

          If you don't have month as dimension just create it with

           


          month(DateField) as Month


          or

           


          year(DateField) & '-' &month(DateField) as YearMonth


           

          /F