Count if on a text value

  • 12 January 2024
  • 1 reply

Userlevel 2
Badge +5


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 12 January 2024, 13:04

View original

1 reply

Userlevel 5
Badge +9

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,