Skip to content

How much data is loaded? #62

Answered by nbrown02
nbrown02 asked this question in Q&A
Mar 16, 2022 · 1 comments · 2 replies
Discussion options

You must be logged in to vote

For each Work Item table in the dataset, the amount of data is as follows:

Last 6 months of data:

  • WorkItems Bl0cked
  • WorkItems Blocked
  • WorkItems FlowEfficiency
  • WorkItems Blocked2
  • WorkItems Daily Blocked Count
  • WorkItems WIP Age
    (Note: this uses 6 months as they query any changes to any fields on work items, thus can be quite large)

Last 12 months of data (from the date of refresh)

  • WorkItems Completed
  • WorkItems In Progress
  • WorkItems In Progress2

If you'd like to change this to use more/less data, you need to go into Power Query Editor, go to the Source and change the highlighted number to be the number of months worth of data you'd like to query

Replies: 1 comment 2 replies

Comment options

nbrown02
Mar 16, 2022
Maintainer Author

You must be logged in to vote
2 replies
@angelo-i
Comment options

@nbrown02
Comment options

nbrown02 Oct 24, 2022
Maintainer Author

Answer selected by nbrown02
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Q&A
Labels
None yet
2 participants