I want to extract data for below JQL-:
project=“Market Services” and status not in (delivered, cancelled, closed) AND issuetype not in (project, build, “carry forward”, epic, “Change Request”) AND (“McDonalds Reference Number” ~ “INC*” OR “McDonalds Reference Number” ~ “RITM*”)
Please help me to create a Measure as the McDonalds Reference number can be only used as property.
Also please explain the concept on how to get count from Issue property if cannot be imported as dimension?
Thank you for reaching out here and via support email.
My colleague discuss this with you directly, and one solution indeed is MDX calculation:
[Measures].[Issues created]>0 AND
(CoalesceEmpty([Measures].[Issue McDonalds Reference number],"") MATCHES ".*INC.*" OR
CoalesceEmpty([Measures].[Issue McDonalds Reference number],"") MATCHES ".*RITM.*")
There is discussed such solution in more detail:
Training videos on specific topics