Hello, im trying to create a basic report in EZBI to show feature progress within a Program Increment 10 week period of time. I was able to figure out the easy stuff to show the feature, the cumulative story points resolved and story points remaining, but i need one more data point which is story point history on a certain day. Example:
On December 14th, tell me what the story points were on this day. I wanted to start a baseline from the PI planning event that tells me on this day, the feature was planned at 100 points. And that 100 always stays static on this report
Yes, there should be a built-in measure called Story Points History (if not, go to source data settings and import the βvalue changesβ for the story points field, under the Agile section.
Then you can have this formula:
(
[measures].[story points history],
[time].[day].datemember(dateparse(β14 Dec 2020β)
)
this will give you the historical story points for specific date.