How to extract an Excel report from Tempo Timesheets using an URL

It’s very easy! Just use an URL like this: https://yourserver.yourdomain/plugins/servlet/tempo-getWorklog/?dateFrom=2019-01-01&dateTo=2019-01-31&format=excel&diffOnly=false&tempoApiToken=my-token (here the documentation of the Servlet) remember to set the dateFrom, dateTo params The ApiToken you can find it in the Apps section of Jira, on Tempo “Access Control” option  

Read More

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