I need to perform a process to calculate the total sum of duration of the video recording.
But when using the Groupby node, the sum option does not appear in the “Type-Based Aggregation” tab. I noticed that my Duration field format is correct (time). How can I add this range?
Site (Localidade)
Month (Mês)
Duration (“duração”, sum of hour recorded)
I noticed that my Duration field format is correct (time). How can I add this range?
The format of that column is time, not a duration. Aggregating a clock position doesn’t really make sense.
For your task, you’ll need to extract the relevant hours/minutes/seconds using the Extract Date&Time Fields node and then do the math with a GroupBy node (or other node).