I have a data field named “timeinterval” containing seconds. I’ve created a calculated field to convert these seconds into “HH:MM:SS” format. However, the calculated field is currently in string format instead of integer, making it non-aggregatable. My goal is to find the total time in “HH:MM:SS” fo…

Hello @WLS-D , kindly check out the following link: [image] Display Time in Seconds to HH:MM:SS Question & Answer Hello everyone, I wanted to share a solution I found for converting seconds to HH:MM:SS in Amazon QuickSight. When using the formula provided by the QuickSigh…

Hey @teja1 , sadly I don’t think what you plan is possible. There is no appropriate datatype and that concat with ‘,’ disqualifies it as an int. You best bet would be to calculate with the seconds from the timeinterval column and change that result into your ‘HH:mm:SS’ format. BR Robert

Hi @robert.eibers , Thank you for your time. I implemented the suggestions you provided, and while it is working fine, the results are not exactly what I was hoping for.

Hello @teja1 and @robert.eibers ! @teja1 are you still running into this problem or is @robert.eibers suggestion serving as a good workaround? Can you break down more what you mean by the solution is not what you were hoping for?

Hi @WLS-D , thank you for reaching out. I’ve managed to resolve the issue and figured out how to make the time (HH:MM:SS) aggregatable. I appreciate your concern!

Hey @teja1 , thank you for getting back to me! Could you share how you were able to do that to help the community?

Display Time in HH:MM:SS from Time in Seconds in quicksight

Q&A

teja1 February 27, 2024, 9:31pm 7

Hello @WLS-D, kindly check out the following link:

Topic		Replies	Views
Display Time in Seconds to HH:MM:SS Q&A formatting , date , quick-sight , calculations , visual , Business-Intelligence-Engineer	3	1321	January 20, 2025
How can we convert time duration format from HH:MM:SS to SS Q&A formatting , quick-sight , Business-Intelligence-Engineer	15	1416	January 12, 2024
To convert time in milliseconds to MM:SS format Q&A analysis , quick-sight , visuals , calculations , Business-Intelligence-Engineer	9	765	September 26, 2024
Convert time duration to HH:MM:SS Technical Articles date , duration , calculations	1	5015	November 24, 2023
Seconds (string) to "HH:mm:ss" time convertion Q&A formatting , quick-sight	2	1030	February 21, 2023

Display Time in HH:MM:SS from Time in Seconds in quicksight

Related topics