Question 289422 in Azure Question posted in
The official documentation to get you started can be found here.

Azure DevOps – Query chart chronological iteration paths

can someone help me show my query graph in chronological order? Here’s what I have now:

  • A query listing out any user stories that have the tag ‘unplanned’ in a bunch of area paths.
  • A chart: Chart configurations

I’d like to showcase on the Y axis the iterations in chronological order, not the amount of most unplanned items. FYI, the aggregation can only be ‘Count’.

I have tried to change the query to only show results for the current iteration path, but this gave an error in the query. Also, it’s a less useful view.

I have tried different formats and played around with the available graphs.

Thanks!

Tags:

2

Answers


  1. 0

    Unfortunately, Azure DevOps charts have quite limited functionality. I would suggest to review 3rd party tools like PowerBI that can give ability to do custom order of your data.

    Login or Signup to reply.
  2. 0

    If the order of the strings of your "iteration path" is consistent with the order of the date range corresponding to the iteration, you may consider using the widget "Chart for Work Items".

    1. Create a query with the following defination.
      enter image description here

    2. Add a widget Chart for Work Items to the dashboard.
      enter image description here

    • Query: The query you created in the first step.
    • Chart type: Stacked bar
    • Y-axis: Iteration Path
    • Sort: Label – Descending/Ascending

    If the order of your "iteration path" string is inconsistent with the order of its corresponding dates, it’s suggested that you could submit a feature request on:
    https://developercommunity.visualstudio.com/report?space=21&entry=suggestion, since there is no such a default chart that can meet your needs.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search