topic Re: Ajuda com média in Brasil https://community.qlik.com/t5/Brasil/Ajuda-com-m%C3%A9dia/m-p/743013#M22474 <HTML><HEAD></HEAD><BODY><P>Boa tarde.</P><P></P><P>Segue exemplo.</P><P></P><P><IMG alt="2015-03-05 13_31_46-QlikView x64 - [C__Furtado_Qlik_QlikView_Demos_Community_Media Funcionarios.qvw].png" class="image-1 jive-image" src="/legacyfs/online/80033_2015-03-05 13_31_46-QlikView x64 - [C__Furtado_Qlik_QlikView_Demos_Community_Media Funcionarios.qvw].png" style="height: auto;" /></P></BODY></HTML> Thu, 05 Mar 2015 16:33:09 GMT afurtado 2015-03-05T16:33:09Z Ajuda com média https://community.qlik.com/t5/Brasil/Ajuda-com-m%C3%A9dia/m-p/743009#M22470 <HTML><HEAD></HEAD><BODY><P>Bom dia,</P><P></P><P>Estou com dificuldade de obter o numero médio de funcionários acumulado no período selecionado conforme abaixo.</P><P></P><P>Estou usando a formula: <SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;">=</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: blue;">aggr</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;">( </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: blue;">Count</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;"> (</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: blue;">DISTINCT</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: maroon;">NOME</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;">),</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: maroon;">Dia</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;">) </SPAN></P><P><SPAN style="color: black; font-family: Arial, sans-serif; font-size: 9pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="color: black; font-family: Arial, sans-serif; font-size: 9pt; line-height: 1.5em;">Gostaria de obter a média 9,5 na contagem de 10 funcionários no primeiro dia e 9 no segundo.</SPAN></P></BODY></HTML> Wed, 04 Mar 2015 13:51:13 GMT https://community.qlik.com/t5/Brasil/Ajuda-com-m%C3%A9dia/m-p/743009#M22470 2015-03-04T13:51:13Z Re: Ajuda com média https://community.qlik.com/t5/Brasil/Ajuda-com-m%C3%A9dia/m-p/743010#M22471 <HTML><HEAD></HEAD><BODY><P>Cassio, forneça uma base de dados teste e mais detalhes da sua métrica</P></BODY></HTML> Wed, 04 Mar 2015 14:24:14 GMT https://community.qlik.com/t5/Brasil/Ajuda-com-m%C3%A9dia/m-p/743010#M22471 nicolett_yuri 2015-03-04T14:24:14Z Re: Ajuda com média https://community.qlik.com/t5/Brasil/Ajuda-com-m%C3%A9dia/m-p/743011#M22472 <HTML><HEAD></HEAD><BODY><P>Estou com dificuldade de anexar dados melhores.</P><P></P><P>Ajuda esta informação?</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 110pt;" width="147"><TBODY><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="height: 12.75pt; width: 58pt;" width="77">NOME</TD><TD class="xl68" style="border-left: none; width: 26pt;" width="35">02/03</TD><TD class="xl68" style="border-left: none; width: 26pt;" width="35">03/03</TD></TR><TR style="height: 12.75pt;"><TD class="xl69" height="17" style="height: 12.75pt;">Aline R.</TD><TD align="right" class="xl70">02:04</TD><TD align="right" class="xl70" style="border-left: none;">02:32</TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="height: 12.75pt; border-top: none;">Cristiane Q.</TD><TD align="right" class="xl64" style="border-top: none;">01:43</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">02:22</TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="height: 12.75pt; border-top: none;">Diego V.</TD><TD class="xl65" style="border-top: none;"> </TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">01:11</TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="height: 12.75pt; border-top: none;">Fernando C.</TD><TD align="right" class="xl64" style="border-top: none;">00:50</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">01:03</TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="height: 12.75pt; border-top: none;">Luciano C.</TD><TD align="right" class="xl64" style="border-top: none;">02:31</TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="height: 12.75pt; border-top: none;">Luis R.</TD><TD align="right" class="xl64" style="border-top: none;">02:17</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">02:41</TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="height: 12.75pt; border-top: none;">Manoela V.</TD><TD align="right" class="xl64" style="border-top: none;">00:57</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">01:58</TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="height: 12.75pt; border-top: none;">Ricardo S.</TD><TD class="xl65" style="border-top: none;"> </TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">02:54</TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="height: 12.75pt; border-top: none;">Taischane S.</TD><TD align="right" class="xl64" style="border-top: none;">01:17</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">01:05</TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="height: 12.75pt; border-top: none;">Thamiris W.</TD><TD align="right" class="xl64" style="border-top: none;">03:49</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">03:02</TD></TR><TR style="height: 12.75pt;"><TD class="xl71" height="17" style="height: 12.75pt; border-top: none;">Vania N.</TD><TD align="right" class="xl72" style="border-top: none;">02:30</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">02:17</TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="17" style="height: 12.75pt;">Colaboradores</TD><TD align="right">9</TD><TD align="right">10</TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;"></TD><TD></TD><TD></TD></TR><TR style="height: 12.75pt;"><TD height="17" style="height: 12.75pt;">Média de colaboradores</TD><TD></TD><TD align="right">9,5</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 04 Mar 2015 14:47:57 GMT https://community.qlik.com/t5/Brasil/Ajuda-com-m%C3%A9dia/m-p/743011#M22472 2015-03-04T14:47:57Z Re: Ajuda com média https://community.qlik.com/t5/Brasil/Ajuda-com-m%C3%A9dia/m-p/743012#M22473 <HTML><HEAD></HEAD><BODY><P>if( isnull(avg(dataini-datafin)), 0, avg(dataini-datafin))</P><P>se nao tiver um das duas datas , apenas um delas coloca somente a data que possui .</P></BODY></HTML> Thu, 05 Mar 2015 14:50:10 GMT https://community.qlik.com/t5/Brasil/Ajuda-com-m%C3%A9dia/m-p/743012#M22473 2015-03-05T14:50:10Z Re: Ajuda com média https://community.qlik.com/t5/Brasil/Ajuda-com-m%C3%A9dia/m-p/743013#M22474 <HTML><HEAD></HEAD><BODY><P>Boa tarde.</P><P></P><P>Segue exemplo.</P><P></P><P><IMG alt="2015-03-05 13_31_46-QlikView x64 - [C__Furtado_Qlik_QlikView_Demos_Community_Media Funcionarios.qvw].png" class="image-1 jive-image" src="/legacyfs/online/80033_2015-03-05 13_31_46-QlikView x64 - [C__Furtado_Qlik_QlikView_Demos_Community_Media Funcionarios.qvw].png" style="height: auto;" /></P></BODY></HTML> Thu, 05 Mar 2015 16:33:09 GMT https://community.qlik.com/t5/Brasil/Ajuda-com-m%C3%A9dia/m-p/743013#M22474 afurtado 2015-03-05T16:33:09Z Re: Ajuda com média https://community.qlik.com/t5/Brasil/Ajuda-com-m%C3%A9dia/m-p/743014#M22475 <HTML><HEAD></HEAD><BODY><P>avg(aggr(count(if(Value&lt;&gt;'',Value)),Type))</P><P></P><P></P><P>aonde o Value serias as horas e o Type a data....</P><P></P><P>AMF</P></BODY></HTML> Thu, 05 Mar 2015 16:33:23 GMT https://community.qlik.com/t5/Brasil/Ajuda-com-m%C3%A9dia/m-p/743014#M22475 afurtado 2015-03-05T16:33:23Z Re: Ajuda com média https://community.qlik.com/t5/Brasil/Ajuda-com-m%C3%A9dia/m-p/743015#M22476 <HTML><HEAD></HEAD><BODY><P>valew!</P></BODY></HTML> Thu, 05 Mar 2015 17:16:32 GMT https://community.qlik.com/t5/Brasil/Ajuda-com-m%C3%A9dia/m-p/743015#M22476 2015-03-05T17:16:32Z