So the code you posted is looking for the data that has to do with the stop/start of the project and then comparing that against the estimated hours field contents. I don’t have the estimated hours filled in on my issues yet but i have “target start” and “target end” dates which are portfolio fields which import into eazyBI as measures and properties.
so the calculations I’m currently using are…
- Sum of issues:
– sum of all issues created
– Sum of any issues completed
The issue I’m having is this is giving me a lower than expected value for the sum I think which is causing my planned burndown line to go into the negatives.
- Planned BurnDown
–sum of issues minus
[Measures].[Sum code above] -
–sum of issues that have a target end date on that date or before that date
[Measures].[Issues with Target end]
sorry about any typos im having to transpose.
my chart looks like:
(again sorry i cant copy/paste)