Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have table like below
unique_id | subjects name | time taken to complete |
---|---|---|
23 | advertise subject | 0:10:30 |
23 | modern tech subject | 0:1:22.111 |
23 | astrologael subject | 0:0:16.481 |
23 | computer subject | 00:00:00.0 |
i want output like below
unique_id | time taken to complete |
---|---|
23 | 0:1:68.592 |
Here i want to aggregate time taken by unique_id.
How could i do this?
May be like this
Time(Sum(TimeTakenToComplete), 'h:mm:ss:fff')
here i understand that you want to aggregate time column by Unique_id, but i dont understand
by which formula you are getting " 0:1:68.592".
Sum(Time(TimeTakenToComplete,'h:mm:ss:fff')
Hi sunny,
Thanks. That worked.
For aggregation by unique_id :
Aggr(Time(Sum(TimeTakenToComplete), 'h:mm:ss'),unique_id)