So here I have example of orders and each order has to be prepared in a process. That will be documented with a starttime and a finishtime. For calculating the duration which is the subtraction of Finishtime - Starttime in the format of minutes and seconds, I use the interval()-funcion:
Now I need a additional column and kpi-window which showes me the avg duration time of the ordernumbers that I want to select.
The following function gives me as expected the sum of durationtime of the selected orders properly:
So I when I need the average time of all selected orders I would expect the following to work: