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

Now Jirasupport is MrAddon!

Good morning Jira addicts! 🙂 It’s an enormous pleasure for me to present my new company based on Barcelona, called MrAddon. In this company, we will provide IT solutions based in the main Atlassian components and services like JIRA, Confluence, Bitbucket, HipChat, Crowd,etc. and the most famous JIRA plugins like Tempo Timesheets,  Adaptavist ScriptRunner, Moresimp…

Read More

Obtaining Confluence metrics & SQL tricks

MySQL query to get the last login of all members of the confluence-users group SELECT distinct u.lower_user_name, l.successdate FROM cwd_user u LEFT JOIN logininfo l ON u.user_name = l.username JOIN cwd_membership m ON u.id = m.child_user_id JOIN cwd_group g ON m.parent_id = g.id JOIN spacepermissions sp ON g.group_name = sp.permgroupname WHERE permtype=’USECONFLUENCE’ order by u.lower_user_name; …

Read More