8 Replies Latest reply: Jul 28, 2016 7:57 AM by anthony delmeire RSS

    island Calendar and expressions

    anthony delmeire

      Hi,

       

      I have this model

      model.PNG

      and I want a table per MonthYear with :

      - the number of new cases : count({$<[Date - Open case]={">=$(=min(Date))<=$(=max(Date))"}>} distinct [Case number])

      - the number of close cases : count({$<[Date - Close case]={">=$(=min(Date))<=$(=max(Date))"}>} distinct [Case number])

      - the number of still open cases : count({$<[Date - Open case]={"<=$(=max(Date))"}, [Date - Close case]={">=$(=max(Date))"}>} distinct [Case number])

       

      I don't understand my mistake because these expressions doesn't work as I which. I would like the result per month and I have the total of the year each month

      resultat.PNG

       

      Thanks for your help