Comments (7)
Hi, @jenniferrosemitchell21! I had to edit the query of every table and add a filter parameter to limit my query to a specific areaPath. Here is an example of a table called "WorkItems Bl0cked"
Edited Query
= OData.Feed(#"Http/Https" & "://" & #"Analytics URL/Azure DevOps Server" & "/" & Organization & "/" & Project & "/_odata/v3.0-preview/WorkItemRevisions?" & "$apply=filter(" & "StateCategory ne 'Proposed'" & "and startswith(Area/AreaPath,'Systems\Opportunity')" & "and WorkItemType ne 'Issue'" & "and WorkItemType ne 'Task'" & "and WorkItemType ne 'Test Case'" & "and WorkItemType ne 'Test Plan'" & "and WorkItemType ne 'Shared Parameter'" & "and WorkItemType ne 'Shared Steps'" & "and WorkItemType ne 'Test Suite'" & "and WorkItemType ne 'Impediment'" & "and WorkItemType ne 'Epic'" & "and WorkItemType ne 'Feature'" & "and ChangedDate ge 2023-10-01T00:00:00Z" & ")", null, [Implementation="2.0", OmitValues=ODataOmitValues.Nulls, ODataVersion=4])
from flowviz.
Hi there,
Thanks for sharing.
Is this a large ADO project? The error is one typically seen with a timeout due to a large dataset (I have several reports on a scheduled refresh not seeing any errors).
The workaround would be to change those tables and their queries to be a shorter date range...
from flowviz.
Yes, it is a huge project. They have over 50 teams on this project.
I've tried to change one query, but with no success.
Original query: = OData.Feed(#"Http/Https" & "://" & #"Analytics URL/Azure DevOps Server" & "/" & Organization & "/" & Project & "/_odata/v3.0-preview/WorkItemRevisions?" & "$apply=filter(" & "StateCategory ne 'Proposed'" & "and WorkItemType ne 'Issue'" & "and WorkItemType ne 'Task'" & "and WorkItemType ne 'Test Case'" & "and WorkItemType ne 'Test Plan'" & "and WorkItemType ne 'Shared Parameter'" & "and WorkItemType ne 'Shared Steps'" & "and WorkItemType ne 'Test Suite'" & "and WorkItemType ne 'Impediment'" & "and WorkItemType ne 'Epic'" & "and WorkItemType ne 'Feature'" & "and ChangedDate ge 2023-06-01T00:00:00Z" & ")", null, [Implementation="2.0", OmitValues=ODataOmitValues.Nulls, ODataVersion=4])
New Query: = OData.Feed(#"Http/Https" & "://" & #"Analytics URL/Azure DevOps Server" & "/" & Organization & "/" & Project & "/_odata/v3.0-preview/WorkItemRevisions?" & "$apply=filter(" & "StateCategory ne 'Proposed'" & "and Area Path eq 'Project\Systems\Opportunity to Cash'" & "and WorkItemType ne 'Issue'" & "and WorkItemType ne 'Task'" & "and WorkItemType ne 'Test Case'" & "and WorkItemType ne 'Test Plan'" & "and WorkItemType ne 'Shared Parameter'" & "and WorkItemType ne 'Shared Steps'" & "and WorkItemType ne 'Test Suite'" & "and WorkItemType ne 'Impediment'" & "and WorkItemType ne 'Epic'" & "and WorkItemType ne 'Feature'" & "and ChangedDate ge 2023-06-01T00:00:00Z" & ")", null, [Implementation="2.0", OmitValues=ODataOmitValues.Nulls, ODataVersion=4])
When I tried to change this query, got the following error:
ps: I'm not a developer, so maybe a simple detail that I'm missing.
from flowviz.
So there is a thread in discussions on area path filtering - #33
I'd also try change the date range, as it is loading from June 1st (2023-06-01) it might make sense to start from say September (2023-09-01)
from flowviz.
Hi, @nbrown02 ! Just to let you know that this work around has worked to me.
Thank you for the support
from flowviz.
from flowviz.
@orlando-noda Hi there, Would you mind sharing how you restricted your data? Which Query did you do this in? I've looked at the queries but none of them mirror your paste above.
from flowviz.
Related Issues (20)
- Black box for hover over info, Efficiency Page HOT 9
- Average Bug age
- How to keep duplicate columns from showing in Time in Board Column view? HOT 1
- Number of Days Blocked Count incorrect HOT 17
- Issue connecting FlowViz (Organization) to our ADO Organization HOT 11
- Trouble connecting to FlowViz (Project) HOT 12
- Tooltip showing 'blank' week commencing date for some weeks HOT 7
- FlowViz Efficiency potentially duplicating day count between old and columns HOT 3
- Unable to load data into Power Bi HOT 1
- Days Lost to being Blocked Graph - potential error HOT 3
- Error : Access to the resource is forbidden HOT 3
- Visuals for Forecast uncertified HOT 1
- Forecasting tab not working in PowerBI Desktop Reporting Server HOT 1
- Failure to load Data HOT 5
- Unable to open template without power bi report server HOT 1
- Wiki article "How much Work Item data is loaded?" out of date? HOT 1
- Error - Unable to connect to the Organization HOT 6
- D3 Visual on Forecast page freezes in web service HOT 1
- Forecast page freezes when trying to change input filters HOT 6
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from flowviz.