How to: Area and Iteration organization charts on Azure DevOps

https://analytics.dev.azure.com/{Organization}/_odata/v4.0-preview
  • After the connection, the following tables were selected:
  • After that, it’s necessary to create two custom columns into Areas and Iteration tables. These columns are required to use on Hierarchy Chart by Akvelon
  • Table Areas
FatherArea = IF ( Areas[Depth]=0,"",IF(Areas[Depth]=1,Areas[AreaLevel1],IF(Areas[Depth]=2, Areas[AreaLevel1] & "\" & Areas[AreaLevel2],IF(Areas[Depth]=3,Areas[AreaLevel1] & "\" & Areas[AreaLevel2] & "\" & Areas[AreaLevel3],IF(Areas[Depth]=4,Areas[AreaLevel1] & "\" & Areas[AreaLevel2] & "\" & Areas[AreaLevel3] & "\" & Areas[AreaLevel4],IF(Areas[Depth]=5,Areas[AreaLevel1] & "\" & Areas[AreaLevel2] & "\" & Areas[AreaLevel3] & "\" & Areas[AreaLevel4] & "\" & Areas[AreaLevel5],Areas[AreaLevel1] & "\" & Areas[AreaLevel2] & "\" & Areas[AreaLevel3] & "\" & Areas[AreaLevel4] & "\" & Areas[AreaLevel5] & "\" & Areas[AreaLevel6]))))))FatherNumber = LOOKUPVALUE(Areas[Number],Areas[AreaPath],Areas[FatherArea])
  • Table Iterations
FatherIteration = IF (Iterations[Depth]=0,"",IF(Iterations[Depth]=1,Iterations[IterationLevel1],IF(Iterations[Depth]=2, Iterations[IterationLevel1] & "\" & Iterations[IterationLevel2],IF(Iterations[Depth]=3,Iterations[IterationLevel1] & "\" & Iterations[IterationLevel2] & "\" & Iterations[IterationLevel3],IF(Iterations[Depth]=4,Iterations[IterationLevel1] & "\" & Iterations[IterationLevel2] & "\" & Iterations[IterationLevel3] & "\" & Iterations[IterationLevel4],IF(Iterations[Depth]=5,Iterations[IterationLevel1] & "\" & Iterations[IterationLevel2] & "\" & Iterations[IterationLevel3] & "\" & Iterations[IterationLevel4] & "\" & Iterations[IterationLevel5],Iterations[IterationLevel1] & "\" & Iterations[IterationLevel2] & "\" & Iterations[IterationLevel3] & "\" & Iterations[IterationLevel4] & "\" & Iterations[IterationLevel5] & "\" & Iterations[IterationLevel6]))))))FatherNumber = LOOKUPVALUE(Iterations[Number],Iterations[IterationPath],Iterations[FatherIteration])
  • After creating all columns, it’s possible to create a report using Hierarchy Chart by Akvelon:
  • Area organization chart
  • Iteration organization chart

--

--

--

Tech Solution Architect Manager na Accenture

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Ultimate Agile Mythbusting Guide

A not-so hypothetical outage report / non-official RFO aka Post-Mortem assignment

Self Closure Memory leak fixes using Weak and Unowned

BigQuery vs Snowflake: The Definitive Guide

Easiest and higher value array methods of Dart programming.

CSS Crash Course for Beginners -5

RabbitMQ: The need for large scale Applications

Graphs and Networks Part II: Widely-used Algorithms

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Vinicius Moura

Vinicius Moura

Tech Solution Architect Manager na Accenture

More from Medium

💪Deploy Cortex Certifai using Infrastructure-as-Code with Bicep Language

How to: Team Projects, Fields, and Picklists Mapping on Azure DevOps

Getting setup quickly with Dependency-Track using Azure Container Instances

Basic-Create Azure Resource Group using Terraform