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

    Averaging within a time period



      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 .



        • Averaging within a time period

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




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


          month(DateField) as Month



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