Need to plot S-curve for Project prediction

[vrukesh]

Hi,
We want to plot EazyBI predicted trend chart for bugs in an ongoing project. This plot is needed against known milestone dates: Start Date, A Date, B Date, C Date, End Date.
We checked eazyBI demo example: Project Prediction report - Issues - Jira Demo - eazyBI

1. Need further guidance on using milestone dates to plot predicted trend
2. How to plot S-curve of predicted bug trend, since it will be S-curve, and NOT a straight line from Start date to End date, as shown in above EazyBI demo example. Mathematical equation could be like:
   Building S-Curves for projects in Excel using functions on dates and expected completion percentages - Super User
   thanks,
   Vrukesh

[janis.plume]

Hi,

The prediction calculation in this demo example is implemented based on the actual progress of the project, not considering any milestones. You can show milestones with a custom measure similar to “Today”:

CASE WHEN
DateInPeriod(DateParse('Apr 01 2022'),[Time].CurrentHierarchyMember)
THEN
  "Milestone A"
END

The S-curve prediction calculation can use the following formula:

--total scope
([Measures].[Issues created],
[Time].CurrentHierarchy.DefaultMember)

/
(1+Exp(-DateDiffDays(
DateAddDays(
  [Measures].[Project start date],
    -- "2" assume that s-curve meets the linear prediction in the middle of the project
  DateDiffDays([Measures].[Project start date],
    [Measures].[Project predicted date])/2 
),
 -- "50" is the parameter of how steep will be the curve
        [Time].CurrentHierarchyMember.StartDate)/50))

The prediction report with these formulas:

Kindly,
Janis, eazyBI support

[vrukesh]

Hi Janis,
Wishing you a very Happy New Year! Thanks for as usual quick reply!
Did try the suggested mechanism, with some tweaks.

Project Start date:
– annotations.group = Predicted by issues
DateParse(‘Jul 01 2020’)

Project End date:
– annotations.group = Predicted by issues
DateParse(‘Dec 01 2023’)

Project S-Curve:
– annotations.group = Predicted by issues
–total scope
([Measures].[Issues created],
[Time].CurrentHierarchy.DefaultMember)

/
(1+Exp(-DateDiffDays(
DateAddDays(
[Measures].[Project Start Date],
– “2” assume that s-curve meets the linear prediction in the middle of the project
DateDiffDays([Measures].[Project Start Date],
[Measures].[Project End Date])/2
),
– “50” is the parameter of how steep will be the curve
[Time].CurrentHierarchyMember.StartDate)/50))

Observations:

1. Cumulative count on x-axis is not increasing beyond today’s count.
2. Date on X-axis is not going beyond April 2023
   Any suggestions?
   Thanks,
   Vrukesh

[janis.plume]

Hi,

Nice to have you back in the New Year !

1. The cumulative is calculated from the resolved issues; it is not expected to increase in future periods. Perhaps, it makes sense to hide the cumulative for future periods to make the chart look cleaner.

2. The report uses the Time in the project filter. It uses the predicted completion date. You can adjust the formula for Time in project to consider your custom end date instead.

Kindly,
Janis, eazyBI support

[vrukesh]

Hi Janis,
Since we want to predict Cumulative Created bugs for the project, we had done relevant changes for this in “Time in Project” field.
Somehow, the predicted S-curve trend is not shown till Project End date of December 2023.
Graph looks like below:

Thanks,
Vrukesh