I would like to add some additional lines (for predicted team velocity) into the standard Version report.
I have used own calculated measures so far, which is working quite ok, in case you only consider linear velocity. We would like to consider different velocity per Sprint due to changes of teamsize / vacation etc.
(Yes, right for agile the goal is to consider constant velocity - but in our case this is not really the case and therefore we would like to have a varibale velocity.)
Idea is now to provide an additional excel table as 2nd data source as input. So team can easily give us information about their expected velocity inside an excel file.
The excel looks like this:
First columns holds the date of each day (also visible in the version report).
2nd and 3rd column shows the number of Storypoint prediction (optimistic, pessimistic), which I want to use to draw a line A and a line B
4th column I would like to use to draw vertical lines (milestones) in the BurnUp graph showing the text as a lable.
How to I need to import this excel file as additional source file into eazyBI, so that I can use this data as additional measure or dimension in the version report?