CODEWITHSUNDEEP
azure-devops
aBlaze
aBlaze

Reputation: 2716

Is it possible to create a rollup column for a query?

I am attempting to create a rollup column for Feature 123 to sum up story points for all User Stories who have Feature 123 as a parent. Furthermore, I would like this rollup column to show up as a query result.

However, I noticed that if I click "Queries", there is no "Add a rollup column". How can I configure Azure DevOps so that the "Add a rollup column" shows up underneath "Add a column"?

enter image description here

Here is some rollup column documentation I've been following.

Upvotes: 3

Views: 9400

Answers (1)

Levi Lu-MSFT
Levi Lu-MSFT

Reputation: 30343

Add a rollup column feature is not supported for Queries. Please check document here for where Rollup can be used.

Alternatively you can create a flat list query that sums the values of a field you specify as described in above document. Check here for more information about work tracking charts.

You can also submit a feature(Click suggest a feature and choose Azure devops) to Microsoft development team, hope they will consider adding rollup feature to query results.

Upvotes: 4

Related Questions