I’m trying to set up a Burndown chart for sprints. I have brought in all of the relevant entities into my report & have applied filters to only grab entities in Sprints with Status = Current & Team = relevant team.
When configuring my chart, I want the timeline to be dynamic & show the Min/Max dates of the relevant sprint, but I can’t figure out a way to get this result.
I currently have “Sprint Start Date” and “Sprint End Date” as formula fields on my Entities because I was having trouble referencing just the start/end dates of the Sprint I care about.
It seems that no matter what I do, the timeline will always look at ALL Sprint Start & End dates in my database, rather than just using my filtered dataset.
Is there a way to accomplish what I’m trying to do? This is the first time I haven’t been able to solve a Fibery challenge using the User Guide & some trial and error, but it seems like a basic function that is really missing from the platform.
(Still getting used to the forums, please bear with me)
Yes, I am making a historical report & have read the help guide.
I have filtered on the source to only entities that are linked to the Current Sprint & want to configure my X Axis to be the timeline where the MIN date is the Current Sprint’s Start Date and the MAX date is the Current Sprint’s End Date.
Currently, it’s pulling the earliest Start Date and latest End Date from my Sprints Database, rather than dynamically referencing the entities in the report.
My timeline formula is currently scripted as: AUTO(TIMELINE([Modification Date],[Modification Valid To],TRUE,MIN([Sprint Start]),MAX([Sprint End])))
My chart’s timeline is 9/29/2025-10/10/2025 using this formula, even though my current sprint only runs 10/6/2025 - 10/10/2025. This is because I have completed entities in my Task database with Sprint Start dates of 9/23. I am just trying to figure out how to get my chart’s timeline to match the dates of the current sprint.
I know I could use the Date filter on the source, but that will always be a static timeframe window (this week, last 30 days, etc) - when I need the dynamic dates because we run variable length sprints, depending on the current project workload.
When you use MIN([Sprint Start]) in a historical report formula/calculation, you are referring to the minimum value of this field for every entity in the source for their entire lifetime (not the current values).
In other words, even if your entities are source-limited to only those currently linked to Sprint X, if any of them have been linked to a prior Sprint, then the minimum value will not be the Start Date of Sprint X.