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|
|TBH Request||TBH Request|