Is there a way to make charts that 'roll' automatically? I'm thinking in particular about date-based rolling, like a data series chart that tracks iteration story points completed to get velocity over the last, say, six or three months (or both) worth of iterations.
I was hoping to use MQL, something along the lines of WHERE 'Start Date' > TODAY - 180, but I can't seem to do date-arithmetic that way. Any advice on ways to do this?
Comments
1 comment
We have a story to implement this in the future.
Right now, there isn't a great workaround. You could use a project variable so that you at least don't have to version the page each day, but updating a project variable every day isn't a lot of fun either. We have a future story to add a project variable API, so you could at least update the project variable each day with a cron job. We will update this post when either of those stories is implemented.
Please sign in to leave a comment.