I am very new to Eazy Bi and trying to create a calculated measure that takes the field ‘Manager Name’ from an issue and categorises it into what VP that Manager falls under. The output I want, is for it to print the VP name as text (in a column).
This is my first pass, it gives me no errors but when I select it nothing shows. Is this the correct logic for the query?
Any pointers would be highly appreciated! Thanks.
CASE [Issue].CurrentHierarchyMember.get(‘Manager Name’)
WHEN “Manager Name” THEN “VP Name”
WHEN “Manager Name2” THEN “VP Name2”
WHEN “Manager Name3” THEN “VP Name3”