Calculs en glissement annuel : Comparaison de plusieurs périodes
Avec ce type de comparaison, tous les calculs de ratio doivent être effectués dans un dataflow.
Par année
Créez une année Beast Mode et tracez-la en tant que catégorie (axe des x dans la plupart des graphiques).
year(`datefield`)
Par trimestre
Créez un trimestre Beast Mode et tracez-le en tant que catégorie (axe des x dans la plupart des graphiques). Si la période s'étale sur plusieurs années, servez-vous de year(`datefield`) en tant que série.
Quarter(`datefield`)
Par mois
Créez un mois Beast Mode et tracez-le en tant que catégorie (axe des x dans la plupart des graphiques). Si la période s'étale sur plusieurs années, servez-vous de year(`datefield`) en tant que série.
Month(`datefield`)
Par semaine
Créez une semaine Beast Mode et tracez-la en tant que catégorie (axe des x dans la plupart des graphiques). Si la période s'étale sur plusieurs années, servez-vous de year(`datefield`) en tant que série.
WeekofYear(`datefield`)
Par jour
Créez un jour Beast Mode et tracez-le en tant que catégorie (axe des x dans la plupart des graphiques). Si la période s'étale sur plusieurs années, servez-vous de year(`datefield`) en tant que série.
DayofYear(`datefield`)
Calculs en glissement annuel avec calculs proportionnels : comparaison de deux périodes
Il est possible de remplacer ‘This year’ et ‘last year’ par un autre texte ou par des champs de montant. Des champs de montant sont nécessaires pour l'exécution des ratios.
L'avantage de l'utilisation d'une « Même série » plutôt que des « Séries multiples » est que vous pouvez consolider le code via la « Même série ». Toutefois, si vous remplacez ‘This Year’/‘Last Year’ par des colonnes de montants, il est nécessaire de les séparer.
Calculs en glissement annuel : Comparaison sur 12 mois
Séries multiples
Année en cours
Case when Year(`Datefield`) = Year(curdate()) then 'This Year' end
L'année précédente
Case when Year(`Datefield`) = Year(curdate())-1 then 'Last Year' end
Série identique
Case year(`Datefield`) when year(curdate()) then 'This Year' when year(curdate())-1 then 'Last Year’ End
Ratio : variation en pourcentage entre les deux à l'aide de la formule (C/P) -1
(Case when Year(`Datefield`) = Year(curdate()) then `Amountfield` end / Case when Year(`Datefield`) = Year(curdate())-1 then `Amountfield` end) -1
Calculs en glissement annuel : Comparaison de cumul annuel jusqu'à ce jour (YTD)
Séries multiples
Année en cours
CASE WHEN year(`Datefield`)=year(curdate()) THEN 'This Year' END
L'année précédente
CASE WHEN ((year(`Datefield`)=(year(curdate()) - 1)) AND (dayofyear(curdate()) >= dayofyear(`Datefield`))) THEN 'Last Year' END
Série identique
CASE year(`Datefield`) when year(curdate()) THEN 'This Year’ when ((year(`Datefield`)=(year(curdate()) - 1)) AND (dayofyear(curdate()) >= dayofyear(`Datefield`))) THEN 'Last Year' END
Ratio : variation en pourcentage entre les deux via la formule (C/P) -1
(CASE WHEN year(`Datefield`)=year(curdate()) THEN `Amountfield` END / CASE WHEN ((year(`Datefield`)=(year(curdate()) - 1)) AND (dayofyear(curdate()) >= dayofyear(`Datefield`))) THEN `Amountfield` END) -1
Calculs en glissement annuel : Comparaison de trimestre
Séries multiples
Année en cours
Case when (quarter(`Datefield`) = quarter(curdate()) and year(`Datefield`) = year(curdate())) then 'This Year' end
L'année précédente
Case when (quarter(`Datefield`) = quarter(curdate()) and year(`Datefield`) = year(curdate())-1) then 'Last Year' end
Série identique
Case when (Quarter(`Datefield`) = Quarter(curdate()) and year(`Datefield`) = year(curdate())) then 'This Year' when (Quarter(`Datefield`) = Quarter(curdate()) and year(`Datefield`) = year(date_sub(curdate(), interval 1 year))) then 'Last Year' End
Ratio : variation en pourcentage entre les deux à l'aide de la formule (C/P) -1
(Case when (quarter(`Datefield`) = quarter(curdate()) and year(`Datefield`) = year(curdate())) then `Amountfield` end / Case when (quarter(`Datefield`) = quarter(curdate()) and year(`Datefield`) = year(curdate())-1) then `Amountfield` end) -1
Calculs en glissement annuel : Comparaison de cumul trimestriel à ce jour (QTD)
Séries multiples
Année en cours
Case when (quarter(`Datefield`) = quarter(curdate()) and year(`Datefield`) = year(curdate()) and dayofyear(`Datefield`) <= dayofyear(curdate())) then 'This Year' end
L'année précédente
Case when (quarter(`Datefield`) = quarter(curdate()) and year(`Datefield`) = year(curdate())-1 and dayofyear(`Datefield`) <= dayofyear(curdate())) then 'Last Year' end
Série identique
Case when (Quarter(`Datefield`) = Quarter(curdate()) and year(`Datefield`) = year(curdate())) then 'This Year' when (Quarter(`Datefield`) = Quarter(curdate()) and year(`Datefield`) = year(date_sub(curdate(), interval 1 year))) then 'Last Year' End
Ratio : variation en pourcentage entre les deux à l'aide de la formule (C/P) -1
(Case when (quarter(`Datefield`) = quarter(curdate()) and year(`Datefield`) = year(curdate()) and dayofyear(`Datefield`) <= dayofyear(curdate())) then `Amountfield` end / Case when (quarter(`Datefield`) = quarter(curdate()) and year(`Datefield`) = year(curdate())-1 and dayofyear(`Datefield`) <= dayofyear(curdate())) then`Amountfield` end) -1
Calculs en glissement annuel : Comparaison mensuelle
Séries multiples
Année en cours
Case when (month(`Datefield`) = month(curdate()) and year(`Datefield`) = year(curdate())) then 'This Year' end
L'année précédente
Case when (month(`Datefield`) = month(curdate()) and year(`Datefield`) = year(curdate())-1) then 'Last Year' end
Série identique
Case when (month(`Datefield`) = month(curdate()) and year(`Datefield`) = year(curdate())) then 'This Year' when (month(`Datefield`) = month(curdate()) and year(`Datefield`) = year(date_sub(curdate(), interval 1 year))) then Last Year' End
Ratio : variation en pourcentage entre les deux à l'aide de la formule (C/P) -1
(Case when (month(`Datefield`) = month(curdate()) and year(`Datefield`) = year(curdate())) then `Amountfield` end / Case when (month(`Datefield`) = month(curdate()) and year(`Datefield`) = year(curdate())-1) then `Amountfield` end) -1
Calculs en glissement annuel : Comparaison de cumul mensuel (MTD)
Séries multiples
Année en cours
Case when (month(`Datefield`) = month(curdate()) and year(`Datefield`) = year(curdate()) and DAYOFMONTH(`Datefield`) <= DAYOFMONTH(curdate())) then 'This Year' end
L'année précédente
Case when (month(`Datefield`) = month(curdate()) and year(`Datefield`) = year(date_sub(curdate(), interval 1 year)) and DAYOFMONTH(`Datefield`) <= DAYOFMONTH(curdate())) then 'Last Year' end
Série identique
Case when (month(`Datefield`) = month(curdate()) and year(`Datefield`) = year(curdate()) and DAYOFMONTH(`Datefield`) <= DAYOFMONTH(curdate())) then 'This Year' when (month(`Datefield`) = month(curdate()) and year(`Datefield`) = year(date_sub(curdate(), interval 1 year)) and DAYOFMONTH(`Datefield`) <= DAYOFMONTH(curdate())) then Last Year' End
Ratio : variation en pourcentage entre les deux à l'aide de la formule (C/P) -1
(Case when (month(`Datefield`) = month(curdate()) and year(`Datefield`) = year(curdate()) and DAYOFMONTH(`Datefield`) <= DAYOFMONTH(curdate())) then `Amountfield` end / Case when (month(`Datefield`) = month(curdate()) and year(`Datefield`) = year(date_sub(curdate(), interval 1 year)) and DAYOFMONTH(`Datefield`) <= DAYOFMONTH(curdate())) then `Amountfield` end) -1
Calculs en glissement annuel : Comparaison hebdomadaire
Séries multiples
Année en cours
Case when (WEEKOFYEAR(`Datefield`) = WEEKOFYEAR(curdate()) and year(`Datefield`) = year(curdate())) then 'This Year’ end
L'année précédente
Case when (WEEKOFYEAR(`Datefield`) = WEEKOFYEAR(curdate()) and year(`Datefield`) = year(date_sub(curdate(), interval 1 year))) then 'Last Year' End
Série identique
Case when (WEEKOFYEAR(`Datefield`) = WEEKOFYEAR(curdate()) and year(`Datefield`) = year(curdate())) then 'This Year' when (WEEKOFYEAR(`Datefield`) = WEEKOFYEAR(curdate()) and year(`Datefield`) = year(date_sub(curdate(), interval 1 year))) then 'Last Year’ End
Ratio : variation en pourcentage entre les deux à l'aide de la formule (C/P) -1
((Case when (WEEKOFYEAR(`Datefield`) = WEEKOFYEAR(curdate()) and year(`Datefield`) = year(curdate())) then `Amountfield` end / Case when (WEEKOFYEAR(`Datefield`) = WEEKOFYEAR(curdate()) and year(`Datefield`) = year(date_sub(curdate(), interval 1 year))) then `Amountfield` End) -1
Calculs en glissement annuel : Comparaison de cumul hebdomadaire à ce jour (WTD)
Séries multiples
Année en cours
Case when (WEEKOFYEAR(`Datefield`) = WEEKOFYEAR(curdate()) and year(`Datefield`) = year(curdate()) and DAYOFWEEK(`Datefield`) <= DAYOFWEEK(curdate())) then 'This Year' end
L'année précédente
Case when (WEEKOFYEAR(`Datefield`) = WEEKOFYEAR(curdate()) and year(`Datefield`) = year(date_sub(curdate(), interval 1 year)) and DAYOFWEEK(`Datefield`) <= DAYOFWEEK(curdate())) then 'Last Year' End
Série identique
Case when (WEEKOFYEAR(`Datefield`) = WEEKOFYEAR(curdate()) and year(`Datefield`) = year(curdate()) and DAYOFWEEK(`Datefield`) <= DAYOFWEEK(curdate())) then 'This Year' when (WEEKOFYEAR(`Datefield`) = WEEKOFYEAR(curdate()) and year(`Datefield`) = year(date_sub(curdate(), interval 1 year))and DAYOFWEEK(`Datefield`) <= DAYOFWEEK(curdate())) then 'Last Year’ End
Ratio : variation en pourcentage entre les deux à l'aide de la formule (C/P) -1
((Case when (WEEKOFYEAR(`Datefield`) = WEEKOFYEAR(curdate()) and year(`Datefield`) = year(curdate()) and DAYOFWEEK(`Datefield`) <= DAYOFWEEK(curdate())) then `Amountfield` end / Case when (WEEKOFYEAR(`Datefield`) = WEEKOFYEAR(curdate()) and year(`Datefield`) = year(date_sub(curdate(), interval 1 year)) and DAYOFWEEK(`Datefield`) <= DAYOFWEEK(curdate())) then `Amountfield` End) -1
Calculs en glissement annuel : Comparaison quotidienne
Séries multiples
Année en cours
Case when (DAYOFYEAR(`Datefield`) = DAYOFYEAR(curdate()) and year(`Datefield`) = year(curdate())) then 'This Year' end
L'année précédente
Case when (DAYOFYEAR(`Datefield`) = DAYOFYEAR(curdate()) and year(`Datefield`) = year(date_sub(curdate(), interval 1 year))) then 'Last Year' End
Série identique
Case when (DAYOFYEAR(`Datefield`) = DAYOFYEAR(curdate()) and year(`Datefield`) = year(curdate())) then 'This Year' when (DAYOFYEAR(`Datefield`) = DAYOFYEAR(curdate()) and year(`Datefield`) = year(date_sub(curdate(), interval 1 year))) then 'Last Year' End
Ratio : variation en pourcentage entre les deux à l'aide de la formule (C/P) -1
(Case when (DAYOFYEAR(`Datefield`) = DAYOFYEAR(curdate()) and year(`Datefield`) = year(curdate())) then `Amountfield` end / Case when (DAYOFYEAR(`Datefield`) = DAYOFYEAR(curdate()) and year(`Datefield`) = year(date_sub(curdate(), interval 1 year))) then `Amountfield` End) -1
Calculs POP avec calculs proportionnels (Cette période par rapport à la précédente)
POP : Comparaison d'un trimestre à l'autre (QOQ)
Séries multiples
Période actuelle
CASE WHEN ((year(`Datefield`)=year(curdate())) AND (quarter(`Datefield`)=quarter(CURDATE()))) THEN `Amountfield` END
Période précédente
CASE WHEN (quarter(curdate())=1) THEN (CASE WHEN ((year(`Datefield`)=(year(curdate()) - 1)) AND (quarter(`Datefield`)=4)) THEN `Amountfield` END ) ELSE (CASE WHEN ((year(`Datefield`)=year(curdate())) AND (quarter(`Datefield`)=(quarter(CURDATE()) -1))) THEN `Amountfield` END ) END
Ratio : variation en pourcentage entre les deux à l'aide de la formule (C/P) -1
(CASE WHEN ((year(`Datefield`)=year(curdate())) AND (quarter(`Datefield`)=quarter(CURDATE()))) THEN `Amountfield` END / CASE WHEN (quarter(curdate())=1) THEN (CASE WHEN ((year(`Datefield`)=(year(curdate()) - 1)) AND (quarter(`Datefield`)=4)) THEN `Amountfield` END ) ELSE (CASE WHEN ((year(`Datefield`)=year(curdate())) AND (quarter(`Datefield`)=(quarter(CURDATE()) -1))) THEN `Amountfield` END ) END) -1
POP : Comparaison de cumul trimestriel à ce jour (QTD), d'un trimestre à l'autre (QOQ)
Séries multiples
Période actuelle
CASE WHEN ((year(`Datefield`)=year(curdate())) AND (quarter(`Datefield`)=quarter(CURDATE()))) THEN `Amountfield` END
Période précédente
MAX(CASE WHEN YEAR(curdate()) / 4 = ROUND((YEAR(curdate()) / 4),0) THEN
CASE WHEN QUARTER(curdate())=1 THEN (DAYOFYEAR(curdate()) - 1)
WHEN (QUARTER(curdate())=2) THEN (DAYOFYEAR(curdate()) - 91)
WHEN (QUARTER(curdate())=3) THEN (DAYOFYEAR(curdate()) - 182)
WHEN (QUARTER(curdate())=4) THEN (DAYOFYEAR(curdate()) - 273)
ELSE 0 END
ELSE CASE
WHEN QUARTER(curdate())=1 THEN DAYOFYEAR(curdate()) - 1
WHEN QUARTER(curdate())=2 THEN DAYOFYEAR(curdate()) - 90
WHEN QUARTER(curdate())=3 THEN DAYOFYEAR(curdate()) - 181
WHEN QUARTER(curdate())=4 THEN DAYOFYEAR(curdate()) - 272
ELSE 0 END
END) * MAX(CASE WHEN YEAR(curdate()) / 4=ROUND(YEAR(curdate()) / 4,0) THEN
CASE WHEN (QUARTER(curdate())=1) THEN 91
WHEN (QUARTER(curdate())=2) THEN 91
WHEN (QUARTER(curdate())=3) THEN 92
WHEN (QUARTER(curdate())=4) THEN 92
ELSE 0 END
ELSE CASE
WHEN (QUARTER(curdate())=1) THEN 90
WHEN (QUARTER(curdate())=2) THEN 91
WHEN (QUARTER(curdate())=3) THEN 92
WHEN (QUARTER(curdate())=4) THEN 92
ELSE 0 END
END) - MAX(CASE WHEN YEAR(curdate()) / 4=ROUND(YEAR(curdate()) / 4,0) THEN
CASE WHEN QUARTER(curdate())=1 THEN DAYOFYEAR(curdate()) - 1
WHEN QUARTER(curdate())=2 THEN DAYOFYEAR(curdate()) - 91
WHEN QUARTER(curdate())=3 THEN DAYOFYEAR(curdate()) - 182
WHEN QUARTER(curdate())=4 THEN DAYOFYEAR(curdate()) - 273
ELSE 0 END
ELSE CASE
WHEN QUARTER(curdate())=1 THEN DAYOFYEAR(curdate()) - 1
WHEN QUARTER(curdate())=2 THEN DAYOFYEAR(curdate()) - 90
WHEN QUARTER(curdate())=3 THEN DAYOFYEAR(curdate()) - 181
WHEN QUARTER(curdate())=4 THEN DAYOFYEAR(curdate()) - 272
ELSE 0 END
END) + SUM(CASE WHEN QUARTER(curdate())=QUARTER(`Datefield`) AND YEAR(`Datefield`)=YEAR(curdate()) THEN `Amountfield` ELSE 0 END) -
SUM((CASE WHEN ((QUARTER(curdate())=QUARTER(`Datefield`)) AND (YEAR(`Datefield`)=YEAR(DATE_SUB(curdate(),INTERVAL 1 QUARTER)))) THEN `Amountfield` ELSE 0 END ))) / SUM((CASE WHEN QUARTER(DATE_SUB(curdate(),INTERVAL 1 QUARTER))=QUARTER(`Datefield`) AND YEAR(`Datefield`)=YEAR(DATE_SUB(curdate(),INTERVAL 1 QUARTER)) THEN `Amountfield` ELSE 0 END ))
Ratio : variation en pourcentage entre les deux à l'aide de la formule (C/P) -1
Copiez la formule ci-dessus et insérez-la dans les deux sections précédentes pour obtenir le résultat.
POP : Comparaison mois par mois (MOM)
Séries multiples
CASE WHEN ((year(`Datefield`)=year(curdate())) AND (month(`Datefield`)=month(CURDATE()))) THEN `Amountfield` END
CASE WHEN (month(curdate())=1) THEN (CASE WHEN ((year(`Datefield`)=(year(curdate()) - 1)) AND (month(`Datefield`)=12)) THEN `Amountfield` END ) ELSE (CASE WHEN ((year(`Datefield`)=year(curdate())) AND (month(`Datefield`)=(month(CURDATE()) -1))) THEN `Amountfield` END ) END
Ratio : variation en pourcentage entre les deux à l'aide de la formule (C/P) -1
(CASE WHEN ((year(`Datefield`)=year(curdate())) AND (month(`Datefield`)=month(CURDATE()))) THEN `Amountfield` END / CASE WHEN (month(curdate())=1) THEN (CASE WHEN ((year(`Datefield`)=(year(curdate()) - 1)) AND (month(`Datefield`)=12)) THEN `Amountfield` END ) ELSE (CASE WHEN ((year(`Datefield`)=year(curdate())) AND (month(`Datefield`)=(month(CURDATE()) -1))) THEN `Amountfield` END ) END) -1
POP : Comparaison mensuelle (MTD) mois par mois (MOM)
Séries multiples
CASE WHEN ((year(`Datefield`)=year(curdate())) AND (month(`Datefield`)=month(CURDATE()))) THEN `Amountfield` END
CASE WHEN month(curdate()) = 1 THEN CASE WHEN year(`Datefield`) = year(curdate()) - 1 AND month(`Datefield`) = 12 AND DAYOFMONTH(`Datefield`) <= DAYOFMONTH(curdate()) THEN `Amountfield` END ELSE CASE WHEN year(`Datefield`) = year(curdate()) AND month(`Datefield`) = month(curdate())-1 AND DAYOFMONTH(`Datefield`) <= DAYOFMONTH(curdate()) THEN `Amountfield` END END
Ratio : variation en pourcentage entre les deux à l'aide de la formule (C/P) -1
(CASE WHEN ((year(`Datefield`)=year(curdate())) AND (month(`Datefield`)=month(CURDATE()))) THEN `Amountfield` END / CASE WHEN month(curdate()) = 1 THEN CASE WHEN year(`Datefield`) = year(curdate()) - 1 AND month(`Datefield`) = 12 AND DAYOFMONTH(`Datefield`) <= DAYOFMONTH(curdate()) THEN `Amountfield` END ELSE CASE WHEN year(`Datefield`) = year(curdate()) AND month(`Datefield`) = month(curdate())-1 AND DAYOFMONTH(`Datefield`) <= DAYOFMONTH(curdate()) THEN `Amountfield` END END) -1
POP : Comparaison semaine par semaine (WOW)
Séries multiples
CASE WHEN ((year(`Datefield`)=year(curdate())) AND (weekofyear(`Datefield`)=weekofyear(CURDATE()))) THEN `Amountfield` END
CASE WHEN (weekofyear(curdate())=1) THEN (CASE WHEN ((year(`Datefield`)=(year(curdate()) - 1)) AND (weekofyear(`Datefield`)=52)) THEN `Amountfield` END ) ELSE (CASE WHEN ((year(`Datefield`)=year(curdate())) AND (weekofyear(`Datefield`)=(weekofyear(CURDATE()) -1))) THEN `Amountfield` END ) END
Ratio : variation en pourcentage entre les deux à l'aide de la formule (C/P) -1
(CASE WHEN ((year(`Datefield`)=year(curdate())) AND (weekofyear(`Datefield`)=weekofyear(CURDATE()))) THEN `Amountfield` END / CASE WHEN (weekofyear(curdate())=1) THEN (CASE WHEN ((year(`Datefield`)=(year(curdate()) - 1)) AND (weekofyear(`Datefield`)=52)) THEN `Amountfield` END ) ELSE (CASE WHEN ((year(`Datefield`)=year(curdate())) AND (weekofyear(`Datefield`)=(weekofyear(CURDATE()) -1))) THEN `Amountfield` END ) END) -1
POP : Comparaison semaine à ce jour (WTD) semaine par semaine (WOW)
Séries multiples
CASE WHEN ((year(`Datefield`)=year(curdate())) AND (weekofyear(`Datefield`)=weekofyear(CURDATE()))) THEN `Amountfield` END
CASE WHEN weekofyear(curdate()) = 1 THEN CASE WHEN year(`Datefield`) = year(curdate()) - 1 AND weekofyear(`Datefield`) = 52 AND DAYOFWEEK(`Datefield`) <= DAYOFWEEK(curdate()) THEN `Amountfield` END ELSE CASE WHEN year(`Datefield`) = year(curdate()) AND weekofyear(`Datefield`) = weekofyear(CURDATE()) -1 AND DAYOFWEEK(`Datefield`) <= DAYOFWEEK(curdate()) THEN `Amountfield` END END
Ratio : variation en pourcentage entre les deux à l'aide de la formule (C/P) -1
(CASE WHEN ((year(`Datefield`)=year(curdate())) AND (weekofyear(`Datefield`)=weekofyear(CURDATE()))) THEN `Amountfield` END / CASE WHEN weekofyear(curdate()) = 1 THEN CASE WHEN year(`Datefield`) = year(curdate()) - 1 AND weekofyear(`Datefield`) = 52 AND DAYOFWEEK(`Datefield`) <= DAYOFWEEK(curdate()) THEN `Amountfield` END ELSE CASE WHEN year(`Datefield`) = year(curdate()) AND weekofyear(`Datefield`) = weekofyear(CURDATE()) -1 AND DAYOFWEEK(`Datefield`) <= DAYOFWEEK(curdate()) THEN `Amountfield` END END) -1
POP : Comparaison jour par jour (DOD)
Séries multiples
CASE WHEN ((year(`Datefield`)=year(curdate())) AND (dayofyear(`Datefield`)=dayofyear(CURDATE()))) THEN `Amountfield` END
CASE WHEN (dayofyear(curdate())=1) THEN (CASE WHEN ((year(`Datefield`)=(year(curdate()) - 1)) AND (dayofyear(`Datefield`)=365)) THEN `Amountfield` END ) ELSE (CASE WHEN ((year(`Datefield`)=year(curdate())) AND (dayofyear(`Datefield`)=(dayofyear(CURDATE()) -1))) THEN `Amountfield` END ) END
Ratio : variation en pourcentage entre les deux à l'aide de la formule (C/P) -1
(CASE WHEN ((year(`Datefield`)=year(curdate())) AND (dayofyear(`Datefield`)=dayofyear(CURDATE()))) THEN `Amountfield` END / CASE WHEN (dayofyear(curdate())=1) THEN (CASE WHEN ((year(`Datefield`)=(year(curdate()) - 1)) AND (dayofyear(`Datefield`)=365)) THEN `Amountfield` END ) ELSE (CASE WHEN ((year(`Datefield`)=year(curdate())) AND (dayofyear(`Datefield`)=(dayofyear(CURDATE()) -1))) THEN `Amountfield` END ) END) -1
Commentaires
0 commentaire
Vous devez vous connecter pour laisser un commentaire.