Time Spent Report with cumulative time spent day by day

Questions & Answers
,
1

This is my hierarchy in advanced roadmap:-

  • Feature
  • User Story
  • Task etc.

I need a day by day report to see:-
% of Cumulative sum of time spent (meaning time spent yesterday + today) / Prelim Estimations - a static value defined at the feature level.

I tried the formulae below, but it’s just giving me the Time Spent today / Prelim Estimation.

CASE WHEN
[Measures].[Prelim Total] > 0
THEN
– annotations.disable_drill=true
CumulativeSum([Measures].[Time Spent [days]]]) /
[Measures].[Prelim Total]
END

2

Try this formula for calculated measure if you use “Time” as page filter (and select weeks) and as days in columns.

 -- annotations.disable_drill=true
CASE WHEN
  [Measures].[Prelim Total] > 0
THEN
Aggregate({
  [Time].CurrentHierarchyMember.parent.children.item(0):
  [Time].CurrentHierarchyMember
},
[Measures].[Time Spent [days]]]
)
   / 
  [Measures].[Prelim Total]
END

Martins / eazyBI support

p.s. we usually do not recommend using [ ] characters in measure names as that might conflict with some formulas and functions.