I have an issue when trying to create averages for my calculated columns.
Basically i have a calculated column in my attribute view which generates the seconds between two time stamps.
In my calc. view i wish to get an average of the time differences, so i have created a counter to give me a count of all my jobs, but how do i sum this counter as its only aggregation behavior is "formula"?
JOB# Recd time Acptd time ArrvlTime TimeTo Accept TimeToArrive Counter
1 09:30 09:35 10:00 300 (secs) 1500 1
2 11:15 11:25 11:45 600 1200 1
So i need to be able to get an average for all "TimeToAccept" and "TimeToArrive".
Ideally i would like to perform all my calculations in HANA for performance. Is this possible?
Many Thanks in advance,