#1235: Ajout calcul de la médiane statistiques Helpdesk
-------------------------+--------------------------------------------------
Reporter: jmd | Owner: anonymous
Type: enhancement | Status: new
Priority: normal | Milestone: 0.72
Component: Helpdesk | Version: 0.71.5
Severity: feature | Resolution:
Keywords: | Cd: 2
-------------------------+--------------------------------------------------
Comment (by moyo):
peut-être avec des requêtes imbriquées comme cela :
SELECT Sales Median FROM
(SELECT a1.Name, a1.Sales, COUNT(a1.Sales) Rank
FROM Total_Sales a1, Total_Sales a2
WHERE a1.Sales < a2.Sales OR (a1.Sales=a2.Sales AND a1.Name <= a2.Name)
group by a1.Name, a1.Sales
order by a1.Sales desc) a3
WHERE Rank = (SELECT (COUNT(*)+1) DIV 2 FROM Total_Sales);
--
Ticket URL: <https://dev.indepnet.net/glpi/ticket/1235#comment:2>
GLPI <https://dev.indepnet.net/glpi/>
Gestion Libre de Parc Informatique
_______________________________________________
Glpi-bugtrack mailing list
[email protected]
https://mail.gna.org/listinfo/glpi-bugtrack
