Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
The following new field seems to work:
Text(Date(Timestamp#(date,'DD/M/YY hh:mm'),'DD/MM/YYYY hh')) as DateHr
Although I think you'd lose the numeric quality with your solution, krishnamoorthy. Might be useful...