topic Re: Azure DevOps Boards Analytic View Date Field in Developer

Azure DevOps Boards Analytic View Date Field

c_avu — Thu, 17 Oct 2024 09:02:52 GMT

Hello

I need some help with Analytic Views.

I have created a Custom view in Azure DevOps Boards Analytic views.
I created Custom view with fields AreaPath, Assigned To, Iteration Path, Remaining Work, State, Title, Workitem Id, Work Item Type.

I have connected to this view from power Bi desktop using Azue Devops Boards only connector and loaded the data.

now in the loaded dataset i see two new columns Date, Is Current along with my fields i selected before.

I'm trying to understand from where this Date and Is Current data is being pulled in / generated ??

Can anyone knows what it is ?

My Custom Anlaytic View fields
Dataset in Power Bi

Re: Azure DevOps Boards Analytic View Date Field

Expiscornovus — Thu, 17 Oct 2024 10:43:40 GMT

Hi @c_avu,

Can you share the rest of the settings of your view?

Normally you can specificy if a sprint is the current sprint. So, Is Current sounds a lot like the property of the Sprint 18 itself.

Re: Azure DevOps Boards Analytic View Date Field

c_avu — Thu, 17 Oct 2024 11:00:07 GMT

For this view I have applied filter for Sprint.
But, I have other view with no filters, this 'Is Current' is being added there as well.

It seems this additional 'Date' and 'Is Current' columns are related and somehow being pulled into dataset.

Couldn't figure out how these additional columns data is being generated, it must be from the entites WorkitemRevisions, WorkitemSnapshot entities.

Re: Azure DevOps Boards Analytic View Date Field

c_avu — Thu, 17 Oct 2024 11:17:40 GMT

Re: Azure DevOps Boards Analytic View Date Field

Expiscornovus — Thu, 17 Oct 2024 12:14:55 GMT

Hi @c_avu

Thanks for sharing. I see the difference with my view (where I wasn't seeing this fields).

You are using a Rolling period of 60 days in your History settings, instead of the Current only view. That's why you are getting the Date and Is current columns in your data set.

Those fields can be used to have a look at historic data in your view:

https://learn.microsoft.com/en-us/azure/devops/report/powerbi/analytics-views-create?view=azure-devops#history

Re: Azure DevOps Boards Analytic View Date Field

c_avu — Fri, 18 Oct 2024 07:46:51 GMT

Yes, It seems like Date field is pulling data from one of DateValue/DateSK columns from snapshot table.

Re: Azure DevOps Boards Analytic View Date Field

Anonymous — Mon, 21 Oct 2024 02:20:51 GMT

Thanks for the reply from Expiscornovus , please allow me to provide another insight:

Hi, @c_avu

Could you please let us know if Expiscornovus's response resolved your issue? If it did, kindly accept it as the solution.

If you have your own solution, feel free to share it. This will help other community members with similar issues find a resolution more quickly.

Regarding your question, you may also find the following link helpful:

Create an Analytics view - Azure DevOps | Microsoft Learn

Below are screenshots of the relevant documentation:

Of course, if you have any new discoveries or questions, please feel free to get in touch with us.

Thank you in advance

Best Regards,

Leroy Lu

Re: Azure DevOps Boards Analytic View Date Field

Expiscornovus — Mon, 21 Oct 2024 06:32:40 GMT

Hi @Anonymous,

That is the same link as I shared 😉