How do I create an S Curve report?

[Graham Crowe]

I need to create an S-Curve report out of JIRA to show the project's progress over time to date. Basically, I need a graph with the horizontal axis being time (starting from the project start date, ending at the current date) and the vertical axis being % complete.

The curve would then have a point plotted for every week with the height being calculated as "total hours of work done / total hours of work estimated". Hours of work done would be based on work logged (or if no work logged for a particular task where the task is marked "done" then use the estimated time for that task).

I need to plot multiple curves (a different curve for different issue types)

Note that the projects I will run this on are populated with all JIRA tasks prior to any work starting, and are complete once all JIRA tasks are closed (this is not an ongoing support scenario)

Is it possible to generate such a report?

How would I go about doing it?

Thanks

[Abi Nubli Abadi]

A. Add three basics

Item Purpose

Issue types: Plan, Actual Hold weekly totals (nothing to do with sprints).

Custom fields • Week (Date)<br>• Points (Number, hours or story-points on every normal issue)<br>• Total Points (Number, only on Plan & Actual)

---

B. Two tiny Automation rules

Rule Trigger Action (plain-English)

Baseline – Plan When any new task/bug/etc. is created ➜ Find or create this week’s Plan issue, then add the task’s Points to its Total Points.

Progress – Actual When a task is Done (or work logged) ➜ Find or create this week’s Actual issue, then add the task’s Points (or logged hours) to its Total Points.

(Use “Lookup Issues → Branch → Edit” pattern; no apps required.)

---

C. Draw the chart

1. Install Custom Charts for Jira (free tier is fine).

2. Gadget type: Line Chart.

3. JQL: project = ABC AND issueType in (Plan, Actual).

4. X-axis = Week (bucket: Weekly).

5. Series = Issue Type (Plan, Actual).

6. Y-axis = Total Points (cumulative).

7. Turn on “Show as % of highest value” to make a 0–100 % S-curve.

[Yossi barezer]

who can answer this?

[firlian]

same question, pls anyone help.