How to: Area and Iteration organization charts on Azure DevOps

https://analytics.dev.azure.com/{Organization}/_odata/v4.0-preview
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])
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])

--

--

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