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

How to Manage and Measure Exploratory Testing using Session-Based Test Management

Boosting image processing performance, from ImageMagick to Libvips

How to Automatically Generate Data Structure for Sankey Diagrams

Rising Need For A Reliable Document Management System

CentOS/RHEL 7 first deploy: simple, minimal, and functional server

AWS Solutions Architect Associate: Store Data using Amazon RDS, Aurora & Database Migration Service

AWS Solutions Architect Associate Complete Course: Amazon RDS & Aurora

Azure Automation Configuring Desired State Configuration

Getting Started with TeleportHQ

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

How to: Release Badges Dashboard on Azure DevOps

💪Deploy a Self-hosted Octopus Server🐙 using Bicep Language

Test Azure Terraform code with Terratest

Simple multi-stage CICD YAML pipeline for Azure DevOps