Sprints in Time Dimension


I would like to use the Time Dimension that would be displayed in sprint “range”.
I have managed to do this by adding a member in the Time Dimension for each of my sprints but is it possible to do this automatically?

Thank you!

Hi Vero,

Creating manual time members is one possible solution. For automatisation if your sprints are strictly by weeks (each 2 or 3 weeks), you may create a new hierarchy in Time dimension, with 2 or 3 weeks long periods. Read more: https://docs.eazybi.com/display/EAZYBIJIRA/Create+reports#Createreports-AddcustomhierarchiestoTimedimension

Another option is using standard Time dimension members, but modifing sprint measures so they would appear against time members where sprints were started/completed.
You may want to check out our demo report for sprint cycles where Timeline is used instead of Sprint on x axis, and all measures are modified to show values to corresponding sprint start and end dates: https://eazybi.com/accounts/1000/cubes/Issues/reports/185871-sprint-cycles-report-by-time .

Ilze / support@eazybi.com