topic How to calculate Average Minimum Time ? in App Development https://community.qlik.com/t5/App-Development/How-to-calculate-Average-Minimum-Time/m-p/124091#M8624 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hello,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Here is my problem, I have a table as follow:</P><P></P><TABLE border="1" class="jiveBorder" height="249" style="border: 1px solid #000000; width: 746px; height: 211px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sale Man</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Time</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">10.8.18</TD><TD style="padding: 2px;">8:10 AM</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">11.8.18</TD><TD style="padding: 2px;">8:25 AM</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">12.8.18</TD><TD style="padding: 2px;">8:11 AM</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10.8.18</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">9:11 AM</SPAN></TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">11.8.18</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">8:21 AM</SPAN></TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">12.8.18</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">8:17 AM</SPAN></TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10.8.18</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">8:41 AM</SPAN></TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">11.8.18</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">8:33 AM</SPAN></TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">12.8.18</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">8:19 AM</SPAN></TD></TR></TBODY></TABLE><P></P><P>I need to calculate in KPI Chart: the Average Minimum time for a day or Average Minimum time for Salesman.</P><P></P><P>My expected outcome is like below:</P><UL><LI>Avg min time for 10.8.18 = 8:40 AM</LI><LI>Avg Min time for sale man A = 8:15 AM</LI></UL></BODY></HTML> Thu, 13 Sep 2018 08:22:49 GMT aungkyawnyein 2018-09-13T08:22:49Z How to calculate Average Minimum Time ? https://community.qlik.com/t5/App-Development/How-to-calculate-Average-Minimum-Time/m-p/124091#M8624 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hello,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Here is my problem, I have a table as follow:</P><P></P><TABLE border="1" class="jiveBorder" height="249" style="border: 1px solid #000000; width: 746px; height: 211px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sale Man</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Time</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">10.8.18</TD><TD style="padding: 2px;">8:10 AM</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">11.8.18</TD><TD style="padding: 2px;">8:25 AM</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">12.8.18</TD><TD style="padding: 2px;">8:11 AM</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10.8.18</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">9:11 AM</SPAN></TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">11.8.18</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">8:21 AM</SPAN></TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">12.8.18</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">8:17 AM</SPAN></TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10.8.18</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">8:41 AM</SPAN></TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">11.8.18</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">8:33 AM</SPAN></TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">12.8.18</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">8:19 AM</SPAN></TD></TR></TBODY></TABLE><P></P><P>I need to calculate in KPI Chart: the Average Minimum time for a day or Average Minimum time for Salesman.</P><P></P><P>My expected outcome is like below:</P><UL><LI>Avg min time for 10.8.18 = 8:40 AM</LI><LI>Avg Min time for sale man A = 8:15 AM</LI></UL></BODY></HTML> Thu, 13 Sep 2018 08:22:49 GMT https://community.qlik.com/t5/App-Development/How-to-calculate-Average-Minimum-Time/m-p/124091#M8624 aungkyawnyein 2018-09-13T08:22:49Z