Forum Discussion
difficulty with calculations with hours
Not sure I fully understand the ask but I would create a column that converts to decimal hours - then you can drop that on your dashboard and select average - or you can use a measure the is Calculate(Average(hora in decimal hours) - idle time). the dashboard will let you filter by person and day on the front end.
Hello, 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.
Hello, I'm having difficulties with my measurements, I have a TIME column, but this value is inserted, the exact time that the piece was produced, so each line will have a date, that issuer X made 1 volume, but I would like to know, what is the average that each transmitter produces, per day, per hour and minute. I also did a dHora, with all the hours of the day to help, but I still haven't been able to solve it.
"VolPadrao" = Quantity produced
