need help with group

[Anonymous]

Hi all

Need your help.

my data looks like this :

date                   chlid        child download

14/7/12 14:00        a                    123

14/7/12 14:00        b                    166

14/7/12 14:15        a                    173

14/7/12 14:15        b                    176

14/7/12 14:30        a                    153

14/7/12 14:30        b                    156

14/7/12 14:45        a                    143

14/7/12 14:45        b                    146

14/7/12 15:00        a                    123

14/7/12 15:00        b                    166

14/7/12 15:15        a                    173

14/7/12 15:15        b                    176

14/7/12 15:30        a                    153

14/7/12 15:30        b                    156

14/7/12 15:45        a                    143

14/7/12 15:45        b                    146

i need to know the avg download per HOUR for each child 

for example

14/7/12 14:00        a                    148

14/7/12 14:00        b                    161

thx

[Jason_Michaelides]

I'd probably create a new field in the script:

TimeStamp(Floor(date) + (1/24*Hour(Date)))     AS     DateHourStart

Then, use this and child as the dimensions in your chart, with Avg([child download]) as the expression.

Hope this helps,

Jason

[nagaiank]

The following new field seems to work:

Text(Date(Timestamp#(date,'DD/M/YY hh:mm'),'DD/MM/YYYY hh')) as DateHr

[Jason_Michaelides]

Although I think you'd lose the numeric quality with your solution, krishnamoorthy. Might be useful...