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
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.
+12Hi 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 ?
Thanks.
In the formula” 1[BY:PRM Company ID.Contract Signature Month] “ the 1 is referring to which metric ?
+12It 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
+15Hi,
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.