Given this odata string (right from MS docs), and I don't want a single team. I want a slicer for all teams.
"let Source = OData.Feed ("https://analytics.dev.azure.com/{organization}/{project}/_odata/v3.0-preview/WorkItemSnapshot? " &"$apply=filter( " &"WorkItemType eq 'User Story' " &"and (Teams/any(x:x/TeamName eq '{teamname}) or Teams/any(x:x/TeamName eq '{teamname}) or Teams/any(x:x/TeamName eq '{teamname}) " &"and StateCategory ne 'Completed' " &"and DateValue ge Iteration/StartDate " &"and DateValue le Iteration/EndDate " &"and Iteration/StartDate le now() " &"and Iteration/EndDate ge now() " &") " &"/groupby( " &"(DateValue,State,WorkItemType,Priority,Area/AreaPath,Iteration/IterationPath), " &"aggregate($count as Count, StoryPoints with sum as TotalStoryPoints) " &") " ,null, [Implementation="2.0",OmitValues = ODataOmitValues.Nulls,ODataVersion = 4]) in Source"
Why despite scouring the internet and this board for a month, I cannot replicate the simplest of Agile charts, the BurnDown filtered by a slicer for all TeamName(s) (see odata below), not Team, not TeamSK... using this odata string? I can get the total for all Teams easy. = OData.Feed("https://analytics.dev.azure.com/(insert org)/(insert project)/_odata/v4.0-preview/Teams?&$select=TeamName,TeamSK,ProjectSK", null, [Implementation="2.0"]) '''
Basically replicate the BurnDown widget in ADO.