Forum Discussion

Kiggsworthy's avatar
Kiggsworthy
Regular Visitor
7 years ago
Solved

help showing when priority changed on work items in azure devops

I have what I think is a very straightforward need, but it is proving remarkably difficult to achieve in practice. I don't think there's any way to do this in azure devops directly which is why I am ...
Need Help
Tutorial Requests
  • parry2k's avatar
    parry2k
    7 years ago

    Kiggsworthy Add new column like this

     

    Is Today Priority 1 =
IF( 
( Table[CreateDate] ) = TODAY() || Table[Date] = TODAY() ) && 
Table[Priority] = 1, 
1, 
0
)

    Add new measure to get count of todays priority

     

    Today's Priority Count = SUM( Table[Is Today Priority 1] )

     

Kiggsworthy's avatar
Kiggsworthy
Regular Visitor
7 years ago

This is a great community such fast responses thank you!

 

So it is in the data:

 

 

Here is an example of a work item that I want on the report I am trying to build.

 

It has existed for 10 days, but only today it was updated to priority 1.  So on my "Todays' P1s" report, I want this item to show. I would like a simple table report that is just a list of the work item with ID, title, who it is assigned to, etc. And I just want that list to contain

* Items that are P1 that were created today (easy)

* Items that are P1 that *changed to* P1 today (like in the above screenshot)

Thank you for your responses and hopefully someone can help me do this :) 

ntaylo06's avatar
ntaylo06
Icon for Resolver II rankResolver II
7 years ago

Thanks for the screenshot, but can you post it again without covering up the field names? It is hard to help when we can't see them. 

  • Kiggsworthy's avatar
    Kiggsworthy
    Regular Visitor
    7 years ago

     

    haha, sorry about that

    • Kiggsworthy's avatar
      Kiggsworthy
      Regular Visitor
      7 years ago

      and here is where I was able to figure out the first part (items that were created today w/ p1):

       

       

      so I just need to find a way to add the items that *changed* today to P1.

       

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      7 years ago

      Kiggsworthy Add new column like this

       

      Is Today Priority 1 =
IF( 
( Table[CreateDate] ) = TODAY() || Table[Date] = TODAY() ) && 
Table[Priority] = 1, 
1, 
0
)

      Add new measure to get count of todays priority

       

      Today's Priority Count = SUM( Table[Is Today Priority 1] )