Question

Count if on Text metrics

  • 20 October 2023
  • 2 replies
  • 407 views

Userlevel 2
Badge +2

Hi folks,

The following query is about generating a Metric with data type dimension “Employee”

The metric is counting how many items of a Text metric 1 are in another Text Metric 2.

I use the following formula:

If ( Text Metric 1 = Text Metric 2, “Employee”) [REMOVE Lastnonblank: Month, 'Employee']

My problem is that I have no results when I should have.

 

Thanks in advance!!

New Metric -

Type Dimension (Employee)

Text Metric 1 Text Metric 2
Cost Center Cost Center  
Entity Entity  
TBH Request TBH Request  
Version Version Version
    Month
    Employee

2 replies

Userlevel 6
Badge +12

Hi Guillermo,

Since your text Metric 1 and text Metric 2 are not aligned except for the Version dimension there is no way - in my opinion - this could work.

 

Additionnally, this is not the best way to count cells based on a condition.

 

Could you maybe share more about what you’re trying to count? or the outcome you’re trying to achieve?

 

Thanks

 

Userlevel 6
Badge +12

Hi Guillermo,

 

Have you found a solution maybe?

Does this situation require more assistance?

 

Best,

Reply