How to group by Project Components with JIRA and EazyBI

To group all components which match a name, for example “Arte”, we can define a new calculated member in dimension “Project” using function Aggregate(). Aggregate({ Filter( [Project].Members, [Project].[Component].CurrenthierarchyMember.Name MATCHES “(?i)arte”) }) In the screenshot example, we can see a lot of components from all projects called “Arte” or “arte”, to know the Estimated time by…

Read More

How to calculate “Lead Time” or “Real Average Resolution Days” with EazyBI and JIRA

The default calculated measure of EazyBI “Average Resolution Days” counts until the last Resolution filled ( not until the first value of the Resolution field), then if you set a new Resolution from “Resolved” to “Close” statuses, the value will be measured until “Close”. EazyBI counts the resolution time till the last resolution. This is…

Read More

Two tricks to improve the performance and security of your Jira Server 7.4

There are two tricks to improve the performance and the security of a large Jira Server 7.4 For the first “trick“, we can develop a little Jira plugin, or we can set a “Script Fragment” with the plugin Adaptavist Groovy Scriptrunner. The purpose of the improvement is to avoid problematic JQL queries. In Jira, by default,…

Read More