Right now, my team lead is asking to figure out how to get a chart of the Bug work items opened in ADO over the past three months, separated into one of three categories: one for items created less than thirty days ago, one for items created between thirty and sixty days ago, and one for items created between ninety and sixty days ago. This chart was given as an example:
I’ve been able to create three separate queries under Boards -> Queries to create charts for items created 30/60/90 days ago, using this format:
I’ve looked it over and far as I can tell there’s no way to combine these three queries into one in a way that can be graphed as three separate columns for each age category. I have a feeling this is something that’s going to need to be charted manually outside of ADO’s built-in tools, but does anyone know if there’s something else I might have missed that could help?