Forum Discussion
How caclculate TouchTime for Azure DevOps
Hello i want to calc Touch Time (sum working time by closed items per period in certain State). In my data set i have: Work Item Id - item State Time in Days - time in certain State State - St...
Hello
yes, fields in same table.
If I add to Filter "State" = "Closed" then will be incorrect, becase display measure will be calculte items with STATE={...}, but i want run measure ONLY for closed items. For example, i manual set filter by State = "Closed" , "In progress/Analytic", and see many items (some item have state=closed, some not, it means what filtering see different items closed and opened):
i think the first need filtereing closed item, for example list of closed items:
and futher use Work Item Id from this list for measure.
May be create new table with closed items and add additional condional to mesure [work item id] = table_closed_items[work item id]...but i don't know how does it do...