Project or Request

Questions & Answers
1

Hi,

I want to create a measure where if the Issue Type is “Epic” and there’s a “Parent Link”, it will say that it’s a project. Or else, it would be a request.

image
image938×112 3.57 KB

Parent Link is a dimension.

Can someone assist me ?

Thank you

2

Hi @Karim_Momo ,
You can create a custom measure in your Measure dimension using this formula:

CASE WHEN
  [Measures].[Issue type] = "Epic"
  THEN
    CASE WHEN
      NOT IsEmpty([Measures].[Issue Parent Link])
    THEN
      'Project'
    ELSE
    'Request'
    END
END

best,
Gerda // support@eazybi.com