Having a Time Duration data type in the data management

With the present data types available in Gainsight we can't access the HH:MM: SS format of the data.

Usecase: While bringing Time duration data into S3 bucket from an external source we are mapping it as a type String because of the format. Now the usecase is to perform aggregation on the Time duration i.e AVG Time spent. 


@shivani thank you sharing the problem here. I will request the product team to check the possibilities.

Hi @shivani 


Thank you for your idea.

We have added it to our roadmap 


Thank you