I have a database that has information about the producer, the quantity he produced and the exact time he produced this piece, I also have this same column but formatted as a decimal number, I would like to do some calculation so I can know how much each of the producers produces per minute, per hour and day, but when making this average, the idle time of each minute would have to be taken into account, otherwise the average would be lower than it should be. Maybe if there was a value of 0 for each minute, as an extra count.

I tried to make formulas like average or averageX but they don’t give me the correct number, I also created a dimension table with all the hours, minutes and seconds of the day to relate to my table but I still haven’t been successful in getting the average calculation to work