How to hide some issueTypes?

Questions & Answers
,
1

How to create measures like “Show all issuetypes in table, but not Stories”
In JQL it looks like: issueType NOT IN (“Story”)

I wanna hide some tasks with this kind of issueType

2

Hi @Un_Defined

Welcome to the Community! :dizzy:

You can define a new calculated member in the Issue Type dimension using the Aggregate and Except functions to exclude the Story type:

Aggregate(
  Except(
    [Issue Type].[Issue Type].Members,
    {[Issue Type].[Story]}
  )
)

newmember
newmember2348×1312 334 KB

With this new member saved, you can then define a new calculated measure in the Measures dimension using a tuple that would include the necessary measure and the Issue Type member, which excludes the Story:

(
  [Measures].[Issues created],
  [Issue Type].[All Except Stories]
)

Or, you can use the Issue Type dimension in the Pages section and filter by this new member.

​Let me know if this fits your use case or if you have any additional questions on this!
​Best regards,
​Nauris / eazyBI support