topic calculate average time from string type in Dashboards & Analytics Discussions

calculate average time from string type

Ruchita — Tue, 08 Aug 2023 12:52:39 GMT

Hello!

I have a dataset with certain time of completion. They were originally ij long/big int format, and dusing formatDuration() in incorta, i have transformed it to (days, hours:minutes:seconds) format. This conversion of format results in an output in the string datatype.

How can i construct a formula in incorta to get the average completion time in (days, hours:minutes:seconds) format ?

Example:

Task	Time Spent	Formatted Time Spent
1	4009573	01:06:49
2	5630253	01:33:50
3	10,103,173	02:48:23
average:-	6580999.67	01:49:41

Thanks in advance

Re: calculate average time from string type

anurag — Thu, 10 Aug 2023 13:25:57 GMT

This video may give you some idea to solve this problem:

- https://www.youtube.com/watch?v=E0HPEiRQyjc

Re: calculate average time from string type

marcpaige — Fri, 08 Sep 2023 21:32:38 GMT

@anurag I liked the technique in the video. I put a comment on it. There is a limit to int() for conversion. I ran into this with very large millisecond counts. I was successful in using long() for the conversion with formatDuration().