Hi Cedric,

Firstly, create a new property call Contract Signature Month of data type Month.
use the TIMEDIM() function to get the Month match with the date you have.

Then you can use the Playground and see it can be as easy as doing

11BY:PRM Company ID.Contract Signature Month]

However I’d suggest you also create another property in that dimension to count the contracts and maybe account for mapping issues, blank rows etc

Thanks for your answer.
I struggle a bit with the item formula, how the formula will look like ? 

sorry I’m wrong it is actually TIMEDIM function | Community (gopigment.com)

Thanks.

In the formula” 1�BY:PRM Company ID.Contract Signature Month] “ the 1 is referring to which metric ? 

It is not a metric, just a counter, doing a BY will create a metric of value one by that dimension you put in the BY

Hi, 

The easiest way in my opinion is:

• Create a new property in your dimension to convert your date into Month
  Property name = Month, type = dimension = Month
  Formula is TIMEDIM('PRM Company ID'.date,Month)

So your dimension should look like this

• Create the metric structured by Month
  the formula would be

'PRM Company ID'.Name mby count:'PRM Company ID'.Month]

Hope it helps.