EazyBI - Calculated member for hours spent on specific set of Issue Keys


I how do i create a calculated member which sums all hours spent on specific Issue Key or a group of Issue Keys 



1 answer

You can create a Calculated member: 

[Measures].[Hours spent]


you can have other filters or calculated members that can filter down.   do you have example of a report?   

Hi, I am wondering how I cam sum hours on a monthly basis (with fixed start date Aug 01 2018 to Aug 30 2018) as a calculated member in eazyBI?


Thanks in advance

The best way is using Time month selection on Pages. However, if you do not want to use Pages selection and would like to address a particular Time member in a calculation, you can use tuples.


Here is an example, how to address August'2018 in a tuple:

([Measures].[Hours spent],
[Time].[Month].DateMember('01 AUG 2018'))

The tuple above will retrieve you hours spent for August (Aug 01 2018 to Aug 30 2018)

You can address periods more dynamically as well. Here is an example of how to retrieve hours spent of previous month:

([Measures].[Hours spent],


Daina / support@eazybi.com

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Feb 07, 2019 in Marketplace Apps

A Timeless Love Story

It started as any story starts, on a normal, rainy day.   Admin meets App, and her name was Klok2, and like any first relationship we were both trying to make it work but neither one knew what...

442 views 8 26
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you