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'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