Calculo de datos / Campo calculado

Hello @agustinmoncada94, I believe I know how you would manage this. Rather than directly using the StartTime, EndTime, and last time category, you can utilize LAC-W functions to get a single value for each distinct Equipo field.

This will require 3 functions. I will show you how to get the minOver value for StartTime, maxOver value for EndTime, then we can sumOver the final time all partitioned by Equipo.

minStartTime = minOver({StartTime}, [{Equipo}], PRE_AGG)

maxEndTime = maxOver({StartTime}, [{Equipo}], PRE_AGG)

TotalTime = sumOver({TimeCategory}, [{Equipo}], PRE_AGG)

Utilizing those fields should give you the solution you are looking for! Let me know if you have any questions.