count rows (date) by month
1 TopicCount rows with cunditions by date
Hi, I've a data base like the following, but I'd like to get the number of Request "Mode de traitement = TRAITEMENT IMMEDIAT" by month. Request | Date | Mode de traitement n°1 | 10/04/2018 10:45 | TRAITEMENT IMMEDIAT n°2 | 10/04/2018 10:45 | TRAITEMENT IMMEDIAT n°3 | 10/04/2018 10:33 | TRAITEMENT IMMEDIAT n°4 | 10/05/2018 10:06 | TRAITEMENT IMMEDIAT n°5 | 10/05/2018 09:57 | CREATION DOSSIER n°6 | 10/05/2018 09:53 | CREATION DOSSIER n°7 | 10/06/2018 09:52 | CREATION DOSSIER n°8 | 10/06/2018 09:52 | TRAITEMENT IMMEDIAT n°9 | 10/06/2018 08:27 | TRAITEMENT IMMEDIAT n°10 | 10/07/2018 08:28 | TRAITEMENT IMMEDIAT n°11 | 10/07/2018 08:29 | TRAITEMENT IMMEDIAT n°12 | 10/07/2018 08:33 | TRAITEMENT IMMEDIAT n°13 | 10/08/2018 08:46 | TRAITEMENT IMMEDIAT n°14 | 10/08/2018 09:52 | CREATION DOSSIER I tried to creat an other base with the months using the first day of each month ([Month] = 01/04/2018 ; 01/05/2018 ; ...) and adding a calculate column [#TraitementImmediatByMonth], but I didn't success. How could I get get the following result ? Month | #TraitementImmediatByMonth 01/04/2018 | 3 01/05/2018 | 1 01/06/2018 | 2 01/07/2018 | 3 01/08/2018 | 1 Thank's for your help !673Views0likes0Comments