Solved

Count if on a text value

  • 12 January 2024
  • 1 reply
  • 202 views

Userlevel 2
Badge +3

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

 



 

icon

Best answer by Issam Moalla 12 January 2024, 13:04

View original

1 reply

Userlevel 4
Badge +5

Hi @Cedric LJ ,

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

Reply