Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to calculate data which would be average for present week. how to achieve this ?
Either use Avg() function or aggregate your measure and divide by e.g. number of distinct dates in your period:
If you want to limit the data to the present week, either use a conditional function or set analysis:
=Avg( If( DateField >= Weekstart(Today()) and DateField <= Weekend(Today()), ValueField))
or
Avg({<DateField = {">=$(=Date(Weekstart(Today())))<=$(=Date(Weekend(Today())))"} >} ValueField)
See also