An advanced query tile with support for all queries and more options to show the information you need.
Query Tile PRO
Ever wanted an more advanced query tile ? Advanced Query Title supports all queries and gives you more options and control to show the information you need.
Support for all queries
Advanced Query Tile supports all query types, and gives you control on what data in the query to include :
All work items
Top level work items
Child work items
Examples
Sum and Average You can summarize field values , like delivered story points or business value. You can also calculate the average of field values.
Min and Max You can calculate min and max values on all fields, including text & date fields. Clicking on the tile will take you to the corresponding work item.
Advanced expressions With expressions you can create your own formula and summarize or calculate the average of the value. For exampel calculate how many % of the work items reached active state within 4 hours.
Lead time Lead time is calculated as the time elapsed from created until closed. This is a simple calculation based on the timestamps and doesn't include revisits.
Cycle time Cycle time is calculated as the time elapsed from activated until closed. This is a simple calculation based on the timestamps and doesn't include revisits.
Prerequisites
Visual Studio Team Services
Team Foundation Server 2015 Update 3 (or higher)
Feedback
We need your feedback! Here are some ways to connect :
If you like this extension, please leave a review. If you have suggestions or issues, please reach out to me on extension-support@mskold.com to give me a chance to fix it.