Hi Alteryx Community!
Creating a workflow with a data from different YouTube channels, I met a problem with converting videos durations; In the data extract from YouTube (sample attached), I have a column "Film length (minutes)" which contains data about film lenght where for example 7 minutes and 30 seconds is given as: 7.50.
Therefore, I have two questions:
1. How to convert this data, to be displayed as hh:mm:ss
2. Is it possible to sum the durations of all videos from one channel or channels category keeping the hh:mm:ss format?
I was able to do first conversion preparing dashboard in Tableau but it was working only on the deepest level of one video. When I was rollig up the data to channel or a category level the subtotals was counted rounding to 100 instead of 60 (so sum of the durations of two movies with the same duration of 7:45 was displayed as 14:90 instead of 15:30).
I was looking for solution at the Community, I found some similar topics about converting time but none of them was reated to durations where after conversion it's also needed to be able to do some operations like summing or subtraction.
I will be grateful for any suggestions how to solve this cases.
Thanks,
Sebastian
Solved! Go to Solution.
Thank you for the advices, it was very helpful for me. Now I know how to solve the problem :)
Cheers!