Hi,
I have a metric “ Partner status” with 3 dimensions: Client, version and Month
The data type of metric is a dimension named“ Status”
Status= “Active, inactive, onboarding,onboarding stuck”
Based on this metric I would like to count the number of value of each status by month in an other metric.
Thanks for your help
Best answer by Issam Moalla
View original
+9
Hi
In order to achieve this I would use the BY → combined with COUNT aggregator.
So let us consider a similar metric with the dimensions: Client, Month
In order to map it to the Status count per month the formula would be:
'Partner Status'[BY COUNT: Client -> 'Partner Status']where I add Client before the arrow to remove the dimension from the target metric.
The result metric would be the following:
Hope this helps,
Issam
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.