Hello,
I would like to create a metric that count the number of deals per month depending on the dimension below.
In order to do so we should use “ ID prm client and “date of first contract signature” from the below dimension.
How can i do that ?
Thanks for your help.
Best answer by Benoit
View original
+11
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
1[BY: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 ?
+11
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 ?
+11
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
+12
Hi,
The easiest way in my opinion is:
TIMEDIM('PRM Company ID'.date,Month)So your dimension should look like this
'PRM Company ID'.Name [by count:'PRM Company ID'.Month]
Hope it helps.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.