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 .
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
Retrieving data ...