AVG of the last 7 days not returning results

[matthewp]

I have an expression to give me the AVG of TIMETAKEN in the last 7 days but it isn't returning any results.

=AVG({<STARTDATE={"<$(=date(today()-7))"} >}TIMETAKEN)

I can get yesterdays AVG with this and it works:

=AVG({<STARTDATE={"$(=Date(Today()-1))"}>} TIMETAKEN)

[Channa]

=AVG({$=$(=Date(Today(),-7))<$(=date(Today(),0))"}>} TIMETAKEN)

[matthewp]

That gives an error 

[Venthan · Accepted solution]

Hi,

Please try with this,

=AVG(
{<STARTDATE={"$(=Date(Today()-7))","$(=Date(Today()-6))","$(=Date(Today()-5))"
,"$(=Date(Today()-4))","$(=Date(Today()-3))","$(=Date(Today()-2))","$(=Date(Today()-1))"}>
}TIMETAKEN)

[Channa]

=AVG({$=$(=Date(Today(),-7))<$(=Date(Today(),0))"}>} TImeTakes)

[Venthan]

=AVG(
{<STARTDATE={">=$(=Date(Today()-7))<=$(=Date(Today()-1))"}>
}TIMETAKEN)

This should also provide the same result effectively.