# Building a sprint history chart **URL:** https://community.fibery.io/t/building-a-sprint-history-chart/2624 **Category:** Get Help **Created:** [March 10, 2022, 1:14pm UTC](https://community.fibery.io/t/building-a-sprint-history-chart/2624 "2022-03-10T13:14:43Z") **Posts on this page:** 3 **Page:** 1
### Author: ![pmackay](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/pmackay/32/3856_2.png) [@pmackay](https://community.fibery.io/u/pmackay) #### Post date: [March 10, 2022, 1:14pm UTC](https://community.fibery.io/t/building-a-sprint-history-chart/2624/1 "2022-03-10T13:14:43Z")
I’m trying to create a bar chart that shows sprints on x axis and a stacked bar of stories, bugs, tasks with DONE state on y axis. These types can be added to multiple sprints though. Is there a formula I could use to only show items in the last sprint they are associated with, rather than being included in every sprint column they are in? Thanks! ---
### Author: ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG) #### Post date: [March 10, 2022, 1:30pm UTC](https://community.fibery.io/t/building-a-sprint-history-chart/2624/2 "2022-03-10T13:30:19Z")
I suspect you would benefit from creating a formula field (in all of the story, bug and task databases) which extracts the latest linked sprint. Something like this: ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/8/8885bbaaa71a5f44d0601a2b59e5e4d49a8e74d8.png) You can then use this field as your x-axis in a report, and use a filter (State=Done) to only show the relevant stories/bugs/tasks. ---
### Author: ![pmackay](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/pmackay/32/3856_2.png) [@pmackay](https://community.fibery.io/u/pmackay) #### Post date: [March 10, 2022, 5:24pm UTC](https://community.fibery.io/t/building-a-sprint-history-chart/2624/3 "2022-03-10T17:24:58Z")
That’s great, thanks @Chr1sG !