Forum Discussion
Calculating time difference...
Hi guys, I have a dataset with the history of changes to items. Some of those items have been 'tagged' as blocked on certain dates. Whilst I've managed to calculate the total time an item has sp...
Anonymous , Create a new column like and try
new column =
datediff(maxx(filter(table, [workitemid] = earlier([workitemid]) && [index] = earlier([index]) -1 && [Tagname] =earlier([Tagname]) && [Tagname] ="Blocked"),[ChangedDate]),[ChangedDate] ,minute)/60*24