Conditional average by group (day of the week)

[joethehoe]

HELLO ALL.

I have a 30 day report that in includes to two groups: 1 age and the other is day.

What is the proper syntax to to get an average of group 2(day)for all days of certain a day of the week within my 30 day report: such as the average dials of all the sunday group totals.

Something like:
Average ({dials},{General Information.Job Run Date})like 1 (1 being sunday.)

PH: Date Week day(number) Week day(name) Dials
GH1: AGE1
GH2: \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\GF2: 2002/12/08 1 sunday 666
GF2: 2002/12/09 2 Monday 123
GF2: 2002/12/10 3 Tuesday 123
GF2: 2002/12/11 4 Wednesday 123
GF2: 2002/12/12 5 Thursday 123
GF2: 2002/12/13 6 friday 123
GF2: 2002/12/14 7 Saturday 123
GF2: 2002/12/15 1 sunday 888
GF2: 2002/12/16 2 Monday 123
GF2: 2002/12/17 3 Tueday 123
GF1: Total Age dials 2538
GF1: Average Monday 777

FYI: I dont know if this is an issue but im using DTSToDate ({General Information.Job Run Date}) to convert the database date to a usable format.

Thanks so much
Jason