EazyBi. How to hide some issueTypes?

[NewByatl]

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

[Sir Mārtiņš Vanags · Accepted solution]

Hi @NewByatl 

Try creating new calculated measure using this formula with Aggregate and Except functions to count Issues created from all issue types execpt stories.

Aggregate(

Except(

[Issue Type].[Issue Type].Members,

{

[Issue Type].[Story]

}),

[Measures].[Issues created]

)

Martins / eazyBI support

[NewByatl]

Nice, thx!