Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am confused. I want to show days per Story points in a box plot. If I use a bar chart, my formula works and shows the bars as I want it to show. But the boxplot says that it can't show due to undefined values.
Here is my formula:
=Sum(([Completed Date]-[Started Date])/[Story Points])
note that "completed date" and "started date" are dates which are computed in days.
I'm going to have a guess seeing no one else has offered to help you.
Maybe try the interval function. So...
=Sum(Interval([Completed Date]-[Started Date],'d')/[Story Points])