Hello, I have been working with eazyBI for last year and have alwasy managed to find the solution to my needs and problems as the tool is amazing.
Currently I have an issue explaining my leadership how to read a 2-Week type report for our kanban teams.
I have this calculated member:
[ Time.2 Weeks ].[ Last 12 Weeks ] =
Aggregate(
[Time.2 Weeks].[2 Weeks].DateMembersBetween(‘12 weeks ago’, ‘today’)
)
Which I then formatted to the graph attached.
What the problem is, the last record in report is the active current iteration (because of the ‘today’ end date). That means this data is regularly getting updated. It becomes very hard to explain to not look at this bit as it is not final number yet. And since I have linear trends addded, these get affected by this last value and not reflect the average trend of tickets delivered :).
Is there any way of setting the member up that it would end at the last 2week iteration?
We used to run in sprints and for such it is easy to specify to include only CLOSED sprints however for continuous reports I am unable to figure out the way to look at only passed 2 weeks cycles.
Can you please assist?
