cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LDE Frequent Visitor
Frequent Visitor

Count 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 !