How to hide some issueTypes?

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

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:

    [Issue Type].[Issue Type].Members,
    {[Issue Type].[Story]}

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