EazyBI - show both how much time spend during a given time-frame as well as total time spent

[Peter Bengov]

Hello,

I have the current setting: 

• Pages: Time
• Columns: Measure > Hours spent
• Rows: Issue

In the Columns I would like to show both how much time an issue had in total as well as how much time spent during the given time period (as chosen in Time dimension).

How can this be done?

[Lauma Cīrule · Accepted solution]

Hi Peter,

You can create another calculated member that shows Time spent ignoring the current Time selection with following formula 

(
  [Measures].[Hours spent],
  [Time].CurrentHierarchy.DefaultMember
)

Let me know if you have other questions!
Lauma / support@eazybi.com 

[Peter Bengov]

Thanks Lauma