Using Rich Filters to create a Sprint History table, mimicing the Sprint Report/Velocity Chart, which exclude all items in a sprint that are not finished in that sprint. Rich Filters do not automatically exclude these items. In Rich Filters, once an item is in a sprint, even if it is rolled-over to a newer sprint, it will be counted in the older sprint and the newer sprint simultaneously -- this messes up counts in tables created with Rich Filters. SO, I need a query that excludes from a sprint items that are not completed in a sprint, and also excludes items that were completed in a sprint but which were re-opened in later sprints. Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.