Sprint Charts
Hi team,
Hope all is well for you!
Interested in understanding sprint charts/formulas to create that others are using. It would be for a 10 day sprint with 6 sprints for a PI. Perhaps, burndown, burn up, etc.
Thank you as I know all are busy!
Answers
-
Hi @Angie Votek
How is your data that you're looking to display currently stored in your sheets? For example, do you keep the historical data per-day in different rows, or is it a "live" sheet where one row is updated daily?
If you have one source sheet that is "live" but you want to chart historical data over time in order to see progress, I answered another post with a breakdown of how I would chart this data, here.
Point form process:
- Formulas in Sheet 1 calculate numbers each day
- A Copy Row workflow (in Sheet 1) runs once a week (or however often you need) to copy the data from Sheet 1 to Sheet 2
- A Record a Date workflow (in Sheet 2) runs when a new row is added to auto-populate that date.
- The Chart Widget is based off of Sheet 2's data, using the Date as the x-axis
Let me know if you have questions after taking a look at the other post!
Cheers,
Genevieve
