title: Azure DevOps - The time a WorkItem spends in specific columns on the kanban board
body: <p>I would like to report about the days features spend in each column of our kanban-board.</p>
  <p>So for an example output I want, we have a kanban with columns:</p>
  <pre><code>Funnel           --&gt; Workitem X spend 10 days in here
  Analyzing        --&gt; Workitem X spend 13 days in here
  Backlog          --&gt; Workitem X spend  3 days in here
  Implementing     --&gt; Workitem X spend 11 days in here
  Done             --&gt; Workitem X spend 50 days in here
  </code></pre>
  <p>So far I tried with</p>
  <ul>
  <li>Analytic Views: There is no BoardColumn that can be added to the output fields</li>
  <li>OData: Found a way to get the column-value (BoardLocation), based on the current WorkItem state</li>
  <li>OData: WorkItemSnapshot(to get Historic Data) does not support BoardLocation.</li>
  </ul>
  <p>Do you guys know of any way that I can retrieve historic data on features and their BoardColumns?</p>
  <p>thanks in advance,
  Joost</p>